Monday 22 April 2013

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

Cause :The instance will not register with the listener.

Solustion:
Edit your listener.ora like this:
SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
       (SID_NAME = ABC)
       (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
     )
     (SID_DESC =
       (SID_NAME = CLRExtProc)
       (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
       (PROGRAM = extproc)
     )
  )

No comments: