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

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).