Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-12505 Can't resolve SID after installing patches

Status
Not open for further replies.

encl

MIS
Dec 27, 2007
3
US
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
 
Hi Dima,

Yes we do, but the problem has been resolved. Not 100% why, but I came in the next day and all was good. I'm guessing our backup/shutdown scripts did something.

Regards,

Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top