-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
recipients of list ORACLE-L
-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
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
I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually.
$exp
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
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,