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

Source: Internet
Author: User


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.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.