Oracle Error: ORA-12154: TNS: could not resolve the connect

I am new in oracle. I am using windows 10 64 bit, Oracle XE 11g, visual studio 2010 and vb.net. But Why I am getting This error related to listener always when I turn off or hibernate my machine. Services are also running.

This is listner code:

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) )

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-4R5A2SG)(PORT = 1521)) ) )

DEFAULT_SERVICE_LISTENER = (SUIDO)

..................................

And This is tnsname.ora code:

SUIDO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-4R5A2SG)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SUIDO) ) )

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

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )

Can anybody help me what can i do to fix this problem as soon as possible.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Phadke10y ago
Makke sure your oracle service and listerner services are running .make sure that your tnsname.ora is listed in that TNSNAME.ORA file check that port and connection ie you Data source name is correctly go to command promt and try to connect through sql plus first if it connect then everything is good or ping your data source
Saillesh Pawar10y ago
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm