[prev in list] [next in list] [prev in thread] [next in thread] 

List:       python-db-sig
Subject:    Re: [DB-SIG] ORA-03113: end-of-file on communication channel\012
From:       "Wong Wah Meng-R32813" <WahMeng () freescale ! com>
Date:       2009-04-08 9:56:24
Message-ID: 73839B4A0818E747864426270AC332C303F1D9F7 () zmy16exm20 ! fsl ! freescale ! net
[Download RAW message or body]

Yes I did. There is no problem in executing the SQL in a SQLPLUS
session. In fact, I would say the hit ratio of this error is less than
0.01% (1/10,000) of the number of SQL that is executed by the oracledb
in my application. 

Regards,
Wah Meng 

-----Original Message-----
From: db-sig-bounces+wahmeng=freescale.com@python.org
[mailto:db-sig-bounces+wahmeng=freescale.com@python.org] On Behalf Of
Dennis Benzinger
Sent: Tuesday, April 07, 2009 8:27 PM
To: Wong Wah Meng-R32813
Cc: db-sig@python.org
Subject: Re: [DB-SIG] ORA-03113: end-of-file on communication
channel\012 error

Am 07.04.2009 13:36, Wong Wah Meng-R32813 schrieb:
> Hello guys,
> 
> I would like to post a question on an issue that I have encountered on

> an AIX 5.3 box. I intermittently encountered this issue when my 
> application access to database. Based on my troubleshooting with 
> Oracle DBA, I think I can rule out the cause of this is in the Oracle,

> as the SQL does pass through Oracle PARSE, EXECUTE and FETCH phase. 
> There is no way I can verify this at network level as both my 
> application and Oracle database reside on the same server.
> [...]

Did you try executing your statement from another computer? (Perhaps
with SQL*Plus?)


Dennis Benzinger
_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
[prev in list] [next in list] [prev in thread] [next in thread]