Re: crontab job loosing the Oracle env settings

Martin Klier <[email protected]> Tue, 24 Jul 2007 10:53:32 +0200

Newsgroups	gmane.linux.suse.oracle.general
Organization	A.T.U Auto-Teile-Unger Serveradministration
Message-ID	<[email protected]>

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

signature.asc (application/pgp-signature, 189 B)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQBGpb4RVKZfihvnEcQRAv2UAJ99t45SzXzcw92Md5XYEeW6j2jUOACgviYw
biGTvp5kmps/46PoMkLov8M=
=cMcQ
-----END PGP SIGNATURE-----