How to solve ORA-12514?

Posted on by Drake Andrew

How to solve ORA-12514?

Action:

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

What is ORA-12514?

ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish a connection with the database for you. As a result, it responds ORA-12514 to alert the failed connection. Also, this could be due to using the wrong service name.

How to solve ORA-12514 tns listener does not currently know of service requested in connect descriptor?

The solutions to ORA-12514 are to make sure the following things:

  1. The database is available. If there’s no instance, then no service name will register with the listener.
  2. The service names are matched.
  3. The host and port are both right.
  4. Instance registers it services with the right listener.

How do you resolve ORA 12154?

Resolution

  1. Option #1. Make sure that the TNSNAMES. ORA file exists and is in the correct directory.
  2. Option #2. Make sure that the service name that you are connecting to is included in the TNSNAMES. ORA file and that it is correctly defined.
  3. Option #3. Make sure that there are no syntax errors in the TNSNAMES. ORA file.

How do I find Oracle service name?

Right click on your Connection/Propriety. You should see the name on the left under something like “connection details” and should look like “Connectionname@servicename”, or on the right, under the connection’s details.

What does Oracle listener do?

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.

What is the error ORA 12154?

This is one of the most common Oracle errors and it is basically telling you that you are trying to connect to a database name that is unknown to the system. The most common cause are typos in your connection string or network configuration files.