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.
What is the use of TNS listener in Oracle?
9 Configuring and Administering Oracle Net Listener. Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server.
How do I enable TNS listener?
Do the following:
- Log on to the host where the Oracle database resides.
- Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
- To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
- Repeat step 3 to verify that the TNS listener is running.
How do I create a TNS Listener service?
To statically configure the listener:
- Start Oracle Net Manager.
- In the navigator pane, expand Local > Listeners.
- Select a listener.
- From the list in the right pane, select Database Services.
- Click Add Database.
What is TNS entry in Oracle?
A TNS (Transparent Network Substrate) name is the name of the entry in tnsnames.ora file which is kept in $ORACLE_HOME/network/admin. This file contains the information which is used by the system to connect to oracle database.
What is the TNS name in Oracle?
TNSNAMES.ORA is a configuration file that the Oracle database uses. It allows users and applications to connect to Oracle databases by matching a connection name with all of the relevant details. It’s written using a specific syntax, which I’ll cover later in this article.
How to check if the Oracle listener is running?
Open a command window
What does Oracle error message ora-12154 mean?
ORA-12154 error is very common error related to ‘tnsnames.ora’ file.This error will come when oracle is unable to locate the service name specified in ODBC data source.ORA-12154 error will come at local service when application tries to connect with remote server.This error will come in following situations :