Home » Infrastructure » Linux » An issue with Unix cron
An issue with Unix cron [message #192489] Tue, 12 September 2006 10:22 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
we have a 9.2.0.7.0 database under Linux.
we have written a shell script to take the RMAN backup of the prod database.
we have embedded the script under cron and the cron is blowing error as follows

rman: cant open shared libraries libwtc9.so : No such file or directory

Our shell script as follows
#!/bin/sh
export ORACLE_SID=tcms
export ORACLE_HOME=/mnt/ora_system/oracle/9.2.0
export PATH=$PATH:$ORACLE_HOME/bin
rman << EOF
connect target;
run
{
backup database;
}
EOF

we have checked and the libwtc9.so is existing in the $ORACLE_HOME/lib.
what could be issue and fix for the same...?


regards
bala
Re: An issue with Unix cron [message #192510 is a reply to message #192489] Tue, 12 September 2006 12:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Re: An issue with Unix cron [message #192524 is a reply to message #192510] Tue, 12 September 2006 13:33 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
We have used that variable too..but still the error is blowing..
plz advice asap...


regards
bala
Re: An issue with Unix cron [message #192549 is a reply to message #192524] Tue, 12 September 2006 18:16 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
do an "env" to review any Oracle settings in your interactive environment.

To see if a specific variable is needed or not - you can unset it and run the script manually again. If it fails - you've elimiated a required environment setting. Even if it doesn't fail - doesn't mean the variable isn't required, so be careful. Best to follow the documented variables required.

Add any missing variables to your script.
Re: An issue with Unix cron [message #192580 is a reply to message #192549] Tue, 12 September 2006 22:24 Go to previous message
jimmy_nokia
Messages: 4
Registered: September 2006
Junior Member
we meet the similar problem about the crontab
we can run the script manually ,but when in crontab ,the script can not run correctly.

your problem ,may be the environment variable .

to modify the file /root/.bash_profile
set the PATH=$ORACLE_HOME/lib:$PATH:$HOME/bin

hope help you.
wang




Previous Topic: Oracle - Linux RAW
Next Topic: A question about Oralce9i
Goto Forum:
  


Current Time: Thu Mar 28 08:35:09 CDT 2024