Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need to confirm LD_LIBRARY_PATH

JhilFeb 9 2020 — edited Feb 11 2020

Hi Team,

How do I check LD_LIBRARY_PATH  from below output ?

Oracle databases are running on this AIX server.

% env

USER=****

LOGNAME=****

LOGIN=****

HOME=/home/ora****

PATH=/oracle/***/11.2.0.4/dbhome_1/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/nd1adm/bin:/usr/bin/X11:/sbin:/usr/java6/jre/bin

MAIL=/var/spool/mail/ora***

SHELL=/usr/bin/csh

TZ=MST7MDT,M3.2.0/2:00:00,M11.1.0/2:00:00

SSH_CLIENT=***********************

SSH_CONNECTION=1************************

TERM=xterm

AUTHSTATE=compat

LANG=en_US

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

CPIC_MAX_CONV=5000

ODMDIR=/etc/objrepos

CLCMD_PASSTHRU=1

CLUSTER_OVERRIDE=yes

MAILMSG=[YOU HAVE NEW MAIL]

NLS_LANG=AMERICAN_AMERICA.UTF8

dbms_type=ORA

ORACLE_HOME=/oracle/***/11.2.0.4/dbhome_1

SAPDATA_HOME=/oracle/***

dbs_ora_tnsname=***

DB_SID=***

ORACLE_SID=***

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

Comments

Nik

Hi.

According proveded output -  LD_LIBRARY_PATH is not defined.

What  is default pathes for search library -  read Docs for corresponded version of AIX.

According https://www.ibm.com/support/knowledgecenter/en/SSYKE2_8.0.0/com.ibm.java.80.doc/user/setlpath.html

AIX use variable LIBPATH,  not LD_LIBRARY_PATH.

Regards,

Nik

1 person found this helpful
Dude!

AIX is not LInux and has very little in common.

https://www.ibm.com/support/pages/managing-libpath-and-ldlibrarypath-environment-variables-lsf-jobs-aix53

If you have installed Oracle gird or database, you may have /usr/local/bin/oraenv and should probably use it to configure the shell environment.

$ source oraenv

Jhil

Yes NIK , I found related articles.

For Oracle Database, Why we need LIBPATH ?

Is it really required to run/manage oracle executables ?

How do we find LIBPATH ?

I am getting confused, please throw some light to proceed further.

Regards,

Oracle Techie ..

Jhil

Hi Dude,

I do not find any output.

We are managing standalone Databases on AIX machine.

% source oraenv

oraenv: A file or directory in the path name does not exist.

Thanks

EDIT : NO GRID S/W INSTALLED

Dude!

Oracle uses LD_LIBRARY_PATH for shared libraries and it normally should point to the $ORACLE_HOME/lib directory.

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2342724_1.html

1 person found this helpful
Jhil

Hi Dude,

Thanks for update

On AIX machine, how do I find that LIBPATH Path?

I need to find that parameter value for some monitoring requirement.

It is asked internally by monitoring team, I need to update them.

Thanks

Dude!

LIBPATH is a question of AIX, not Linux, and depends on software installation. Your monitoring team should know what they use. I suggest you try the [software] set up and installation manual.

Jhil

Hi Dude,

On my Original post, I mentioned that Oracle is running on IBM AIX Machine.

We are managing Oracle Databases on Windows 2008, Windows 2012R2, RHEL 7.7,  IBM AIX and  HP UNIX

Monitoring team does not aware about LIBPATH OR LD_LIBRARY_PATH.

They are asking DB Team ,  who is currently managing Oracle DB Servers.

Thanks.

Dude!

complete checklist for oracle 11.2.0.4 environment variables on AIX 6

1 person found this helpful
Nik

Hi.

From your post is not clear what problem You try resolve.

LIBPATH is not  system configuration property. It's just session environment.

Try set LIBPATH to correct value  and test it.

You can also edit profile  for set this variable automaticaly.

Regards,

   Nik

1 - 10

Post Details

Added on Feb 9 2020
#database-installation
10 comments
1,287 views