Windows Server 2008 R2 (win7) login sqlplus error ora-12560 and ora-12557 solution

Time:2020-1-19

Windows Server 2008 R2 (win7) login sqlplus error: ora-12560 and ora-12557, error screenshot is as follows:

Problem scenario 1:Only Oracle 11g is installed in Windows system, but client is not installed. At this time, sqlplus cannot be logged in in CMD.

resolvent:

(1) Check whether the registry contains Oracle ﹣ sid = XXXX, (XXXX represents the instance name, and the default installation is orcl)ORACLE_HOME=E:\oracle\product\11.2.0\dbhome_1
(Note: e: \ Oracle \ product \ 11.2.0 \ dbhome? 1 is the Oracle installation directory)

(2) Check whether listening is started, whether Oracle service xxxx (XXXX stands for instance name, and orcl by default) service is started. If not, start it.

Problem scenario 2:In Windows system, Oracle 11g is installed and client client is installed. At this time, CMD cannot log in to sqlplus.

resolvent:

(1) Check whether the registry contains Oracle ﹣ sid = XXXX, (XXXX represents the instance name, and the default installation is orcl),ORACLE_HOME=E:\oracle\product\11.2.0\dbhome_1
(Note: e: \ Oracle \ product \ 11.2.0 \ dbhome? 1 is the Oracle installation directory)
(2) Check whether listening is started, whether Oracle service xxxx (XXXX stands for instance name, and orcl by default) service is started. If not, start it.
(3) Check the path value of the environment variable: check whether the Oracle installation directory bin is in front of the client installation directory bin. The following picture:

Tips:Variables are very important in the system. It is recommended to save the path variable value in a text file before modification. The values of variables are all in English “;” do not ignore

The above is the whole content of this article. I hope it will help you in your study, and I hope you can support developepaer more.

Recommended Today

Java Engineer Interview Questions

The content covers: Java, mybatis, zookeeper, Dubbo, elasticsearch, memcached, redis, mysql, spring, spring boot, springcloud, rabbitmq, Kafka, Linux, etcMybatis interview questions1. What is mybatis?1. Mybatis is a semi ORM (object relational mapping) framework. It encapsulates JDBC internally. During development, you only need to pay attention to the SQL statement itself, and you don’t need to […]