Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Script is not longer working in the crontab Post 302837941 by Scott on Sunday 28th of July 2013 12:04:14 AM
Old 07-28-2013
Exporting the variable won't make any difference.

Is your oracle environment set? It's unlikely it will be set in .profile which you already sourced.

Code:
$ ORAENV_ASK=NO
$ ORACLE_SID=DB1 #Your DB name here
$ . oraenv # The location of this should be in your path after sourcing .profile
The Oracle base for ORACLE_HOME=/oracle/product/11.2 is /oracle/u01
$ X=333 # regarding export question - this is not exported
$ sqlplus -s /nolog << !
connect scott/tiger
select $X as X from dual;
!

         X
----------
       333

$

Remove the /dev/null redirection from the cronjob, and check the user's mail to see what error(s) there are.
 

10 More Discussions You Might Find Interesting

1. Forum Support Area for Unregistered Users & Account Problems

my account is no longer working

my account mhm4 is no longer working (9 Replies)
Discussion started by: mhm4
9 Replies

2. Shell Programming and Scripting

Script is not working when put in crontab

Hi there, this is part of my script: /usr/bin/cd /u01/oradata /usr/bin/cp `/bin/ls -1 . |grep -v "^DIMStemp01.dbf$" | grep -v "^DIMSts01.dbf$"|grep -v "^DIMStects01.dbf$"` /backup It's working fine when I manually run on telnet session. /bin/ls -1 . -- to list all the files inside... (2 Replies)
Discussion started by: *Jess*
2 Replies

3. Shell Programming and Scripting

script not working from crontab, executes individual

Hi, This script is working successfully when i executed from shell prompt, but the same script scheduled in crontab its not deleting the files, #! /bin/bash DAY_1=`(date --date='4 months ago' '+%Y-%m')` log=/tmp/cleant adir=/u01/app/oracle/admin/talon/adump... (4 Replies)
Discussion started by: saha
4 Replies

4. Shell Programming and Scripting

Expect Script Not working with Crontab

I have the following expect script sitting on a Linux box. === #!/usr/bin/expect -f # # backup.expect # # Expect script to backup a firewall via a SSH session # # set firewall set username set password set prompt set filename match_max 50000 spawn ssh -l... (2 Replies)
Discussion started by: alagondar
2 Replies

5. Shell Programming and Scripting

My script stops working when using crontab

I have made a shell script(/bin/sh) that starts a perl script (that I haven't made my self) that's starts a ssh session. The ssh session uses a private/public key to login so no password is needed. The Perl script works perfect. But when I put it in a cronjob (crontab) the ssh connection asks... (6 Replies)
Discussion started by: splinter_cell
6 Replies

6. Shell Programming and Scripting

Script not working in crontab

Hi I have created a script. Which i have configured in cron to make it run in every 2 min. But script is not running. If I checl the cron log at /var/cron/log .it shows its running in every 2 min. Below is the command which i configured in crontab. But I am not able to find the way so that... (9 Replies)
Discussion started by: nandan8a
9 Replies

7. Red Hat

Script not working if crontab scheduled

Hi all, I'm working to a script with /bin/bash shebang. The script works perfectly if I run from command line. The script runs under a non root user and inside the commands are set with sudo command in a such a way they can be run under root, for example (first rows of the script):... (5 Replies)
Discussion started by: idro
5 Replies

8. Shell Programming and Scripting

Script not working via crontab

Hi, I have written one script which is connecting to the the database and generating one CSV, it is running fine when i ran it manually though it is throwing any warning but CSV is generating and working fine but same script when i have configured in crontab not working and giving error, kindly... (6 Replies)
Discussion started by: ash12345
6 Replies

9. Shell Programming and Scripting

Script not working via crontab

Hi, I have written one script which is connecting to the the database and generating one CSV, it is running fine when i ran it manually though it is throwing any warning but CSV is generating and working fine but same script when i have configured in crontab not working and giving error, kindly... (1 Reply)
Discussion started by: ash1234
1 Replies

10. Red Hat

Linux ksh script not working in crontab

I am Not sure why following script is not capturing the counts only when using crontab !! when I run it fromt he command line it is fine ! what is missing here ! #!/usr/bin/ksh host=`uname -n` tdate=`date` userid='dbid/password' totalevents=`sqlplus -s $userid << - set timing off ... (1 Reply)
Discussion started by: mrn6430
1 Replies
bcrontab(1)						      General Commands Manual						       bcrontab(1)

NAME
bcrontab - Manage users crontab files SYNOPSIS
bcrontab [ -u user ] file bcrontab [ -u user ] { -l | -r | -e } DESCRIPTION
bcrontab interfaces with the bcron-spool daemon to manage crontab files in the privileged spool directory. OPTIONS
-u user Tell bcron-spool that we are acting on behalf of the named user. bcron-spool will only accept the username if bcrontab is running as either root or the same user ID as the named user. -l List the cronab crontab to standard output. -r Remove the user's crontab. -e Edit the current crontab. ENVIRONMENT
VISUAL If this is set, it is used as the editor to invoke to edit a crontab. EDITOR If $VISUAL is not set and this is, it is used as the editor to invoke to edit a crontab. If neither are set, /bin/vi is used. BCRON_SOCKET The path to the named socket used to communicate with bcron-spool. Defaults to /var/run/bcron-spool. LOGNAME USER These two variables are used, in order, to determine the user name invoking the program. One must be set if the -u option is not used. FILES
bcrontab tries to writes a temporary file into the current directory, and then into /tmp if that fails, in order to edit the current crontab. SEE ALSO
bcron-spool(8), crontab(5) AUTHOR
Bruce Guenter <bruceg@em.ca> bcrontab(1)
All times are GMT -4. The time now is 12:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy