Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script is not longer working in the crontab
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

LEARN ABOUT HPUX

rpccp_remove_profile

remove profile(1m)														remove profile(1m)

NAME

       remove profile - Removes all profile elements and the profile from the specified name service entry

SYNOPSIS

       rpccp remove profile  profile-entry-name [-s syntax]

OPTIONS

       Indicates  the  name  syntax of the entry name (optional). The only value for this option is the dce name syntax, which is the default name
       syntax. Until an alternative name syntax becomes available, specifying the -s option is unnecessary.

ARGUMENTS

       Indicates the name of the target profile.  For an entry in the local cell, you can omit the cell name and specify  only	the  cell-relative
       name.

DESCRIPTION

       The  remove  profile  command  removes a profile (and all of its elements) from the name service database. The entry name of the profile is
       required.

   Privilege Required
       You need write permission to the CDS object entry (the target profile entry).

NOTE

       This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.

EXAMPLES

       The following  commands	run  RPCCP  and  remove  the  profile  named  /.:/LandS/anthro/molly_o_profile:  $  rpccp  rpccp>  remove  profile
       /.:/LandS/anthro/molly_o_profile

RELATED INFORMATION

       Commands: add element(1m), remove element(1m), show profile(1m)

																remove profile(1m)
All times are GMT -4. The time now is 03:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy