Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LD_LIBRARY_PATH

user11979518Dec 6 2012 — edited Dec 6 2012
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...
This post has been answered by Pierre Forstmann on Dec 6 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2013
Added on Dec 6 2012
2 comments
237 views