Re: RMAN Error on Linux -

On Thu, 23 Mar 2006 08:37:17 -0800, Mark wrote:

> TNS-00517: Lost contact
> /oracle/R3D/920_32/bin/sqlplus: error while loading shared libraries:
> libclntsh.so.9.0: cannot open shared object file: No such file or
> directory

This can happen if the environment was changed. You should either have $ORACLE_HOME/lib in /etc/ld.so.conf or you should have LD_LIBRARY_PATH set to $ORACLE_HOME/lib. Do
The following:
1) env|grep $ORACLE_HOME/lib

   if that doesn't show something like this: $ env|grep $ORACLE_HOME/lib
LD_LIBRARY_PATH=/oracle/product/10g/lib

then do "grep $ORACLE_HOME/lib /etc/ld.so.conf". If that comes back empty, put $ORACLE_HOME/lib in /etc/ld.so.conf and execute "ldconfig". This must be done with root privileges.

Alternatively, you can simply define LD_LIBRARY_PATH like this

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

in the environment you want it to execute from. This is fairly frequent problem when attempting to execute from cron or when using desktop environment without setting preferences for the terminal emulator and instructing it to execute the login script (.bash_profile or .profile). In crontab, you can help yourself by putting the following in your crontab file:

SHELL=/bin/bash
ENV=/usr/local/etc/ora_bashrc
MAILTO="sybrandb_at_hccnet.verwijderdit.nl"

The last entry will prevent cron from sending you those pesky error mail messages.

-- 
http://www.mgogala.com