Crontab jobs are normally run in Shell (/bin/sh), and only a limited number of environment variables are set by default. (An easy way to check is to run a script in cron with a line such as "set > ~/set.out" and examine the output.)
You can indeed add the environment variables that your script requires to the scripts themselves, or source them in. Yet another alternative is to add them directly to the crontab file. Cf. "man 5 crontab" for more info.
Kind regards,
Herta
-----Original Message-----
From: Yoav Givon [mailto:YGivon@(protected)]
Sent: Tuesday, July 24, 2007 10:59
To: Martin Klier; Maurice Kemmann
Cc: suse-oracle@(protected)
Subject: RE: [suse-oracle] 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: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)
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
