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