ORA 12505: The TNS Listener does not currently know of SID given in connect descriptor
|Article:TECH182533|||||Created: 2012-02-28|||||Updated: 2012-02-28|||||Article URL http://www.symantec.com/docs/TECH182533|
Getting this ORA 12505 error when querying an Oracle target from CCS Oracle
ORA 12505: Unable to establish connection with the database , scope is database xxx on server xxxxx . Additional information : ORA 12505: The TNS Listener does not currently know of SID given in connect descriptor
Oracle 9i , 10g , 11g
CCS 8.5, 8.6, 9.0. 10.0 , 10.5
Incorrect SID used or Incorrect Service name used
- Get the listener.ora from the oracle server and verify if the SID mentioned for the listener is the same one you have used when configuring the target in CCS Oracle
- verify if the service name if used is the correct service name from the TNSNAMES.ora file
One of the reasons that you are getting this error is because you have used the incorrect name of either the SID or the service name while configuring the target oracle database in BV Control for Oracle.
When you have verified if the name used is incorrect, you will require to remove the target and re-register the target ( oracle database ) with BV Control for Oracle by running the configuration wizard.
Article URL http://www.symantec.com/docs/TECH182533