| An issue with Unix cron [message #192489] |
Tue, 12 September 2006 10:22  |
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 #192549 is a reply to message #192524] |
Tue, 12 September 2006 18:16  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
