Search This Blog

Tuesday, August 12, 2008

'Lb_library_path Is Not Set' On Startup

After successfully upgrade db from 10gr1(10.1.0.3.0) to 10gr2 (10.2.0.1.0) I got below warning message during database startup

Sat Aug 9 17:52:09 2008

Starting ORACLE instance(normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

after searching on metalink I found below metalink note.

Metalink Note: 371408.1

According to metalink note it is a BUG:4918834.

Soluction: Set LD_LIBRARY_PATH enviourment variable.

$export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

2 comments:

Anonymous said...

Can u please let us know the exact solution/steps for this.
Syed

Mohammed Taj said...

Syed,
Before startup the database we need to set LD_LIBRARY_PATH variable same like we set ORACLE_HOME, ORACLE_SID, ORACLE_PATH.

we can set LD_LIBRARY_PATH variable in oracle user login profile.
means .bash_profile or .profile file so whenever user login to linux that profile will run and LD_LIBRARY_PATH will set.

below is the command to set LD_LIBRARY_PATH

export ORACLE_HOME=Full_oracle_home_path
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH