Home » RDBMS Server » Networking and Gateways » ORA-12505
ORA-12505 [message #152085] Tue, 20 December 2005 22:59 Go to next message
sam_jo98
Messages: 5
Registered: December 2005
Location: Phil
Junior Member
Hi,

I'm installing Oracle 10g on my computer with Windows XP pro OS. The installation is ok then when i restarted my computer then open the Database Control the LISTENER won't start and i got an error message "ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)".

And also here's my listener.ora and tnsnames.ora

**************************************************************

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\network\admin\listener.ora
# Generated by Oracle configuration tools.

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


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.219)(PORT = 1521))
)
)
)




**************************************************************

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

XBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.219)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XBC)
)
)
Quote:





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


**************************************************************


Thanks,

Sam
Re: ORA-12505 [message #152094 is a reply to message #152085] Wed, 21 December 2005 01:22 Go to previous messageGo to next message
jaigouda
Messages: 2
Registered: July 2005
Location: Bangalore
Junior Member

Hi,
As the error itself suggets the answer,Change the SID name in ur listener.ora file.

ie (SID_NAME = PLSExtProc) to (SID_NAME = XBC)

Regards
jai
Re: ORA-12505 [message #171383 is a reply to message #152085] Tue, 09 May 2006 10:52 Go to previous messageGo to next message
mikehibbett
Messages: 2
Registered: May 2006
Junior Member
I too am getting this error. Did you manage to solve it? Perhaps you, or someone else, may be able to help.

The suggestion that followed your email did nothing.

Mike.
Re: ORA-12505 [message #171385 is a reply to message #152085] Tue, 09 May 2006 11:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
most likely the listener.ora file is malformed.
Start with $ORACLE_HOME/network/admin/samples/listener.ora
and customize for your environment
Re: ORA-12505 [message #171716 is a reply to message #171385] Thu, 11 May 2006 03:55 Go to previous messageGo to next message
mikehibbett
Messages: 2
Registered: May 2006
Junior Member
Thank you for your suggestion but the listener.ora and tnsnames.ora appear correct, and have certainly not changed from the point of installation.

I have found how to cure the problem however. It seems that Oracle 10g Release 2 does not like being installed on the same logical drive as the operating system. I have a Win 2003 Server PC configured with two logical drives, C and D. C is NTFS, D is FAT32. The OS is on C. If I install Oracle on C, with the OS, then it exhibits the problem. If I install it on D, the FAT32 drive, then there is no problem.

Oracle 10g Rel 1 does not show the same problem.

There is loads of space free on both drives ( > 10GB )

Is there a problem with installing 10g Rel 2 on the same logical drive as the OS, or perhaps with installing it on an NTFS filesystem?

Mike.
Re: ORA-12505 [message #236870 is a reply to message #171716] Fri, 11 May 2007 03:23 Go to previous messageGo to next message
csmarta
Messages: 1
Registered: May 2007
Location: Hungary
Junior Member
Hi

I have the same problem as you.
OS: Xp Prof. Service pack2.
Oracle: 10.2.0
The OS located in C (NTFS)
Oracle diractory located in D (NTFS)

Csaba



Re: ORA-12505 [message #237483 is a reply to message #236870] Mon, 14 May 2007 11:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
most likely the listener.ora file is malformed.
As "anacedent" already mention it is because of listener.ora file is malformed so you should RECREATE LISTENER.ORA FILE keep in mind first STOP LISTENER SERVICES BEFORE DELETE LISTNER.ORA FILE.

YOu can use NETCA tools for configure your listener.ora file.

Regards
Taj
Re: ORA-12505 [message #450101 is a reply to message #152085] Sun, 04 April 2010 22:49 Go to previous messageGo to next message
carillpower
Messages: 48
Registered: April 2009
Location: malaysia
Member

Change your SID in tnsnames.ora same as service name which have instance..

check at the listener...
lsnrctl services 


Thanks
Re: ORA-12505 [message #463925 is a reply to message #152085] Mon, 05 July 2010 04:21 Go to previous messageGo to next message
abhishek20c
Messages: 1
Registered: July 2010
Junior Member
I also changed the my listner.ora file serice name and it worked. Smile
thanks
Re: ORA-12505 [message #482901 is a reply to message #463925] Tue, 16 November 2010 12:29 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
where do you change the service name:

my listener.ora file is as followed:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /servername/folder/DB1)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL_DBNAME = DB1)
(ORACLE_HOME = /servername/folder/DB1)
(SID_NAME = DB1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = houpl005)(PORT = 1522))
)
)

[Updated on: Tue, 16 November 2010 12:34]

Report message to a moderator

Re: ORA-12505 [message #482906 is a reply to message #482901] Tue, 16 November 2010 13:08 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(SID_NAME = DB1)
instead of above it can be replaced with below
(SERVICE_NAME = DB1)
Previous Topic: invalid service name
Next Topic: controlling database access
Goto Forum:
  


Current Time: Thu Mar 28 04:37:00 CDT 2024