Three methods: 1. Click on the program in Start, find the service option in the management tool, and start the "OracleOraDb11g_home1TNSlistener" service in the service panel; 2. Start "OracleServiceBOOKSALES" in the service; 3. Use regedit to enter "HKEY_LOCAL_MACHINESOFTWAREORACLEHOME", set "ORACLE_SID" to "database SID".
The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.
ORA-12560: TNS: Protocol adapter error solution
Causes the problem of ORA-12560: TNS: Protocol adapter error There are three reasons:
1. The monitoring service has not started.
The windows platform operates as follows: Start---Programs---Management Tools---Services, open the service panel,
Start the OracleOraDb11g_home1TNSlistener service.
# 2. The database instance does not start up.
Windows platform is 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_MACHINESOFTWAREORACLEHOME
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 under the command line, XXXX is your database SID.
After the above steps, generally can solve the problem.
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to solve protocol adapter error in oracle 11g. For more information, please follow other related articles on the PHP Chinese website!