Link to home
Start Free TrialLog in
Avatar of kingpukky
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/oracle/OraHome
$ sqlplus
bingo it starts!!!!!!!!!

Whats wrong ppl?
Please help!!

My Env List:
ORACLE_HOME=/mna/home/oracle/OraHome;export ORACLE_SOME
PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/s
bin:/usr/local/bin:/usr/lbin:.;export PATH
LIBPATH=$ORACLE_HOME/lib:$LIBPATH; export LIBPATH
ORACLE_SID=xpdm; export ORACLE_SID
Avatar of Yogesh_Yadav
Yogesh_Yadav

Hi,
  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/instantclient10_1


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/instantclient10_1
Errors
ASKER CERTIFIED SOLUTION
Avatar of DLyall
DLyall

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kingpukky

ASKER

Oh my god...
what an idiot I am...
thanks DLyall...