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:martin.klier@(protected)]
Sent: Tuesday, July 24, 2007 10:54 AM
To: suse-oracle@(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 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
--
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
martin.klier@(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: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
