Oracle Issue ORA-12560TNS: Protocol Adapter error

Oracle Issue ORA-12560TNS: Protocol Adapter error

There are three reasons why the Ora-12560:tns: Protocol adapter error is a problem:

1. The monitoring service is not up. Windows platform: Start---program---management tools---services, open the Services panel,

Start the oracleoradb11g_home1tnslistener service.
　　
　　

2.database instance did not rise up. The Windows platform: start---program---administrative tools---services, open services

Panel, start oracleservicebooksales,  booksales is your database SID　　　　
　　

3. Registry issues. regedit, and then into hkey_local_machine\software\oracle\home

Set the environment variable oracle_siD to XXXX, and XXXX is your database SID.
　　
　　

　　

　　

　　

or right-click My Computer, Properties-advanced-environment variables---System variables-new , variable name =oracle_sid, variable value =xxxx, XXXX is your database SID.

or enter Sqlplus before, under command line to lose set oracle_sid=xxxx, XXXX is your database SID.

After the above steps, you can solve the problem.

Oracle Issue ORA-12560TNS: Protocol Adapter error