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

Source: Internet
Author: User
Tags sqlplus


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

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.