TNS: protocol adapter Error

TNS: protocol adapter Error Problem encountered today ORA-12560: TNS: protocol adapter Error Problem, after some effort the problem has been resolved, share with everyone. There are three reasons for the problem that caused the ORA-12560: TNS: protocol adapter error: 1. the listening service is not up. On the windows platform, perform the following operations: start --- program --- management tools --- Service, open the service panel, and start the oraclehome92TNSlistener service.
2. The database instance is not started. On the windows platform, perform the following operations: start --- program --- management tools --- Service, open the service www.2cto.com panel, and start oracleserviceXXXX. XXXX is your database SID.
3. Registry issues. Regedit, and enter HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOME0 to set the environment variable ORACLE_SI D to XXXX. XXXX is your database SID. or on the right, my computer, property -- Advanced -- environment variable -- System variable -- New, variable name = oracle_sid, variable value = XXXX, XXXX is your database SID. or, before entering sqlplus, enter set oracle_sid = XXXX under command line, and XXXX is your database SID.
After the above steps, you can solve the problem. Author tianyihuyidao9