Sqlplus "/as sysdba" error occurred while logging on to the database

Source: Internet
Author: User
Tags oracle database installation sqlplus

An error occurred while logging in to the database with Sqlplus "/as sysdba" when the database was successfully installed, possibly for the following two reasons:

1, Sqlplus processing program is generally in the Oracle installation directory under the $oracel_home/bin directory, which should have Sql.exe executable file, if not, the Oracle database installation file has a problem

2. If there is a Sql.exe file, it is possible that the configuration file in Windows is not set well

Right-click My Computer-"Advanced system Settings-" Environment configuration-click on the following path, add one; paste Sql.exe file installation (e.g. D:\Programfiles\oracle\product\10.2\db_ 2\bin)

1) If Oracle_home and Oracle_sid are not found in the variables in the System Variables list box, you need to set both environment variables

Enter "Oracle_home" in the Variable Name text box and enter D:\Programfiles\oracle\product\10.2\db_2 in the variable value

Enter "Oracle_sid" in the Variable Name text box and enter ORCL in the variable value

· Oracle_home: Is the installation directory of Oracle

· Oracle_sid: Is the instance name of the Oracle database

Sqlplus "/as sysdba" error occurred while logging on to the database

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.