How do I fix error ORA-12505?

How do I fix error ORA-12505?

There are several methods of correcting error ORA-12505. 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.

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.

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 find Oracle_home on Windows?

Find $ORACLE_HOME on Windows tips

  1. From your PC, click Start | Run.
  2. In the Run dialog box, type “regedit” and press Return.
  3. The registry will now be displayed.
  4. Expand the folder called [HKEY_LOCAL_MACHINE]\SOFTWARE\ORACLE.

What is a TNS error?

ORA-12154: TNS:could not resolve the connect identifier specified. 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.

How do I stop being a 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 restart my listener?

Start the Oracle listener service.

  1. Windows operating systems: Use the Services menu to start the Oracle TNS listener named OracleOraDb12_home1TNSListener . If the Oracle listener service is idle, start the listener.
  2. UNIX and Linux operating systems: Enter these commands: # su – oracle # ./lsnrctl start.

Where is TNS_ADMIN located?

ORACLE_HOME \network\admin
Database Administrator’s Reference for Microsoft Windows You can add the parameter TNS_ADMIN to change the directory path of Oracle Net Services configuration files from the default location of ORACLE_HOME \network\admin .

What is a TNS ping?

The tnsping utility is used to determine whether or not an Oracle service can be successfully reached. If a connection can be established from a client to a server (or server to server), tnsping will report the number of milliseconds it took to reach the remote service.

How do you fix Ora-27101?

Basically, to resolve ORA-27101, Once ORACLE_HOME and ORACLE_SID are correct, and then attempt to start SQL*Plus.

https://www.youtube.com/watch?v=ZTMsdH4hyrE