This discussion is archived
2 Replies Latest reply: Dec 5, 2012 11:22 PM by user11979518 RSS

LD_LIBRARY_PATH

user11979518 Newbie
Currently Being Moderated
Hi Guys,

I am running Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production on Solaris 10.

I am using oraenv to setup my environment variables.

But when I try to run sqlplus I get these:

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Now I checked my oraenv and my oraenv have the LD_LIBRABRY_PATH

case ${LD_LIBRARY_PATH:-""} in
*$OLDHOME/lib*) LD_LIBRARY_PATH=`echo $LD_LIBRARY_PATH | \
sed "s;$OLDHOME/lib;$ORACLE_HOME/lib;g"` ;;
*$ORACLE_HOME/lib*) ;;
"") LD_LIBRARY_PATH=$ORACLE_HOME/lib ;;
*) LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH ;;
esac

export LD_LIBRARY_PATH

But when I do these:

SunOS:oracle:MYDB /u01>oraenv
ORACLE_SID = [AXSDEB] ? AXSLIV
The Oracle base for ORACLE_HOME=/u01/oracle/product/11.2.0/db_3 is /u01/oracle
SunOS:oracle:MYDB /u01>env | grep -i library
LD_LIBRARY_PATH=/usr/lib:/usr/ccs/lib:/usr/local/lib:/usr/local/samba/lib:/opt/SMAW/lib
SunOS:oracle:MYDB /u01>

What should I do such that my LD_LIBRARY_PATH=/u01/oracle/product/11.2.0/db_3/lib ?

Please help !!!!!!!!!!!!!

Thanks in advance...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points