RE: Could not run export utility from cron job

From: Gary W. Parker <garywp_at_ev1.net>
Date: Wed, 10 Dec 2003 11:49:25 -0800
Message-ID: <F001.005D973D.20031210114925@fatcity.com>

Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Could not run export utility from cron jobMake 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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of Nguyen, David M
  Sent: Wednesday, December 10, 2003 11:24 AM   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

------=_NextPart_000_0191_01C3BF24.29862190 Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Could not run export utility from cron job</TITLE>

<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR></HEAD>
<BODY>
<DIV>Make=20
sure that you source your environment variables in the script.  At = the=20
least, set the $PATH variable to include the Oracle bin=20 directory.</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV>Jobs=20
executing from CRON do not automatically source the .profile when they = kick=20
off.</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
 <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: = ml-errors_at_fatcity.com=20
 [mailto:ml-errors_at_fatcity.com]On Behalf Of Nguyen, David=20 M Sent: Wednesday, December 10, 2003 11:24 AM To: = Multiple=20
 recipients of list ORACLE-L Subject: Could not run export = utility=20
 from cron job </DIV>
 I am = able to run export=20
 utility from CLI manually but when I schedule it to run from cron=20 job on SUN Solaris8<SPAN =

lang=3Den-us> it fails to run as it does = not recognize=20
 exp command.<FONT=20
 face=3DArial size=3D2>  Does someone have any = idea?<SPAN=20
 lang=3Den-us>  <FONT=20
 face=3DArial size=3D2>Below is the command I run export=20 manually.
 $exp = user/password=20
 tables.dmp
 Thanks, David<SPAN =

lang=3Den-us></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0191_01C3BF24.29862190--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary W. Parker
  INET: garywp_at_ev1.net

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 - 13:49:25 CST