Shulou(Shulou.com)06/01 Report--

This article mainly shows you how to solve the Oracle database ORA-12560 error problem, the content is simple and easy to understand, I hope you can learn about it, after learning, there will definitely be gains, let Xiaobian take you to see it.

The official website explains ORA-12560:

ORA-12560: TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.

First check if Oracle instance related services are running in Windows Services:

WIN +R👇

Checking Oracle Profiles

Go to Oracle installation home directory\product\12.2.0\dbhome_1\network\admin

Open the tnsnames.ora configuration file:

Open the listener.ora configuration file:

Check whether the HOST configuration of the corresponding database is correct. Here HOST=

How do I check the hostname?👇

Restart monitoring:

Open command line input: lsnrctl restart

Restart service:

This is how to solve Oracle database ORA-12560 error problem content, if you have learned knowledge or skills, you can share it to let more people see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.