zapatoa_at_email.msn.com writes:
> Edward:
>
> The 3113 is a pretty generic SQL*Net message indicative of many things.
> However, I would suggest you try lowering MAXDATA with >set maxdata 2048. The
> default is 20K. I have had this work, but believe the root cause may have
> something to do with the network packet size or something along those lines.
> Any further information you uncover while debugging this would be greatly
> appreciated. Please feel free to e-mail me directly. Thank-you.
One very common cause is the death of the Oracle server. Take a look at
$ORACLE_HOME\rdbms\log. If there are trace files there, they may correspond to
a fault that the server encountered. I suggest contacting Oracle Support. They
may already have a fix for the problem.
Rick
Rick Wessman
Security and Directory Technologies
Server Technologies
Oracle Corporation
rwessman_at_us.oracle.com
>
> Brian
>
> In article <01be2ee3$988799b0$5501a8c0_at_edj>,
> "ejiang" <ejiang_at_thru-put.com> wrote:
> > I was debugging sql queries using the Oracle SQL Worksheet in the Oracle
> > Enterprise Manager v. 1.3.5. The operating system is Windows NT 4.0.
> > When I enter SELECT * FROM VIEW; SQL Worksheet prints the records without
> > problem.
> > Somehow, if I specify one or more fields in the query ( e.g. SELECT QTY
> > FROM VIEW; or SELECT VIEW.QTY FROM VIEW; ),
> > The following error message appears:
> >
> > ORA-03113:end-of-file on comunication channel
> >
> > The connection to the database is also lost.
> >
> > Your advice on the cause and/or solution to the problem is greatly
> > appreciated.
> >
> > Edward
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Dec 28 1998 - 11:54:35 CST
