Dear Yoav,

Am Dienstag, den 24.07.2007, 10:31 +0200 schrieb Yoav Givon:

> ...
> QUESTION - Do I have  to add something to the crontab job to facilitate
> the oracle environment ? Have I missed something else here ?

you should perform the script as oracle user of course and in addition
to that you should set your environment parameters as well.

E.G.:

crontab
========
# Oracle Script - once a day
00 23 * * *    oracle /opt/bin/ora-script.sh

Beginning of the Script
========================

#!/bin/bash

export ORACLE_BASE=/opt/oracle
export ORACLE_SID=SID
export ORACLE_HOME=$ORACLE_BASE/OraHome

## starting the script ...

Hope it helps,

Maurice



--
OpenIT GmbH                   tel  +49 211 239 577-0
Maurice Kemmann                 fax  +49 211 239 577-10
Jahnstr. 18                   email kemmann@(protected)
D-40215 D??sseldorf               http://www.openit.de
________________________________________________________________
HRB 38815 Amtsgericht D??sseldorf   USt-Id DE 812951861
Gesch??ftsf??hrer:
Susanne Schultz, Oliver Haakert, Maurice Kemmann



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting