Hi All,
I've got a Windows 2003 box running an Oracle 9.2 DB. I installed the latest and greatest patches, including SP2, now I can't log into the DB because it can't resolve the SID.
Error Message: ORA-12505: TNS:listener could not resolve SID given in connect descriptor.
The SID hasn't changed, only the patches and SP have been installed.
TNSPing works fine.
LSNRCTL Status Output:
LSNRCTL for 32-bit Windows: Version 9.2.0.8.0 - Production on 27-DEC-2007 15:47:43
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.8.0 - Production
Start Date 27-DEC-2007 15:33:15
Uptime 0 days 0 hr. 14 min. 27 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora92\network\admin\listener.ora
Listener Log File C:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.domain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ENCAD_IPCipc)))
Services Summary...
Service "ENCAD (ORACLE_HOME = C:\oracle\ora92" has 1 instance(s).
Instance "ENCAD (ORACLE_HOME = C:\oracle\ora92", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL Service Output:
LSNRCTL for 32-bit Windows: Version 9.2.0.8.0 - Production on 27-DEC-2007 15:48:10
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST)(PORT=1521))(CONNECT_DATA=(SID=ENCAD)(GLOBAL_NAME=ENCAD.us.domain.com)))
Services Summary...
Service "ENCAD (ORACLE_HOME = C:\oracle\ora92" has 1 instance(s).
Instance "ENCAD (ORACLE_HOME = C:\oracle\ora92", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
TIA,
Mike
I've got a Windows 2003 box running an Oracle 9.2 DB. I installed the latest and greatest patches, including SP2, now I can't log into the DB because it can't resolve the SID.
Error Message: ORA-12505: TNS:listener could not resolve SID given in connect descriptor.
The SID hasn't changed, only the patches and SP have been installed.
TNSPing works fine.
LSNRCTL Status Output:
LSNRCTL for 32-bit Windows: Version 9.2.0.8.0 - Production on 27-DEC-2007 15:47:43
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.8.0 - Production
Start Date 27-DEC-2007 15:33:15
Uptime 0 days 0 hr. 14 min. 27 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora92\network\admin\listener.ora
Listener Log File C:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host.domain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ENCAD_IPCipc)))
Services Summary...
Service "ENCAD (ORACLE_HOME = C:\oracle\ora92" has 1 instance(s).
Instance "ENCAD (ORACLE_HOME = C:\oracle\ora92", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL Service Output:
LSNRCTL for 32-bit Windows: Version 9.2.0.8.0 - Production on 27-DEC-2007 15:48:10
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST)(PORT=1521))(CONNECT_DATA=(SID=ENCAD)(GLOBAL_NAME=ENCAD.us.domain.com)))
Services Summary...
Service "ENCAD (ORACLE_HOME = C:\oracle\ora92" has 1 instance(s).
Instance "ENCAD (ORACLE_HOME = C:\oracle\ora92", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
TIA,
Mike
