Test Data Manager

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

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

    Posted Mar 02, 2018 01:44 PM

    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