Other /

How do I fix TNS no listener error?

How do I fix TNS no listener error?

The Solution First, make sure that the listener is up and running. To do this, go to the Control Panel into Services under NT or listener control program (LSNRCTL). If the listener is up and running, the problem may lie with the listener not having been associated with the correct instance or protocol.

How do I start TNS listener?

Do the following:

  1. Log on to the host where the Oracle database resides.
  2. Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
  3. To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
  4. Repeat step 3 to verify that the TNS listener is running.

How do I fix protocol adapter error in SQL?

How to Fix ORA-12560: TNS: Protocol Adapter Error

  1. Make sure the windows service is up and running.
  2. Make sure your ORACLE_SID is set to the instance name you’re trying to connect to. If either one or two are not correct you will get the error as seen below.

Where can I find TNS listener?

ORACLE_HOME/network/admin
It can be found in the “$ORACLE_HOME/network/admin” directory on the client. This file will also be present on the server if client style connections are used on the server itself. Here is an example of a “tnsnames. ora” file.

How do I restart the TNS listener in Linux?

To restart the listener use lsnrctl reload as shown below instead of lsnrctl stop and lsnrctl start. realod will read the listener. ora file for new setting without stop and start of the Oracle listener.

What is TNS error?

The TNS-12154 error is encountered when SQL*Net cannot find the alias specified for a connection in the TNSNAMES. ORA file or other naming adapter. Before attempting to resolve the problem, it may be helpful to have a print out or view of both the TNSNAMES. ORA file and the SQLNET. ORA file.

Where is Tnsnames Ora file?

By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory.

How do I start TNS listener in Linux?

To start or stop the listener at the command line:

  1. Open a command window.
  2. Follow the steps listed in “Configuring the Operating System Environment Variables .”
  3. Enter either of the following commands, depending on whether you want to start or stop the listener: lsnrctl start lsnrctl stop.

What does tns-12560 TNS error code mean?

TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error — oracle-tech Unable to start listener service. Running Oracle Database 11gr2 on Windows 7. I just installed Oracle with the “install software only” option. Unable to start listener service. Running Oracle Database 11gr2 on Windows 7.

How to restart the listener service if it is not running?

If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the net start command: C:Documents and SettingsME>net start OracleOraDb10g_home1TNSListener Try to start the listener service using lsnrctl from DOS prompt.

What should I do if a generic protocol adapter error occurs?

Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.

How to fix ‘lsnrctl start’ is not working?

Open services.msc. Right-click the specific listener service. Click Properties. Change the password. Click OK. Start the service. In my Windows case the listener would not start, and ‘lsnrctl start’ would hang forever. The solution was to kill all processes of extproc.