Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-03113 error using Oracle 8.1.7 on WLS 7.0 SP2

3 views
Skip to first unread message

Makoto Suzuki

unread,
Aug 13, 2003, 9:54:43 PM8/13/03
to
Hello everyone,

I've searched through the net and also this newsgroup about this particular
error, but haven't come to a conclusion as to where the problem resides. Our
app issues a SELECT query based on the user input and displays (and
generates) the search result as a online/downloadable report form.

Here's the stack trace of the error:

ORA-03113: end-of-file on communication channel

java.sql.SQLException: ORA-03113: end-of-file on communication channel

at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:251)

at weblogic.jdbc.oci.Statement.execute(Statement.java:531)

at weblogic.jdbc.pool.Statement.execute(Statement.java:216)

at
weblogic.jdbc.rmi.internal.StatementImpl.execute(StatementImpl.java:2

08)

at
weblogic.jdbc.rmi.SerialStatement.execute(SerialStatement.java:309)

at
com.hoike.punahou.reports.StudentRecordReports.getStudentIDsFromDB(St

udentRecordReports.java:885)

at
com.hoike.punahou.reports.StudentRecordReports.generateReport(Student

RecordReports.java:608)

at
com.hoike.punahou.reports.StudentRecordReports.onClickGenerateReport(

StudentRecordReports.java:390)

at java.lang.reflect.Method.invoke(Native Method)

at
com.documentum.web.form.FormProcessor.invokeMethod(FormProcessor.java

:878)

at
com.documentum.web.form.FormProcessor.fireActionEvent(FormProcessor.j

ava:606)

at
com.documentum.web.form.RecallOperation.execute(RecallOperation.java:

98)

at
com.documentum.web.form.FormProcessor.openForm(FormProcessor.java:151

)

at
com.documentum.web.form.WebformTag.doStartTag(WebformTag.java:124)

at
jsp_servlet._custom._reports.__studentrecord_reports._jspService(__st

udentrecord_reports.java:174)

at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)

at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run

(ServletStubImpl.java:1058)

at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:401)

at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:306)

at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio

n.run(WebAppServletContext.java:5412)

at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic

eManager.java:744)

at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe

rvletContext.java:3086)

at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm

pl.java:2544)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)


When I check the sqlnet.log, I don't see ORA-03113 error. But I see
TNS-12600 and TNS-5300 error with secondary code 126. I'm not sure if these
two are related to ORA-03113 error displayed in the console.

Here is a sniplet from sqlnet.log:

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS=
'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL
)(CID=(PROGRAM=C:\bea\jdk131_03\bin\java.exe)(HOST=HDMAPP3)(USER=Administrat
or))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 8.1.7.0.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 -
Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
8.1.7.0.0 - Production

Time: 13-AUG-2003 13:11:49

Tracing not turned on.

Tns error struct:

nr err code: 0

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 126

nt OS err code: 0

Our DBA says MTS is not enabled. I also made sure that the
java.sql.Connection and java.sql.ResultSet objects are closed as soon as
they are no longer needed. We're using WLS 7.0 SP2 with Oracle 8.1.7, with
jDriver for Oracle (and Oracle 8i client).

Does anyone have any insight to where the cause of this problem be? and if
the errors (ORA-03113 and TNS errors) are related at all?

Thank you very much!
Makoto


Joseph Weinstein

unread,
Aug 14, 2003, 2:09:44 AM8/14/03
to Makoto Suzuki

Makoto Suzuki wrote:

> Hello everyone,
>
> I've searched through the net and also this newsgroup about this particular
> error, but haven't come to a conclusion as to where the problem resides. Our
> app issues a SELECT query based on the user input and displays (and
> generates) the search result as a online/downloadable report form.
>
> Here's the stack trace of the error:
>
> ORA-03113: end-of-file on communication channel
>
> java.sql.SQLException: ORA-03113: end-of-file on communication channel

Hi. This looks to be a problem with a mismatch between the JDBC driver version and the
DBMS. You should download the latest thin driver that they recommend for the DBMS
version you have, and put the zip file where it will be put in front of all the official
weblogic stuff in the server's classpath.
Joe

Mitesh Patel

unread,
Aug 14, 2003, 10:01:55 AM8/14/03
to Makoto Suzuki
I believe you are using weblogic jDriver. I see ora-12560 at the end.
Check addresses used for proper protocol specification. For this error, look at
the error stack and check for lower level transport errors. For further details,
turn on tracing and re-execute the operation. Turn off tracing when the
operation is complete or you will use a lot of disk space. The trace file will
have details of the problem.

Thanks,
Mitesh

Makoto Suzuki

unread,
Aug 14, 2003, 3:38:57 PM8/14/03
to
Hi Mitesh,

Thanks for your insight - how do I turn on the tracing? Do I do that on
Oracle client side, or on the jDriver?

Thanks!
Makoto

"Mitesh Patel" <Mitesh...@bea.com> wrote in message
news:3F3B9653...@bea.com...

Makoto Suzuki

unread,
Aug 14, 2003, 4:07:34 PM8/14/03
to
Hi Joe,

Thanks for your input - I'm using the jDriver for Oracle 8.1.7 with Oracle
8.1.7. is there any other components whose version I should check? The path
to jDriver shared library (oci817_8) and to %ORACLE_HOME%\bin are put at the
beginning of the path, which is prepended by c:\bea7\weblogic700\server\bin
and c:\bea7\jdk131_03\bin by the startWLS.cmd.

Thank you,
Makoto

Mitesh Patel

unread,
Aug 14, 2003, 3:49:14 PM8/14/03
to Makoto Suzuki
I believe you should do that on oracle side.

Mitesh

Joseph Weinstein

unread,
Aug 14, 2003, 4:46:10 PM8/14/03
to Makoto Suzuki
Message-ID: <3F3BF512...@bea.com>
Date: Thu, 14 Aug 2003 13:46:10 -0700
From: Joseph Weinstein <j...@bea.com>
Organization: B.E.A. Systems
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: weblogic.developer.interest.jdbc
To: Makoto Suzuki <msu...@hoike.net>
Subject: Re: ORA-03113 error using Oracle 8.1.7 on WLS 7.0 SP2
References: <3f3a...@newsgroups.bea.com> <3F3B27A8...@bea.com> <3f3b...@newsgroups.bea.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.148.48.18
X-Original-NNTP-Posting-Host: 216.148.48.18
X-Trace: newsgroups.bea.com 1060893795 216.148.48.18 (14 Aug 2003 13:43:15 -0700)
X-Original-Trace: 14 Aug 2003 13:43:15 -0700, 216.148.48.18
Lines: 33
XPident: Unknown
Path: newsgroups.bea.com!not-for-mail
Xref: newsgroups.bea.com weblogic.developer.interest.jdbc:17548

Makoto Suzuki wrote:

> Hi Joe,
>
> Thanks for your input - I'm using the jDriver for Oracle 8.1.7 with Oracle
> 8.1.7. is there any other components whose version I should check? The path
> to jDriver shared library (oci817_8) and to %ORACLE_HOME%\bin are put at the
> beginning of the path, which is prepended by c:\bea7\weblogic700\server\bin
> and c:\bea7\jdk131_03\bin by the startWLS.cmd.

Hmmmmm.... That sounds right. Does Oracle have older and newer versions
of 8.1.7 or is that as small an update as oracle does?
From the original stacktrace, it seems you're simply executing a statement. Can
you trry using the oracle thin driver, and see if the same thing happens?
thanks,
Joe

0 new messages