04-29-2005
It's the environment - is $ORACLE_SID defined, ORACLE_HOME, etc.
crontab processes run without executing the same profiles that an interactive user runs.
10 More Discussions You Might Find Interesting
1. AIX
hi everybody,
i am Talip, a begginner at unix based systems and i have a problem (actually, we may think myself as the problem, in this situation).
i am not sure if this is the correct platform for my questions. if it is not please forgive me about this inappropriate mail.
what i have:
*... (2 Replies)
Discussion started by: talipk
2 Replies
2. Shell Programming and Scripting
Hi,
Can someone please help me here with this one.
This is my script:
# more tosh.sh
#!/usr/bin/ksh
clear
. /home/oracle/.profile
echo "Good morning, world."
export ORACLE_HOME=/u01/app/oracle/product/9.0.1
export PATH=$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_SID=xxxx
... (11 Replies)
Discussion started by: santoshpayal
11 Replies
3. Shell Programming and Scripting
Hi,
I'm having issues with executing sqlplus (silent mode) through the tcsh. (trying to save a value into a parameter...)
I assume that the issue is that there are new lines:
I tried the followings and got those errors:
set RESULT=`sqlplus -s USER/PASS@//localhost:1521/ABCD <<BLA
select *... (3 Replies)
Discussion started by: fcbman
3 Replies
4. UNIX for Advanced & Expert Users
Hi,
on AIX 6.1, I put in crontab ,execution of myscript. But it sends back the following error :
myscript.sh: rman: not found
And in myscript I have :
rman catalog rman/**@rep target / LOG=file.log << EOF
run
{
allocate channel t1 type disk;
.........
}
exit
EOF... (1 Reply)
Discussion started by: big123456
1 Replies
5. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
6. Shell Programming and Scripting
Hi,
This is the content in my .profile on a unix server,
MAIL=/usr/mail/${LOGNAME:?}
umask 027 #added by enRole Agent
PATH=${PATH}:/opt/app/p1crm1c3/informatica/oracle/product/10.2.0
export PATH
PATH=$PATH:/opt/app/p1crm1c3/informatica/oracle/product/10.2.0/network/admin/sqlnet.ora;export... (2 Replies)
Discussion started by: yohasini
2 Replies
7. Solaris
Hi,
I have a bourne shell script that needs to login into sqlplus and execute a stored procedure. I need this shell script to be run under a user crontab.
It works fine if run under normal shell prompt.
But it gave error message in my log file when run under crontab:
SQL*Plus: Release... (4 Replies)
Discussion started by: joe_x
4 Replies
8. Red Hat
Dear!
I've 2 scripts backup Oracle database in crontab environment, however, I found they did not execute. The cron is here
$ crontab -l
30 2 * * 0 sh /cloudbck/level0/level0.sh
19 3 * * * sh /cloudbck/level1/level1.sh
Then, I tried to find how did they not run by looking up... (8 Replies)
Discussion started by: trantuananh24hg
8 Replies
9. Shell Programming and Scripting
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
10. UNIX for Beginners Questions & Answers
Hello ,
Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this..
How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies
CRON(8) System Manager's Manual CRON(8)
NAME
cron - daemon to execute scheduled commands (Vixie Cron)
SYNOPSIS
cron
DESCRIPTION
Cron should be started from /etc/rc or /etc/rc.local. It will return immediately, so you don't need to start it with '&'.
Cron searches /var/spool/cron for crontab files which are named after accounts in /etc/passwd; crontabs found are loaded into memory. Cron
also searches for /etc/crontab and the files in the /etc/cron.d/ directory, which are in a different format (see crontab(5)). Cron then
wakes up every minute, examining all stored crontabs, checking each command to see if it should be run in the current minute. When execut-
ing commands, any output is mailed to the owner of the crontab (or to the user named in the MAILTO environment variable in the crontab, if
such exists).
Additionally, cron checks each minute to see if its spool directory's modtime (or the modtime on /etc/crontab) has changed, and if it has,
cron will then examine the modtime on all crontabs and reload those which have changed. Thus cron need not be restarted whenever a crontab
file is modified. Note that the Crontab(1) command updates the modtime of the spool directory whenever it changes a crontab.
SEE ALSO
crontab(1), crontab(5)
AUTHOR
Paul Vixie <paul@vix.com>
4th Berkeley Distribution 20 December 1993 CRON(8)