[Go]sqlplus/nolog Error Resolution Sp2-0667:message file SP1<LANG>.MSB not found sp2-0750:you may need to set Oracle_home to Y Our Oracle software directory

Http://techxploration.blogspot.com/2012/01/resolving-sp2-0750-you-may-need-to-set.html

Resolving sp2-0750:you may need to set Oracle_home to your Oracle software directory If your set up Oracle Database XE 11G In Linux and your encounter the following error when starting up SQL Plus:

$ sqlplus
Sp2-0667:message file SP1<LANG>.MSB not found
Sp2-0750:you need to set Oracle_home to your ORACLE software directory

To resolve it try the following. It ' s assumed Oracle XE 11G is installed at:

/u01/app/oracle/product/11.2.0/xe/

If you had a different set up, adjust your directory path accordingly.

1)Find out the path to sqlplus
bash-3.2$ which Sqlplus
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus

2) Set your oracle_home (upto Xe directory)

bash-3.2$ Export oracle_home=/u01/app/oracle/product/11.2.0/xe/

3) Set the path to the directory where Sqlplus are located to your PATH variable:

bash-3.2$Export path=/u01/app/oracle/product/11.2.0/xe/bin: $PATH


You should now is able to use Sqlplus.

4) Now, need to editBash_profile so all these takes effect everytime your log in.

bash-3.2$ CD ~/
bash-3.2$ vim. Bash_profile

5) in the. Bash_profile you'll need to add those export lines so every time your log in the same settings take effect.

bash-3.2$Vim. Bash_profile
#. Bash_profile

# Get the aliases and functions
If [-f ~/.BASHRC]; Then
. ~/.bashrc
Fi

# User specific environment and startup programs
Oracle_sid=xe
Export Oracle_sid
Oracle_home=/u01/app/oracle/product/11.2.0/xe
Export Oracle_home
Path= $ORACLE _home/bin: $PATH
export path
unset USERNAME


6) Run the following:
bash-3.2$. . bash_profile
 < Span style= "FONT-FAMILY:VERDANA,SANS-SERIF;" >
after following These 6 steps you should is able to connect to sqlplus any time.

[]sqlplus/nolog Error resolved sp2-0667:message file SP1<LANG>.MSB not found sp2-0750:you could need to set Oracle_home t o your Oracle software directory