-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Nguyen, David M
Sent: Wednesday, December 10, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Could not run export utility from cron job
I am able to run export utility from CLI
Ken:
When running from cron the user's .profile does not get executed. So your
ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment.
So on the line that you want to execute the export. Before the exp command
add . ~/.profile (without the double quotes) exp user/password
Simpson, Ken wrote:
I'm pretty sure that jobs running out of cron do not source in .profile
so you probably don't
have the Oracle environment set and therefor exp is not in your PATH.
Ken
How about adding the line:
source path_to_your_profile/.(bash_)profile
to the shell script that runs exp?
How about setting it up to execute in 10 minutes? Testing things this minute
isn't exactly the point with cron.
On 12/10/2003 02:09:24 PM, Bricklen Anderson wrote:
Simpson, Ken wrote:
I'm pretty sure that jobs running out of cron do not source in .profile
so you probably don't
have the
Title: Could not run export utility from cron job
You
need to load user's .profile in your cronjob (to set ENVs), becuase the unix
user who executes cronjob does not have it's profile loaded.
HTH.
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On
Title: Could not run export utility from cron job
Make
sure that you source your environment variables in the script. At the
least, set the $PATH variable to include the Oracle bin
directory.
Jobs
executing from CRON do not automatically source the .profile when they kick
off.
have you _sourced_ your .profile? cron won't do it automatically for you.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,