kingpukky
asked on
Error 6 initializing SQL*Plus
Hi Experts,
Recently I installed oracle on an AIX machine.
When I start sqlplus promt, I get the following error
$ sqlplus
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
The funny thing is that, at this point if I say
$ echo $ORACLE_HOME
i get the output as "/mna/home/oracle/OraHome"
which is right...
now if i reset it to the same by
$ export ORACLE_HOME=/mna/home/orac le/OraHome
$ sqlplus
bingo it starts!!!!!!!!!
Whats wrong ppl?
Please help!!
My Env List:
ORACLE_HOME=/mna/home/orac le/OraHome ;export ORACLE_SOME
PATH=$ORACLE_HOME/bin:/usr /bin:/etc: /usr/sbin: /usr/ucb:$ HOME/bin:/ usr/bin/X1 1:/s
bin:/usr/local/bin:/usr/lb in:.;expor t PATH
LIBPATH=$ORACLE_HOME/lib:$ LIBPATH; export LIBPATH
ORACLE_SID=xpdm; export ORACLE_SID
Recently I installed oracle on an AIX machine.
When I start sqlplus promt, I get the following error
$ sqlplus
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
The funny thing is that, at this point if I say
$ echo $ORACLE_HOME
i get the output as "/mna/home/oracle/OraHome"
which is right...
now if i reset it to the same by
$ export ORACLE_HOME=/mna/home/orac
$ sqlplus
bingo it starts!!!!!!!!!
Whats wrong ppl?
Please help!!
My Env List:
ORACLE_HOME=/mna/home/orac
PATH=$ORACLE_HOME/bin:/usr
bin:/usr/local/bin:/usr/lb
LIBPATH=$ORACLE_HOME/lib:$
ORACLE_SID=xpdm; export ORACLE_SID
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh my god...
what an idiot I am...
thanks DLyall...
what an idiot I am...
thanks DLyall...
Here is cause of this problem and the possible solution:
New install of oracle instant client version of sqlplus is failing when attempting to start.
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
Instant_Client zip file was downloaded into:
/home/instantclient/
After unzip, sqlplus executable is found in:
/home/instantclient/instan
Cause
LIBPATH is not set.
LIBPATH is required to include the directory of the instant client libraries.
Solution
To implement the solution, please execute the following steps:
1. Set LIBPATH to include the directory where the instant client is stored.
In above install, LIBPATH must include:
/home/instantclient/instan
Errors