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

Source: https://www.2cto.com/database/201407/321055.html

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:

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:
38011055

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

1	注意，不是cd到F:\oracle\product\10.2.0\client_1\bin。也就是说cd到 oracle数据库软件的服务器端，不是cd到oracle数据库软件的客户端。

123	--->注意：windows的cmd下，敲一个命令，windows对该命令的查找顺序为：首先找当前目录下有无该命令，其次再到PATH路径下找有无该命令。4.cmd下，setORACLE_SID=你想进入的数据库的那个sid

5.cmd, CD to F:\oracle\product\10.2.0\db_1\bin, then knock sqlplus/@ Network service name as SYSDBA

1	注意，不是cd到F:\oracle\product\10.2.0\client_1\bin。也就是说cd到 oracle数据库软件的服务器端，不是cd到oracle数据库软件的客户端。

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