Re: Apache::DBI / DBD::Oracle error
On Mon, Jun 11, 2001 at 04:15:15PM -0700, Eric Kolve wrote: I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts with mod_perl, I get the following error: DBD::Oracle::db rollback failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCITransRollback) at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153. An error while retrieving the text for an error message may mean that ORACLE_HOME is not set properly. Ronald
Re: Apache::DBI / DBD::Oracle error
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
Re: Apache::DBI / DBD::Oracle error
Hi there, On Tue, 12 Jun 2001, Mark Vandenbroeck wrote: There seems to be some confusion and even incorrectness in this trail. Let's get some things straight : Thanks for setting me straight! 73, Ged.
Re: Apache::DBI / DBD::Oracle error
Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1. BTW, I am also using the latest oracle client libs (8.17) if this makes any difference; as well, I am using perl 5.005. --eric Ged Haywood wrote: Hi there, On Mon, 11 Jun 2001, Eric Kolve wrote: I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts with mod_perl, I get the following error: DBD::Oracle::db rollback failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCITransRollback) at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153. I am running Apache::DBI 0.88. I didn't see this error with DBI 1.14 + DBD::Oracle 1.06. Anyone have any ideas? Have you done something else as well? I don't think it's necessarily DBI/DBD related, I think It's somthing to do with National Language Support (NLS). Have you got NLS_LANG or ORA_NLS33 set to something? 73, Ged.
Re: Apache::DBI / DBD::Oracle error
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.
Re: Apache::DBI / DBD::Oracle error
Hi there, On Mon, 11 Jun 2001, Eric Kolve wrote: I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts with mod_perl, I get the following error: DBD::Oracle::db rollback failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCITransRollback) at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153. I am running Apache::DBI 0.88. I didn't see this error with DBI 1.14 + DBD::Oracle 1.06. Anyone have any ideas? Have you done something else as well? I don't think it's necessarily DBI/DBD related, I think It's somthing to do with National Language Support (NLS). Have you got NLS_LANG or ORA_NLS33 set to something? 73, Ged.
