Causes Ora-12560:tns: Three reasons for protocol adapter errors

Create a new database in Oracle, delete it today and then log on Sql*plus (because the Oracle_sid value in the registry is null when the database is deleted), Ora-12560:tns: Protocol adapter error.

Ora-12560:tns: Workaround for protocol Adapter errors

There are three reasons for the problem with Ora-12560:tns: Protocol Adapter errors:

1. The monitoring service did not rise. Windows platform one of the following: Start---program---management tools---services, open the service panel, start the Oraclehome92tnslistener service.

2. The service oracleservicexxxx is not open, XXXX is your database SID. Database instance did not rise. Windows platform: Start---program---management tools---services, open the service panel, start oracleservicexxxx,xxxx is your database SID.

Note: When the service oracleservicexxxx opened, the database instance did not get up, will not prompt ORA-12560.

3. If you have not set ORACLE_SID on the registry, CMD window, and Windows System Properties interface, you will be prompted to ORA-12560.

Comments:

regedit, and then enter HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 to set the environment variable ORACLE_SID to XXXX,XXXX is your database SID.

Or the right a few my computer, attributes-advanced-environment variables---System variables-new, variable name =oracle_sid, variable value =xxxx,xxxx is your database SID.

or before entering Sqlplus, the set ORACLE_SID=XXXX,XXXX is your database sid under command line.

Through the above steps, we can solve the problem.

The reason for the problem is that the Registry has no oracle_sid in the hkey_local_machine\software\oracle\key_oradb11g_home1, and the Oracle_home value is the wrong path value.

Troubleshoot problem lookup data process:

Start listening ORA-12560 Google

Create a database ora-12560 Google