How do I fix ORA 12514 TNS listener does not currently know of service requested in connect descriptor?

16/09/202216/09/2022 | Sarah HendricksonSarah Hendrickson | 0 Comment | 12:00 am

How do I fix ORA 12514 TNS listener does not currently know of service requested in connect descriptor?

Action: Wait a moment and try to connect a second time. Check which services are currently known by the listener by executing: lsnrctl services. Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.

How do I fix TNS listener error?

Resolving The Problem

Check that the listener has been started by running the lsnrctl utility on the Oracle server. To start the lsnrctl utility: Select Start > Run…, then type CMD and click OK.

How do I know if TNS listener is running?

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 you fix TNS listener does not currently know of SID given in connect descriptor?

Your first action to resolve this issue should be to wait a few seconds, then try to re-connect to the database again. If this attempt is unsuccessful, try checking to see which instances are known by the listener. To do this, execute: lsnrctl services <listener name>.

Where is TNS ORA file located?

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

How do I register a listener manually?

To register information with another local listener:

  1. Configure the listener.
  2. Configure the LOCAL_LISTENER parameter in the initialization parameter file to locate the local listener.
  3. Resolve the listener name alias for the LOCAL_LISTENER or the LISTENER setting through a tnsnames.

Where is listener Ora file located?

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

Where is Tnsnames Ora file located?

How do I start the Oracle listener service?

To start Oracle Net Listener, do the following:

  1. Start the listener with the Listener Control utility.
  2. Start the database, as follows:
  3. Confirm that database service registration with the listener has completed using the Listener Control utility using the following command: LSNRCTL> SERVICES [listener_name]

How do I install TNS Listener service?

Configuring Access to Oracle JServer

  1. Start Oracle Net Manager.
  2. In the navigator pane, expand Local > Listeners.
  3. Select a listener.
  4. From the list in the right pane, select Listening Locations.
  5. Click Add Address.
  6. Select the TCP/IP or TCP/IP with SSL protocol from the Protocol list.

How do I install Tnsnames Ora file?

Specifying a Connection by Configuring a tnsnames. ora File

  1. Run Oracle Universal Installer.
  2. Select the Custom installation type.
  3. In the Available Product Components list, select Oracle Network Utilities and click Next.
  4. In the Summary window, click Install, then click Exit and Yes to exit Oracle Universal Installer.

How can I update Tnsnames Ora file?

Updating the tnsnames. ora files

  1. From the Oracle Home, open the file tnsnames. ora. Typically, the default location of the file tnsnames. ora is <ORACLE_HOME>\NETWORK\ADMIN\.
  2. Edit the entry in tnsnames.ora as follows: Replace HOST=machine_name. with HOST=virtual_IP_address.
  3. Save and close the tnsnames. ora file.

How do I add services to my listener?

NET MANAGER

  1. Open NETMANAGER at Database Server.
  2. On left side, Expand local(+) –> Expand listener(+)
  3. Click on listener and you will see this windows.
  4. Go to right side of windows and select database services.
  5. Add new database services in listener in window show above.
  6. Reload the listener from command shell.

How do I manually create a listener in Oracle?

To configure additional protocol addresses for the listener: Start Oracle Net Manager.
…
If a listener has never been created:

  1. Click plus (+) from the toolbar, or choose Edit > Create. The Choose Listener Name dialog box appears.
  2. Enter a unique listener name in the Listener Name field.
  3. Click OK.

How do I configure listener Ora?

To configure a protocol address for Oracle JServer in an Oracle8i database:

  1. Start Oracle Net Manager.
  2. In the navigator pane, expand Local > Listeners.
  3. Select a listener.
  4. From the list in the right pane, select Listening Locations.
  5. Click Add Address.
  6. Select the TCP/IP or TCP/IP with SSL protocol from the Protocol list.

How do I install Oracle listener service in Windows?

How do I manually create Tnsnames Ora?

Procedure

  1. FTP the following file from your Oracle server:
  2. Add the following lines:
  3. Replace the string yourhost in the line (HOST = yourhost ) with the name of your Oracle server.
  4. (optional) Replace the default port number 1521 in the line (PORT = 1521 ) with your required port number.
  5. Write and quit the file.

How do I know if Oracle Listener is running on Windows?

In Windows go to start run and type services. msc a service window will come which contain the information of all the services are running in your system. Now simply check for the Oracle Listener service. If it say started its means that oracle listener is running.

Where is the listener Ora file located?

Where is Tnsnames Ora file located in Windows 10?

How do I create a listener in Oracle 19c manually in Windows?

Create a listener in Oracle Database 19c with NETCA
Launch the Network Configuration Assistant with necta command. Select “Listener Configuration” and click “Next“. Select “Add” then click “Next“. Give a name to the listener to easily identify it from other configured listeners and provide Oracle Home user password.

How do I restart my listener?

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.

How do I change the default listener port in Oracle 19c?

  1. Log in to the Linux operating system as the oracle user.
  2. Check the current listening status.
  3. Stop the listening service.
  4. Change the port number in the files tnsnames.
  5. Modify the initialization parameter local_listener.
  6. Start the listening service.
  7. After the change is complete, log in and test the new listening port.

Where can I find Tnsnames Ora file?

By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory. Oracle Net will check the other directories for the configuration file.

What is the default listener port for Oracle Database?

1521
Port Numbers and Protocols of Oracle Components

Default Port Number Port Range Protocol
1521 (same value as the listener) 1521 TCP
1630 1630 TCP
3938 1830–1849 HTTP
1158 5500–5519 TCP/HTTP

Related Post