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

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

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
For example: 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 in detail:

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

---> Note: the Oracle_home keys and ORACLE_SID keys under Windows Registry Store 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 on the server side of the Oracle database software, not the CD-to-Oracle database software client.

---> Note: Under Windows cmd, a command is struck by Windows to find the order of the command: First look for the command in the current directory, followed by the path path to find out if there is no command.

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

5.cmd, CD to F:\oracle\product\10.2.0\db_1\bin, then 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 on the server side of the Oracle database software, not the CD-to-Oracle database software client.