OraFAQ Forum: Networking and Gateways » ORA-12505: TNS:listener does not currently know of SID given in connect des

Home » RDBMS Server » Networking and Gateways » ORA-12505: TNS:listener does not currently know of SID given in connect des

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12505: TNS:listener does not currently know of SID given in connect des [message #180074]

Fri, 30 June 2006 02:01

czetsuya
Messages: 4
Registered: June 2006
Location: Philippines

Junior Member

Hi! i have installed an Oracle10g on Windows Server2003 R2 machine and it was functioning fine. But when I restart the server I got ORA-12505 error. I wonder if anyone can help me in my problem. Thank you.
Here are my configuration files:
# tnsnames.ora Network Configuration File:

C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

PCMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = aamoracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pcms)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

# listener.ora Network Configuration File:

C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = aamoracle)(PORT = 1521))
)
)

Thank you and good day.

Report message to a moderator

Re: ORA-12505: TNS:listener does not currently know of SID given in connect des [message #180104 is a reply to message #180074]

Fri, 30 June 2006 02:58

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

$ oerr ora 12505
12505, 00000, "TNS:listener could not resolve SID given in connect descriptor"
// *Cause:  The SID in the CONNECT_DATA was not found in the listener's tables.
// *Action: Check to make sure that the SID specified is correct.
// The SIDs that are currently registered with the listener can be obtained by
// typing "LSNRCTL SERVICES <listener name>". These SIDs correspond to
// SID_NAMEs in TNSNAMES.ORA, or db_names in INIT.ORA.
// *Comment: This error will be returned if the database instance has not
// registered with the listener; the instance may need to be started.

Try to dynamically register the database with your listener:

SQL> ALTER SYSTEM REGISTER;

Alternatively, use static registration (add your DB to the SID_LIST_LISTENER specification).

For more details, refer to the Net Administrators Guide.

Report message to a moderator

Re: ORA-12505: TNS:listener does not currently know of SID given in connect des [message #180300 is a reply to message #180074]

Mon, 03 July 2006 00:34

czetsuya
Messages: 4
Registered: June 2006
Location: Philippines

Junior Member

Thanks for the info Frank. I have just fixed the problem just now.
All I did was changed the listener.ora add the database name go to prompt start sqlplus /nolog log as sysdba and startup. But I still wonder why the Oracle database would not start on its own in windows 2003 r2 while it does smoothly on windows xp pro. i have done the same configurations but different outcomes.

Thanks.

Report message to a moderator

Previous Topic:	Connecting Two Server using a Client Machine
Next Topic:	Firewall issue: TCP connection timeout while processing long query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 09:22:39 CDT 2024