1 Reply Latest reply: Dec 8, 2012 9:33 PM by EBSDBA RSS

    While configuring Data sources for dac, it fails with ORA-12505

    EBSDBA
      Hi,

      I am configuring EBS as physical data source for DAC Client. After entering all the connection details, it throws

      Failure connecting to "ORA_R1211"!
      Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.


      I can connect to EBS instance with sqlplus with the same tnsnames entry.

      Any help is appreciated.

      tHANKS
        • 1. Re: While configuring Data sources for dac, it fails with ORA-12505
          Ahsan Shah
          seems like a common connection issue. Test the following:

          1. Can you tnsping the DB service from the DAC server as the DAC OS process owner? If not, fix the issue or ask the DBA why you cannot.
          2. Do you set up the proper .jar libraries (ojdbc6.jar file in the \lib directory on the client machine) when setting up DAC.
          3. Did you follow the steps here: Section 4.7.4.1 How to Create ODBC Connections for Oracle

          if helpful pls mark correct/helpful