| ORA-12505 [message #152085] |
Tue, 20 December 2005 22:59  |
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)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
**************************************************************
Thanks,
Sam
|
|
|
|
|
|
| Re: ORA-12505 [message #171383 is a reply to message #152085] |
Tue, 09 May 2006 10:52  |
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 #171716 is a reply to message #171385] |
Thu, 11 May 2006 03:55 |
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 |
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 #482901 is a reply to message #463925] |
Tue, 16 November 2010 12:29 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
