crontab issue


 
Thread Tools Search this Thread
Operating Systems HP-UX crontab issue
# 1  
Old 01-22-2008
Power crontab issue

Dear Folks,

i am new to hp-ux, i have a problem scheduling the crontab,
The script is working fine at command prompt, but not working at cron, please find a solution for it ,

here are the logs and my schedule at cron:
log after restarting crontab /var/adm/cron/log
! *** cron started *** pid = 24393 Thu Jan 3 12:33:16 IST 2008
> CMD: /home/oracle/fullexp.sh >> /home/oracle/run.log
> oracle 24481 c Thu Jan 3 12:35:00 IST 2008
< oracle 24481 c Thu Jan 3 12:35:00 IST 2008 rc=1
~
~
~
~
~
######################################################

#!/usr/bin/sh
export EDITOR=vi
export ORACLE_SID=mibast
export ORACLE_BASE=/home/oracle/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export DISPLAY=10.1.9.21:0:0
PATH=$ORACLE_HOME/bin:$PATH
export PATH
export SHELL=usr/bin/bash
/home/oracle/oracle/product/10.2.0/db_1/bin/exp system/manager file='/data3/expo
rt/full_26.dmp' log='/data3/export/full_26.log' full=y consistent=y buffer=99999
99 statistics=none

But still no luck, please find the solution.
# 2  
Old 01-22-2008
What is the error message that you got?

Thanks
Nagarajan G
# 3  
Old 01-22-2008
Quote:
Originally Posted by vaddi
export SHELL=usr/bin/bash
You can't make SHELL a relative path.
export SHELL=/usr/bin/bash
might make sense if bash is really in /usr/bin. This needs to the the absolute path to a shell.
# 4  
Old 01-22-2008
Java

Hi vaddi,

I have just released that your absolute path in your crontab entry should read, I think;

> CMD: /home/oracle/oracle/fullexp.sh >> /home/oracle/run.log

your entry

> CMD: /home/oracle/fullexp.sh >> /home/oracle/run.log

See Below

#!/usr/bin/sh
export EDITOR=vi
export ORACLE_SID=mibast
export ORACLE_BASE=/home/oracle/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export DISPLAY=10.1.9.21:0:0
PATH=$ORACLE_HOME/bin:$PATH
export PATH
export SHELL=usr/bin/bash
/home/oracle/oracle/product/10.2.0/db_1/bin/exp system/manager file='/data3/expo
rt/full_26.dmp' log='/data3/export/full_26.log' full=y consistent=y buffer=99999
99 statistics=none

I hope this is of help


Jnike
# 5  
Old 01-22-2008
If its working fine at command prompt and not in the batch mode, then your issue is about your environment...
For instance PATH=<something>:$PATH is equal to PATH=<something>:/usr/bin... So be sure to export the PATH to all your called binaries...
No variables are set except the ones you specify...
Put all your needed variables in a file and execute it :
. /absolutePathTo/loadmyvars
then execute your script!
So this is what we should see in your Newscript for batch:
#!/usr/bin/ksh #or whatever
. /absolutePathTo/loadmyvars
myolscriptthatdidntwork
exit

If you want to check, just put in a script
. /to-oraclehome/.profile
script

It should work..


Good luck
Vic
# 6  
Old 01-24-2008
Data

Dear Nagarajan ,

the log is not being generated so nothing to see
# 7  
Old 01-24-2008
MySQL

Dear Folks,

Thanks for ur reply,

here is the environment variables , please go through it and get me the right solution for the script.Smilie


env variables(oracle)

$ env | grep ORACLE
ORACLE_BASE=/home/oracle/oracle
ORACLE_SID=mibast
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
$ env | grep oracle
PATH=/home/oracle/oracle/product/10.2.0/db_1/bin:/usr/bin:/opt/ansic/bin:/usr/cc
s/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/
fcms/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/pd/bin:/opt/wbem/bin:/opt/wbem/s
bin:/opt/resmon/bin:/opt/firefox:/opt/gnome/bin:/opt/mozilla:/opt/graphics/commo
n/bin:/opt/hpsmh/bin:/opt/perl_32/bin:/opt/perl_64/bin:/usr/sbin/diag/contrib:/o
pt/sfm/bin:/opt/ssh/bin:/opt/thunderbird:/opt/gwlm/bin:/opt/aCC/bin:/opt/cadvise
/bin:/opt/langtools/bin:/opt/imake/bin:.
ORACLE_BASE=/home/oracle/oracle
LOGNAME=oracle
HOME=/home/oracle
LD_LIBRARY_PATH=/home/oracle/oracle/product/10.2.0/db_1/lib
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
$
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Crontab issue

