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