Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Just to expand on the answer, note that the cron env is minimal, which means that if you call any programs, inc Linux ones, always specify the full paths to those as well.
If cron has a problem, it should email either the user or root.
printf " Enter the Database name [ORACLE SID] which has to be exported : "
read OraSid
export ORACLE_SID=$OraSid
exp / file=/backup/DBbackup/bscdb/$Date1/$OraSid.$Date.dmp full=y statistics=none direct=y log=/backup/DBbackup/bscdb/$Date1/$OraSid.$Date.exp.log "
I have to add the above script into the "CRONTAB" Like following way :
crontab -e //as ORACLE user's crontab
# Run script at 9:30 daily:
30 9 * * * /path/to/script //according to ur mail
But the problem is , I dont get any output . Just create the Dated folder only , no dump file is created . All of folder permission are correct but script is not working using the CRONTAB . Here I mention that manually the script is working but I want to run this script using crontab .
Plz give me suggestion How can I run the following script using CRONTAB ?
printf " Enter the Database name [ORACLE SID] which has to be exported : "
read OraSid
export ORACLE_SID=$OraSid
exp / file=/backup/DBbackup/bscdb/$Date1/$OraSid.$Date.dmp full=y statistics=none direct=y log=/backup/DBbackup/bscdb/$Date1/$OraSid.$Date.exp.log "
I have to add the above script into the "CRONTAB" Like following way :
crontab -e //as ORACLE user's crontab
# Run script at 9:30 daily:
30 9 * * * /path/to/script //according to ur mail
But the problem is , I dont get any output . Just create the Dated folder only , no dump file is created . All of folder permission are correct but script is not working using the CRONTAB . Here I mention that manually the script is working but I want to run this script using crontab .
Plz give me suggestion How can I run the following script using CRONTAB ?
Well your script looks like it depends on user input to actually do anything (the name of the Oracle DB), so it won't work when run autonomously like that.
You would need to hard-code the name of the database into the script, because nobody is going to be able to actually interact with the script when it is running.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.