RE: crontab job loosing the Oracle env settings

Thank you Maurice and Martin . 

I thought   that as Crontab jobs are created BY the running user and run on his user account this will preserve his environment ... 

Have a nice day and thank you again !. 

Yoav 

-----Original Message-----
From: Martin Klier [mailto:[email protected]] 
Sent: Tuesday, July 24, 2007 10:54 AM
To: [email protected]
Cc: Maurice Kemmann; Yoav Givon
Subject: Re: [suse-oracle] crontab job loosing the Oracle env settings

Hi,

alternatively, depending on your OS, you may want to source the global 
environment file, for Linux e.g. /etc/profile.

Am Dienstag 24 Juli 2007 10:49 schrieb Maurice Kemmann:
> 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 [email 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

-- 
Freundliche Grüße

i.A.
Martin Klier
Systemadministration/Datenbanken
------------------------------------------------------------------
A.T.U Auto-Teile-Unger
Handels GmbH & Co. KG
Dr.-Kilian-Str. 4 
92637 Weiden i.d. OPf.

Tel.: +49 961 306-5663
Fax : +49 961 306-5982

[email protected]
www.atu.eu

Sitz: Weiden i. d. Opf., Amtsgericht Weiden i. d. OPf., HRA 2012
UST-ID Nr. DE814195392, WEEE-Nr. DE53789710
Persönlich haftende Gesellschafterin:
AFM Autofahrerfachmarkt Geschäftsführungs GmbH
Sitz: Weiden i. d. OPf., Amtsgericht Weiden i. d. OPf., HRB 2842
Geschäftsführer: Karsten Engel, Dirk Müller, Manfred Ries

-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting