Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script not working via crontab
Top Forums Shell Programming and Scripting Script not working via crontab Post 302934525 by ash12345 on Sunday 8th of February 2015 12:34:37 PM
Old 02-08-2015
Seems there is no issue in executing script

Below is the error i am getting when iam running by crontab.

SP2-0310: unable to open file "extract_data.sql "
SP2-0042: unknown command "end" - rest of line ignored.
SP2-0103: Nothing in SQL buffer to run.

Scrutinizer, seems there is no problem in shell [ksh/sh] as the later part of the script is giving output as expected and i think script is failing to connect to DB server and not generating CSV..
Code:
#!/bin/ksh
/export/home/oracle/app/oracle/product/11.2.0/client_1/bin/sqlplus -s /nolog << EOF
CONNECT user/user_1234@CBDTEST
@extract_data.sql [checked absolute path for too]
end;
/
EOF

 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. UNIX for Dummies Questions & Answers

Script is not longer working in the crontab

This is the crontab it is supossed to be running everyday but it didnt 5 0 * * * /export/app/CO/opge/scr/Informe_parametros_colombia.ksh >/dev/null 2>&1 Inside the above script connects to a database and extract data to a flat file, manually i run the script at about 2 a.m. and Works OK,... (6 Replies)
Discussion started by: alexcol
6 Replies

7. Shell Programming and Scripting

Expect script not working in crontab with minicom

Hi All, I am testing expect script in command prompt without issue, but in crontab it is not working, i check the output error as below: #cat /var/log/testexp.log spawn minicom -C /var/log/minicom1.log No cursor motion capability (cm) AT+COPS=? I am new in scripting, together... (1 Reply)
Discussion started by: elingtey
1 Replies

8. 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

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 DEBIAN

shcomp

SHCOMP(1)						    User Environment Utilities							 SHCOMP(1)

NAME

       shcomp - compile a ksh93 shell script

SYNOPSIS

       shcomp [ options ] [infile] [outfile]]

ORIGIN OF THIS MAN PAGE

       This man page was written by Christophe Martin <Schplurtz@free.fr> for the Debian GNU/Linux system. It is based on "shcomp --man" output.

DESCRIPTION

       Unless  -D  is  specified,  shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 can read and execute
       with the same effect as the original script.

       Since aliases are processed as the script is read, alias definitions whose value requires variable expansion will not work correctly.

       If -D is specified, all double quoted strings that are preceded by $ are output. These are the messages	that  need  to	be  translated	to
       locale specific versions for internationalization.

       If  outfile is omitted, then the results will be written to standard output.  If infile is also omitted, the shell script will be read from
       standard input.

OPTIONS

       -D, --dictionary
	      Generate a list of strings that need to be placed in a message catalog for internationalization.

       -n, --noexec
	      Displays warning messages for obsolete or non-conforming constructs.

       -v, --verbose
	      Displays input from infile onto standard error as it reads it.

       --man  Displays this man page on standard error and exits.

       --help Shows a short help message and exits.

EXIT STATUS

       0      Successful completion.

       >0     An error occurred.

DEBIAN WARNING

       On a Debian GNU/Linux system, more than one package may provide ksh. the output of shcomp can only be used by ksh93.  Any other ksh will be
       unable to run the compiled script.

EXAMPLE

       ( echo '#! /bin/ksh93' ; shcomp myscript ) > myscript.bin &&
       chmod 755 myscript.bin
       ./myscript.bin

SEE ALSO

       ksh(1)

IMPLEMENTATION

       version	       shcomp (AT&T Labs Research) 2012-02-29
       author	       David Korn <dgk@research.att.com>
       copyright       Copyright (c) 1982-2012 AT&T Intellectual Property
       license	       http://www.eclipse.org/org/documents/epl-v10.html

KSH93								  Fri Jun 3 2005							 SHCOMP(1)
All times are GMT -4. The time now is 04:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy