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)
)
)
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:
Post a Comment