RE: Could not run export utility from cron job
-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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 *** Ron Cetnar Supervising Programmer/Analyst/Oracle DBA ITS - University Applications Development State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] 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: [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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Could not run export utility from cron job
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? Unfortunately, I'm not in a position to test this where I am right this minute. -- PresiNET Systems http://www.PresiNET.com Online Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Could not run export utility from cron job
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 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? Unfortunately, I'm not in a position to test this where I am right this minute. -- PresiNET Systems http://www.PresiNET.com Online Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Could not run export utility from cron job
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 Behalf Of Nguyen, David MSent: Wednesday, December 10, 2003 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Could not run export utility from cron job
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. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David MSent: Wednesday, December 10, 2003 11:24 AMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Could not run export utility from cron job
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, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).