Home > Database > Oracle > body text

How to solve the 12560 protocol adapter error in oracle

WBOY
Release: 2022-05-30 16:16:54
Original
16925 people have browsed it

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.

How to solve the 12560 protocol adapter error in oracle

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How oracle solves the 12560 protocol adapter error

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 

How to solve the 12560 protocol adapter error in oracle

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.

How to solve the 12560 protocol adapter error in oracle

How to solve the 12560 protocol adapter error in oracle

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template