Re: crontab job loosing the Oracle env settings
Maurice Kemmann <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Organization | OpenIT GmbH |
| Message-ID | <[email protected]> |
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 -- To unsubscribe, email: [email protected] For additional commands, email: [email protected] Please see http://www.suse.com/oracle/ before posting