gilta03

Tech Tip- Datamaker: Create an Oracle Profile- Error ORA-12505

Discussion created by gilta03 Champion on Mar 2, 2018

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. 

 

To see the resolution to this issue, please visit https://comm.support.ca.com/kb/datamaker-create-an-oracle-profile-error-ora-12505/kb000072364 

Outcomes