FIX-SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

FIX-SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory



While connecting to Oracle database using Sql*plus it fails with error SP2-0750 along with Message file sp1<lang>.msb not found.
C:\> sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Cause of the Problem
The problem happened due to incorrect settings of ORACLE_HOME environmental variable.

On Windows you can issue path command to check the environmental variable settings and on Unix issue env command or check the .bash_profile.

C:\Documents and Settings\User>path
PATH=D:\oracle\product\10.2.3\av_agent_1\bin;C:\Program Files\Common Files\NetSarang;
D:\oracle\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;
C:\Program Files\Ringz Studio\Storm Codec\QTSystem\;C:\Program Files\SSH Communications Security\SSH Secure Shell

Solution of the Problem
Note that, ORACLE_HOME environmental variable is up to before bin directory. So correct it. On windows set it using set comamnd and on Unix set it using export command.

C:\Documents and Settings\User>set ORACLE_HOME=D:\oracle

C:\Documents and Settings\User>set PATH=%ORACLE_HOME%;\%ORACLE_HOME%\bin;%PATH%

C:\Documents and Settings\User>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 11 11:23:05 2011

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options