Datamaker: Create an Oracle Profile- Error ORA-12505

Document ID : KB000072364
Last Modified Date : 28/02/2018
Show Technical Document Details
Issue:
How do I create an Oracle Datamaker profile? When I tried to test the connection I received the following error:

Error: Unable to connect to Database.
Profile: test
Title: Data Source Database
Error Message: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Transaction Error Code: -1 Database Error Code: 12505

The problem is that in the parameters I don't have the option to indicate the SID for the database.
I can't create a new connection profile in the Test Data Manager Portal either due to this error: "Failed to create a New Profile".

Using SQLPlus the test was successful. 
Environment:
CA Test Data Manager (TDM)- Datamaker and TDM Portal
Cause:
Resolution:
Here are instructions on how to create an Oracle connection profile in the Portal and Datamaker: 
- Create a connection profile (Portal): https://docops.ca.com/ca-test-data-manager/4-4/en/provisioning-test-data/defining-test-data/defining-test-data-using-the-ca-tdm-portal/create-a-connection-profile 
- Create a connection profile (Datamaker): https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/connect-to-test-data-source-and-target-databases 

SID = unique name of the INSTANCE (e.g. the oracle process running on the machine). Oracle considers the "Database" to be the files. 

Service Name = alias to an INSTANCE (or many instances). The main purpose of this is if you are running a cluster, the client can say "connect me to SALES.acme.com", the DBA can on the fly change the number of instances which are available to SALES.acme.com requests, or even move SALES.acme.com to a completely different database without the client needing to change any settings. 

Oracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames.ora file on your clients and it can be the same as SID and you can also give it any other name you want. 

SERVICE_NAME is the new feature from oracle 8i onwards in which database can register itself with listener. If database is registered with listener in this way then you can use SERVICE_NAME parameter in tnsnames.ora otherwise - use SID in tnsnames.ora.

So for Datamaker, you should be able to enter the SID where you enter the Service_Name in the Oracle connection profile settings if in the tnsnames.ora file has the SID name. 

For the Portal, you have to use an Oracle Service Name. TNS names are not supported, so I do not think that even if you have the SID in the tnsnames.ora file, it will be accepted. 

We'll also need to make sure the tnsnames.ora file from <ORACLE_HOME>\Network\Admin is copied into the following locations: 
C:\Program Files (x86)\Grid-Tools\GTDatamaker 
C:\Grid-Tools\TDoD\TDoD_ConfigEditor\libraries 
 
Additional Information:
If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html