Error ORA-12505 tns listener does not currently know of sid given in connect descriptor
Posted by:
Jérémy SCH
Date: February 21, 2016 07:04AM
Hello,
I have a problem with an Oracle application. Since i demoted domain controller on a server (Windows Server 2003), the application doesn't start. The error message appears : ORA-12505 tns listener does not currently know of sid given in connect descriptor.
I don't know Oracle but i searched without finding any solutions.
On the client computer, i found a tnsnames.ora file :
# C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orawin95\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
CMEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(PORT = 1610)(HOST = CM_SERVER))
(ADDRESS = (PROTOCOL = tcp)(PORT = 1521)(HOST = LSNR_SERVER))
)
(CONNECT_DATA = (SID = ORCL))
(SOURCE_ROUTE = yes)
)
TCPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)
NMPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
(CONNECT_DATA = (SID = ORCL))
)
GIMA8.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
(CONNECT_DATA = (SID = gima))
)
EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = extproc))
)
BEQ-LOCAL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
(CONNECT_DATA = (SID = ORCL))
)
SPXEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA = (SID = ORCL))
)
TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)
On the server computer i found a tnsnames.ora file too :
# tnsnames.ora Network Configuration File: D:\oracle\HomeVega10G\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
GIMA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GIMA)
)
)
GIMA8 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GIMA)
)
)
I found a listener.ora file on the server :
# listener.ora Network Configuration File
# Generated by Oracle configuration tools
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = d:\oracle\HomeVega10g)
(SID_NAME = VEGA)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.10.5)
(PORT = 1521)
)
)
The services on the server :
OracleCSService (not started) Manual : i cannot start this service.
OracleJobSchedulerGIMA (started) Automatic
OracleJobSchedulerVEGA (started) Automatic
OracleOracleHomeVega10gSNMPPeerEncapsulator (not started) Manual
OracleOracleHomeVega10gSNMPPeerMasterAgent (not started) Manual
OracleOracleHomeVega10gTNSListener (started) Automatic
OracleOracleHomeVega10gTNSListenerGIMA (not started) Manual : i cannot start this service (it starts and stop immediately).
OracleServiceGIMA (started) Automatic
For information :
Application name : GIMA
Server ip address : 192.168.10.5
Ping server since client computer : OK (ip address and name).
No firewall on the client computer and server.
No antivirus.
Telnet 1521 on the server OK.
There is another application named VEGA on the server and there is no problem with this application.
Can you help me please ?
PS : Sorry for my English, i don't speak English very well !
Subject
Views
Written By
Posted
Error ORA-12505 tns listener does not currently know of sid given in connect descriptor
4125
February 21, 2016 07:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.