Solution: 1. Start the "OracleOraDb11g_home1TNSlistener" service in the service panel; 2. Start the OracleServiceBOOKSALES service; 3. Use regedit to set "ORACLE_SID" to the database SID.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
There are three reasons for the problem of ORA-12560: TNS: protocol adapter error:
1. There is no monitoring service Get up.
The windows platform operates as follows: Start---Programs---Management Tools---Services, open the service panel,
Start the OracleOraDb11g_home1TNSlistener service.
2. The database instance did not start up.
The windows platform operates as follows: Start---Programs---Management Tools---Services, open the service
panel, start OracleServiceBOOKSALES, BOOKSALES is your database SID
3. Registry problem.
regedit, and then enter HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME
Set the environment variable ORACLE_SID to XXXX, 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 before entering sqlplus, enter set oracle_sid=XXXX in the command line, XXXX is your database SID.
After the above steps, the problem can generally be solved .
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to solve the 12560 protocol adapter error in oracle. For more information, please follow other related articles on the PHP Chinese website!