This discussion is archived
1 Reply Latest reply: Dec 8, 2012 7:33 PM by EBSDBA RSS

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

EBSDBA Expert
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points