How do I fix my ORA-12514?

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.

What is ORA-12514 TNS listener does not currently know of service requested in connect descriptor?

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 do I fix TNS listener does not currently know of service requested in connect descriptor?

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.

How do I fix TNS 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 a database?

To start or shut down Oracle Database:

1. Go to your Oracle Database server.
2. Start SQL*Plus at the command prompt: C:\> sqlplus /NOLOG.
3. Connect to Oracle Database with username SYSDBA: SQL> CONNECT / AS SYSDBA.
4. To start a database, enter: SQL> STARTUP [PFILE=path\filename]
5. To stop a database, enter: SQL> SHUTDOWN [mode]

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 I start an Oracle Database?

How do I start Oracle XE on Windows?

On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 10g Express Edition, and then select Start Database. On Linux with Gnome: In the Applications menu, point to Oracle Database 10g Express Edition, and then select Start Database.

Why we use Tnsnames Ora?

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.

What is Oracle Tnsnames?

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. Using this a client can fetch server associated information transparently.