RE: e: when is an error msg not an error msg ?

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 <richard.ji_at_mobilespring.com> Sent by: root_at_fatcity.com
 11/14/2002 11:48 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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 - psherman_at_elcom.com

-----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 - psherman_at_elcom.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Sherman, Paul R.
> INET: PSherman_at_elcom.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).

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: hkchital_at_singnet.com.sg

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.com
-- 
Author: Sherman, Paul R.
  INET: PSherman_at_elcom.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.com
-- 
Author: Richard Ji
  INET: richard.ji_at_mobilespring.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.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).