sp1.msb not found SP2-0750 while connecting as sysdba

sp1<lang>.msb not found SP2-0750 while connecting as sysdba


$ 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


Action

 
$ cat .profile


ORACLE_HOME=/orahome/oracle/product/9.2.0
ORACLE_BASE=/orahome/oracle
ORACLE_SID=bsnl

umask 022
unset username
PATH=$PATH:$HOME/bin
export PATH=$PATH:/orahome/oracle/product/9.2.0/bin
export PATH=$PATH:/orahome/oracle/product/9.2.0

  
Here ORACLE_HOME is set but it is not exported

added the follwing in .profile or .bash_profile

export ORACLE_HOME=/orahome/oracle/product/9.2.0
export ORACLE_BASE=/orahome/oracle
export ORACLE_SID=bsnl

 
Then the problem is resolved.

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post