OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sqlplus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus [message #170833]

Fri, 05 May 2006 07:25

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
i installed oracle9i on AIX 5.2, after the installation was done i was able to run "oemapp console" , rman ,...
but when i try to run sqlplus i got the error :

message file sp1<lang>.msb not found
sp2-0750: you may need to set ORACLE_HOME to your oracle software directory

i guess ORACLE_HOME is set right otherwise i wont be able to run oemapp or rman,
but how to check if the file sp1<lang>.msb is missing or not and how to recover it in case its missing
thanks

so much for your kind help

Report message to a moderator

Re: sqlplus [message #170836 is a reply to message #170833]

Fri, 05 May 2006 07:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is to do with ORACLE_HOME and PATH.
make you have ORACLE_HOME defined and
PATH=$PATH:$ORACLE_HOME/bin

Report message to a moderator

Re: sqlplus [message #170846 is a reply to message #170833]

Fri, 05 May 2006 08:51

maoro
Messages: 312
Registered: May 2005

Senior Member

sir
if oracle_home and path are not set right how could i run oemapp or rman ?
i guess it has to do with the missing sp1<lang>.msb file
do u know how to restore these file

thanks

Report message to a moderator