environment setup inside cron job
I like to schedule a job to be run at 8:00pm every night, and I know very a little about cron
job, basically I just want to get the exp of the database every night. Please correct me if I
am wrong. I have the script as below:
exp system/manager file=/u02/backup/TEST/exp_TEST_full.dmp
log=/u02/backup/TEST/exp_TEST_full.log full=y direct=y
and this script is save as backup_TEST.sh and it located on:
seem like I have problem with setting the environment in my script but I used the same command to set environment when I do stuffs on the server and it worked.
Any advise of what command I should type inside the script????
exp system/manager file=/u02/backup/$ORACLE_SID/exp_$ORACLE_SID_full.dmp
log=/u02/backup/$ORACLE_SID/exp_$ORACLE_SID_full.log full=y direct=
Try out the above.
set your Oracle Home as well
When a job runs through cron is does a su to oracle without picking up any of the the Oracle profile information so all environment variables must be set explicitly in the cron script
I'm stmontgo and I approve of this message
stmongo and prince_jr,
per your advise below is my script:
exp system/manager file=/u02/backup$ORACLE_SID/exp_$ORACLE_SID_full.dmp
log=/u02/backup/$ORACLE_SID/exp_$ORACLE_SID_full.log full=y direct=y
so I save this as backup_TEST.sh and I tried to run ./backup_TEST and I got the error:
[oracle@qhoudb03 mytest]$ ./backup_TEST
bash: ./backup_TEST: bad interpreter: No such file or directory
Please advise, what's wrong here
Originally posted by ashley75
or whatever your ksh shell is located.
or, alternatively, you can setup your environment in your crontab:
# setup the environment
exp system/manager file=$FILE_STUB.dmp log=$FILE_STUB.log full=y direct=y
10 0 * * * (/bin/ksh "export ORACLE_SID=TEST; export ORAENV_ASK=NO, . $HOME/.profile; $HOME/your_export_script_goes_here.ksh")
Last edited by marist89; 10-24-2003 at 04:04 PM.
Also, you know if you don't know WHY export is a VERY poor method for a backup, use "Search".
if that does not work just give
Give the full name if you are not running from current directy
Jeff and Prince_jr,
I got my script working when I issue ./backup_TEST.sh and everything seems to work fine. Below is my script:
# full backup TEST
exp system/manager file=/u02/backup/$ORACLE_SID/exp_$ORACLE_SID_full.dmp log=/u02/backup/$ORACLE_SID/exp_$ORACLE_SID_full.log full=y direct=y
and this file is saved in :/home/oracle/DBA_STUFFS/backup_scripts/TEST/backup_TEST.sh
but I seem to have problem when I schedule this job to be run at 8:00pm every night.
below is the message I got in the mail:
From: email@example.com (Cron Daemon)
Subject: Cron /home/oracle/scripts/backup/TEST/backup_TEST.sh
/bin/sh: /home/oracle/scripts/backup/TEST/backup_TEST.sh: No such file or directory
I know exp/imp is not a good backup method but this is what the client wants.
Last edited by ashley75; 10-27-2003 at 03:08 PM.
Your saving it as:
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width