Re: SQL scripts and crontab

From: Mike O <ora7dba_at_yahoo.com>
Date: Mon, 11 Dec 2000 09:10:40 -0600
Message-ID: <912qof$255@nntpa.cb.lucent.com>

Vesa... as an example is as follows:

---

#!/bin/ksh
#
su - oracle -c '
export ORACLE_SID=GPC
export NB_ORA_CLASS=ora_gpc_online

$EBU_HOME/bin/ebu \
$EBU_HOME/scripts/online_gpc.ebu >> \
$EBU_HOME/scripts/online_gpc.log'
------------------
#!/bin/ksh
#
#
# ########################################

#
#
. /etc/oraenv_prismrpt.sh
sqlplus -s prism/soleman_at_prismrpt <<EOF

        set serverout on size 30000 ;
spool rf.lst
exec refresh_prism
spool off
exit

Mike O
Avaya Inc

Vesa Olkkonen wrote in message <912i5r$1eu$1_at_nntp.teliafi.net>...
>HI!
>
>I have unsuccesfully tried to run an automated SQL script via cron. If I
 run
>this script manyally there are no problems, but if I try to run it
>automatically via cron, I get the following error message:
>
>Message file sp1<lang>.msb not found.
>Error initializing SQL*Plus
>
>Has anybody notised this kind of error? I am running HP-UX and Oracle7.
>
>Thank you in advance!
>
>
>
>
Received on Mon Dec 11 2000 - 09:10:40 CST