Sanjeeb Sapkota

Sanjeeb Sapkota

  • 942
  • 832
  • 47.7k

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

Feb 7 2016 5:15 AM

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.


Answers (2)