You are getting below error while trying to connect the Oracle SQL level,
> sqlplus "/as sysdba" Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Solution
Set the ORACLE_HOME environment using the command prompt (for Windows operating system). Ensure to set the environment path before the \bin directory.
set ORACLE_HOME=C:\oracle\product\10.2.0\ITsiti
Alternatively, you can set by right click on the My Computer > Advanced > Environment Variables. Click New under System variables. On the New System Variable tab, fill in the Variable name as ORACLE_HOME and Variable value with the location as above. (Below screenshot is the example of maintaining the JAVA_HOME – You can do the same step)
Once configured, you can check using below command,
>echo %ORACLE_HOME% C:\oracle\product\10.2.0\ITsiti
Try to log in into SQL level again,
>sqlplus SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jan 8 17:48:15 2014 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter user-name:
