Problems with Oracle TNS?

Question

Do I have a mistake? My pl / Sql developer says my oracle database cannot find the service descriptor. But when I do a listener check, I get this error.

LSNRCTL> start Starting tnslsnr: please wait... Service OracleOraDb10g_home1TNSListener already running. TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown error 

the contents of my listener.ora

 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = Oracle10g) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME = ORCL) ) ) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) 

and the content of tnsnames.ora is

 # tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. VMOBILE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) VMOBILEMASTER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = ORCL) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 

Please, I have a deadline for this evening. Please, help.

Answer 1

This is probably a configuration problem, which means that it is difficult for us to solve remotely. Two things you need to check out are

• The entries in your LISTENER.ORA file correspond to your TNSNAMES.ORA file TNSNAMES.ORA
• The information in your hosts correct.

Is this the local or remote database you are trying to connect to?

change

The hosts file (in a Windows environment) is somewhere like

 C:\WINDOWS\system32\drivers\etc 

Obviously, this depends on how your environment is configured (another drive letter or something else).

change

You need GLOBAL_DBNAME in the listener file to match SERVICE_NAME in the tnsnsames file, i.e. ORCL

Answer 2

The error is probably in the listener.ora file. Try replacing localhost in the line reading (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) with the name or ip number of the server on which the listener is running.

Answer 3

I would replace localhost with ipconfig saying that you are using an IP address.

Answer 4

Unfortunately, this error can occur in a variety of cases.

• The Oracle database service (OracleServiceXE or any other edition that you use) is actually not working.
• The user tried to start the TNSListener service under a non-administrator account, preventing it from registering the associated Windows service.
• There was a conflict over more than one ORACLE_HOME on the machine.
• There is nothing wrong with the service or configuration settings, but the TNSListener service will not start until the Windows server is restarted.

Answer 5

I resolved this error message today by running LSNRCTL from cmd.exe, running as administrator.

I have a localhost server in listener.ora and in tnsnames.ora. I also have SQLNET.AUTHENTICATION_SERVICES = (NONE) in sql.ini

Before I try to use LSNRCTL.EXE, I do not have a listener service in the list of Windows services. The LSNRCTL start command from cmd admin does this for me.