Windows Oracle connection error ORA-12560: TNS: protocol adapter Error

Windows Oracle connection error ORA-12560: TNS: protocol adapter Error

There are three reasons for the problem that caused the ORA-12560: TNS: protocol adapter error: 1. the listening service is not up. For Windows, perform the following operations: start ---Program--- Management tool --- 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 panel, and start oracleservicexxxx. XXXX is your database Sid. 3. Registry issue. 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.

Reprinted to "http://zhidao.baidu.com/question/291049319.html"