Hello, I have a bash script that finds files older than 31 days and deletes them. I have this file loading into crontab to run everyday. It ran fine the first time i loaded it in, but now when I try to run it manually (bash file.sh) I get errors. Here is the script TIME=" -maxdepth 1... (6 Replies)
Discussion started by: jrymer
6 Replies

2. UNIX for Advanced & Expert Users

Crontab Issue

My colleague who was a sysadmin , has created a cron job script which collects logs and process them. The script works perfectly as per the defined time set by him. it works when we keep the timing as 55 05 * * * , whereas if we try to prepone the cron task is not getting executed. Where... (10 Replies)
Discussion started by: aravindj80
10 Replies

3. Shell Programming and Scripting

Crontab issue

hi, i have schduled a job through crontab, but it is not getting executed. bash-3.2$ crontab -l # Monthly Download (mm hh DD MM format) 35 05 01 04 * /home/ftpsrp/srpftp1/download/ofrdb/scripts/load_ofrdb.sh crr.sh here is the permission of the .sh files -rwxr--r-- 1 ftpsrp srp ... (7 Replies)
Discussion started by: lovelysethii
7 Replies

4. UNIX for Dummies Questions & Answers

Crontab Issue..!!!

Hi, I have a cronjob but it is not getting executed.Is there any ways to check whether crontab is working.I have put crontab -l and checked.It got listed.But it is not working. My Crontab is, * * * * * /ldesk/home/abc/source/compare.sh >/dev/null 2>&1 (1 Reply)
Discussion started by: gayisada
1 Replies

5. AIX

Crontab issue

Hi all, I'm having a problem with a crontab entry execution for a non root user. AIX version 5.3 user@host ~ $ oslevel -r 5300-10 cron status user@host ~ $ ps -ef | grep cron root 377044 1 0 Oct 27 - 0:22 /usr/sbin/cron cron entry for user user@host ~ $... (3 Replies)
Discussion started by: h@foorsa.biz
3 Replies

6. UNIX for Advanced & Expert Users

Crontab issue

We have configured a script to be run at specific time using crontab. # crontab -l 15 11 * * * VM_Count_V4.shas per the crontab entry script should run every day 11.15 a.m Every time when the script is executed i get a mail but when i run it using crontab it doesn't send any mail. However... (1 Reply)
Discussion started by: pinga123
1 Replies

7. Shell Programming and Scripting

Issue with crontab

I have a ksh script which will connect to a database and executes some sql scripts. If i run the ksh script it is working fine. But if i schedule it to run at a perticular time using cron the sql script is not running. The scriptl initially creates a spool file for sql script and then connects and... (12 Replies)
Discussion started by: Sriranga
12 Replies

8. Shell Programming and Scripting

crontab issue

Helo . I have 2.6.13-1.1526_FC4smp here. I am trying to make crontab execute my simple shell script, but noting happens. here is how i am testing this : $ pwd /home/oracle $ ls -l two* ls: two*: No such file or directory $ $ crontab -e crontab: installing new crontab $ $ crontab... (7 Replies)
Discussion started by: tonijel
7 Replies

9. UNIX for Advanced & Expert Users

crontab issue

I am adding a piece of code which adds entry in crontab ((in brown color)) \crontab -l > $tmpfile echo "Removing the cleanProcess entry if it already existed.." grep -v "cleanProcess.sh" $tmpfile > $newtmpfile lcnt=`grep -c "cleanProcess.sh" $tmpfile` echo... (4 Replies)
Discussion started by: crackthehit007
4 Replies

10. UNIX for Dummies Questions & Answers

Crontab Issue

I have a backup script that is suppose to run every night of the week, but it never does, it starts to run. The way I can tell is that the dates on dump_log are changing to when the script runs. If I look in the cron log file is shows ! > root 506342 cr /etc/back_up Fri Aug 5 10:30:00... (2 Replies)
Discussion started by: rickyt00
2 Replies
Login or Register to Ask a Question