MySQL Forums
Forum List  »  Oracle

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 !

Options: ReplyQuote


Subject
Views
Written By
Posted
Error ORA-12505 tns listener does not currently know of sid given in connect descriptor
3731
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.