The ultimate solution to Sqlplus/as sysdba newspaper ora-12560 under Windows

The ultimate solution to Sqlplus/as sysdba newspaper ora-12560 under Windows

This article is an original article. Reprint Please specify source: http://blog.csdn.net/msdnchina/article/details/38169095

Windows, Sqlplus/as SYSDBA often reported Ora-12560:tns:protocol adapter error, to resolve this error. There are several methods:

1. Verify that the Oracle_home key and its key values in the Windows registry are correct and valid
Analogy: Under Hkey_local_machine\software\oracle\key_oradb10g_home1. Find the Oracle_home key, the corresponding key value is H:\oracle\product\10.2.0\db_1, in fact the correct key value is F:\oracle\product\10.2.0\db_1

---> Note: Under Windows, do not set the ORACLE_HOME environment variable, please see my translated article:

http://blog.csdn.net/msdnchina/article/details/38010025

---> Note: the Oracle_home keys and oracle_sid keys stored under Windows are equivalent to the Oracle_home,oracle_ defined in. Profile under UNIX. Sid and other environment variables---this statement is purely my personal summary.

2 Ensure that the ORACLESERVICEXXX service that is changed in the Windows service is in the started state.

For the relationship between Oracleservicexxx and Oracle instances, see the article I wrote:

http://blog.csdn.net/msdnchina/article/details/38011055


3.cmd, CD to F:\oracle\product\10.2.0\db_1\bin, then knock Sqlplus/as SYSDBA

Note that it is not CD to F:\oracle\product\10.2.0\client_1\bin. This means that the CD is to the server side of the Oracle database software. Not a CD-to-Oracle database software client.

---> Note: under Windows cmd. To hit a command, Windows looks for the command in the following order: First look for the command under the current folder. Second, go to path path to find out if there is no this command.

4.cmd. Set oracle_sid= the SID of the database you want to enter

5.cmd, under CD to F:\oracle\product\10.2.0\db_1\bin. Knock Sqlplus/@ Network service name as SYSDBA

Note that it is not CD to F:\oracle\product\10.2.0\client_1\bin.
This means that the CD is to the server side of the Oracle database software, not the CD-to-Oracle database software client.

The ultimate solution to Sqlplus/as sysdba newspaper ora-12560 under Windows