Today encountered ORA-12560:TNS: Protocol adapter error problem, after a few efforts to solve the problem, and share with you.
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.database instance did not rise. Windows platform: Start---Program---administration tools---services, open services
Panel, start oracleservicexxxx,xxxx is your database SID.
3. Registry issues. regedit, and then enter HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 to put the environment variable Oracle_si
D set to Xxxx,xxxx is your database SID. Or right 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, under command line.
The set ORACLE_SID=XXXX,XXXX is your database SID.
Through the above steps, we can solve the problem.
Original link http://www.itpub.net/thread-223688-1-1.html
