| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Could not run export utility from cron job
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 tables.dmp. This will execute the .profile first, set your environments and then do the export.
Ron
State University of New York at Albany
MSC 100
1400 Washington Ave
Albany, NY 12222
Email: rcetnar_at_uamail.albany.edu
Work: (518) 437-4535
Fax: (518) 437-4540
-----Original Message-----
Sent: Wednesday, December 10, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
-----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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 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 user/password tables.dmp
> Thanks,
> David
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken INET: Ken_Simpson_at_troweprice.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Cetnar INET: RCetnar_at_uamail.albany.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Dec 10 2003 - 12:59:25 CST
 |
 |