Search This Blog

Tuesday, August 12, 2008

'Lb_library_path Is Not Set' On Startup

After successfully upgrade db from 10gr1( to 10gr2 ( 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 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.



Anonymous said...

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

Mohammed Taj said...

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