Home » Other » Client Tools » Using CRON to run sqlplus utilities
Using CRON to run sqlplus utilities [message #365381] Fri, 10 April 1998 10:45 Go to next message
Ken
Messages: 50
Registered: April 1998
Member
I have 2 sqlplus scripts, UTLB and UTLE, that I would like to have cron submit for me. I would like the UTLB script to run first thing in the morning and the UTLB script to run at the end of the day. I can manually run these from the unix prompt but when I try to get cron to run them nothing happens. Any suggestions on what I should do next? (btw I am using HP-UX 10.1)

Thanks
Re: Using CRON to run sqlplus utilities [message #365382 is a reply to message #365381] Fri, 10 April 1998 16:00 Go to previous messageGo to next message
Manish Thawani
Messages: 6
Registered: April 1998
Junior Member
Hi ,

I hope this example will help you.

Do a man on crontab if you want to see the syntax.
Also take care of the permisions when trying to execute through cron. The script should have execute permision and right ownership.

Let's say these are the entries in crontab .
# P110 database
45 17 * * 5 /ngbin/tsv/bin/ora_rbs_set.scr > /ngbin/tsv/log/p110_rbs.log
45 21 * * 1 /ngbin/tsv/bin/ora_rbs_set.scr > /ngbin/tsv/log/p110_rbs.log

example of the script ora_rbs_set.scr

!/bin/ksh
# Function:
export ORACLE_SID=p110
export ORACLE_HOME=`awk -F":" '$1~/^p110/ {print $2}' export PATH=$ORACLE_HOME/bin:$PATH

sqlplus -s <<!EOF
system/manager
spool output.log
select *
from DBA_ROLLBACK_SEGS
where
SEGMENT_NAME like 'RBS_0_'
and STATUS in ( 'OFFLINE','AVAILABLE')
;
spool off
exit
!EOF

Here is another example.

00 0 * * * /x/prod/pat/bin/pat_perform2.scr 1>/x/prod/pat/log/perform2.log
2>&1

pat_perform2.scr looks like

ORACLE_SID=pat1
ORACLE_HOME=/sys2/oracle/product/7.3.2
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID ORACLE_HOME PATH
sqlplus username/passwd @/x/prod/pat/sql/fin_svr_stats7.sql

All the best!
Bye!
Manish
Re: Using CRON to run sqlplus utilities [message #365386 is a reply to message #365382] Sat, 11 April 1998 13:20 Go to previous messageGo to next message
Mnaish Thawani
Messages: 2
Registered: April 1998
Junior Member
In brief the sql script should have ORACLE SID,HOME & PATH defined and the unix script that calls this sql script through cron should have right permisions.
Re: Using CRON to run sqlplus utilities [message #365706 is a reply to message #365386] Fri, 17 September 1999 09:52 Go to previous message
david zhao
Messages: 1
Registered: September 1999
Junior Member
Thank you
Next Topic: SQLPLUS / Solaris -- why no "doskey" ability?
Goto Forum:
  


Current Time: Thu Mar 28 21:35:30 CDT 2024