2 Replies Latest reply: Dec 6, 2012 1:22 AM by user11979518 RSS

    LD_LIBRARY_PATH

    user11979518
      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...