Re: Apache::DBI / DBD::Oracle error

[Mark Vandenbroeck]

Hi all,

There seems to be some confusion and even incorrectness in this trail. Let's get some things straight :

• There is nothing wrong with NLS_LANG. In fact, it is extremely useful in an international setting. Your value is fine.
• ORA_NLS33 is obsolete in 8.1.7 and should not be set
• Failure to translate error number to text : Oracle constructs the name of it's message file from the ORACLE_HOME, plus some path, some language code and some product code. You get the error when it can't find the message file. Either the file doesn't exist (shouldn't happen) or it can't find it. Best guess is the ORACLE_HOME is not set or not set correctly.
• You can always find the error text yourself in $ORACLE_HOME/rdbms/mesg/oraus.msg by grepping for the error number
• First step to tackle an ORA-3113 ("End-of-file on Communication Channel") is _always_ to find the tracefile in user_dump_dest on the server side and interpret what's in there. The stuff in there is not usually fit for human consumption, but intended for Oracle Support. Nevertheless, it contains all the clues. I should know, I did this kind of support for 7 years.

Hope this helps,

Mark
 

Ged Haywood wrote:

Hi again,

On Tue, 12 Jun 2001, Eric Kolve wrote:

> Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1.

I seemed to get on better by removing NLS_LANG and ORA_NLS33 from
my environment altogether.

> BTW, I am also using the latest oracle client libs (8.17) if this
> makes any difference;

Dunno!

> as well, I am using perl 5.005.

Shouldn't think that would stop you, but I'm using 5.7.0.

> > > DBD::Oracle::db rollback failed: Error while trying to retrieve text for
> > > error ORA-03113 (DBD ERROR: OCITransRollback) at

This is really two errors.  The first (03113) is a connect problem as
was mentioned by another correspondent, the second is translating the
numeric error into a text message for you to read, which is a very
frustrating thing that Oracle seems to do a lot.  I found that some of
the errors weren't a problem if the text could be shown to you, but if
not then they were show-stoppers.  Hence the concern with the language
support stuff.

Have you tried the Oracle knowledge base?  It's really good.

73,
Ged.

-- 
Mark Vandenbroeck                      Mobile : +32-495-59.55.62
Business Process Manager               Email  : [EMAIL PROTECTED] 
EMEA Support Information Systems       AIM    : markvdb