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.
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 184.108.40.206 How to Create ODBC Connections for Oracle
if helpful pls mark correct/helpful