The solution of Windows server 2008 R2 (win7) login sqlplus error ORA-12560 and ORA-12557

Windows server 2008 R2 (win7) login sqlplus error: ORA-12560 and ORA-12557. The error screenshot is as follows:

The problem scenario describes that the 1:Windows system only installs oracle11g and does not install client. At this time, you cannot log in to sqlplus in cmd.

Solution:

(1) check whether the registry contains ORACLE_SID=xxxx (xxxx represents the instance name, and the default is orcl for general installation), 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 the listening is enabled, and whether the oracleservicexxxx (xxxx stands for instance name. The default for general installation is orcl) service is started. If it is not started, start it.

Problem scenario description 2:Windows system installs oracle11g and client client is installed, and cmd cannot log in to sqlplus at this time.

Solution:

(1) check whether the registry contains ORACLE_SID=xxxx (xxxx represents the instance name, and the default is orcl for general installation), 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 the listening is enabled, and whether the oracleservicexxxx (xxxx stands for instance name. The default for general installation is orcl) service is started. If it is not started, start it.

(3) check the value of the environment variable PATH: see if the oracle installation directory bin precedes the client installation directory bin. As shown below:

Tip: variables are very important in the system. It is recommended to save the values of path variables in a text file before modifying them.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.