That's not always a good idea. Their may be settings in your .profile
that
don't play well with cron.
Best to setup an account especially for cron jobs, and include only what
is
necessary in the .profile.
Jared
Richard Ji <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/14/2002 11:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: e: when is an error msg not an error msg ?
You could just tell cron to execute your .profile before executing
the pro*c program, thus you don't necessarily need a wrapper.
-----Original Message-----
Sent: Thursday, November 14, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
Hello,
Thanks to all that replied.
Yes, it was an environmental issue. The Pro*C program was being executed
from cron without a wrapper, and cron being 'environmentally dumb' meant
that, despite the environment being properly set for the user, the job was
executed in a "void". The developers will wrap the executable and all
should
be okay afterwards.
Thank you,
Paul Sherman
DBA Elcom, Inc.
voice - 781-501-4143 (direct #)
fax - 781-278-8341 (secure)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, November 14, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L
This could happen when the ORACLE_HOME is not set correctly.
You may have the ORACLE_HOME in the .profile but your application
might be running from a script which unsets the ORACLE_HOME or
sets it incorrectly.
Hemanat
At 02:14 PM 13-11-02 -0800, you wrote:
>Hello,
>
>I've looked over hill and over dale at many web-sites (MetaLink, google,
>asktom, etc.), to no avail, so could someone on the list bail me out on
this
>question - what causes the following error message:
>
> ORACLE ERROR=>Error while trying to retrieve
text
>for error ORA-03114
>
>Now, I know what causes the 03114; I need to know why I am getting the
>'error while trying to retrieve... I get this error on my test and
>production servers, but not the development server. All have the same #
of
>files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file
missing
>somewhere that I know not of ? Any help would be greatly appreciated.
>
>Thank you,
>
>Paul Sherman
>DBA Elcom, Inc.
>voice - 781-501-4143 (direct #)
>fax - 781-278-8341 (secure)
>email - [EMAIL PROTECTED]
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Sherman, Paul R.
> 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).
Hemant K Chitale
My web site page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
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.com
--
Author: Sherman, Paul R.
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.com
--
Author: Richard Ji
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.com
--
Author:
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).
