Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Worksheet error message
I believe that message indicates that Oracle thought it had a dead
connection on a server process. You could run a listener trace and/or a
sqlnet trace to track it down, call Oracle, or do what I've done and switch
from multi-threaded server back to dedicated. (If you're not using MTS, I
apologize.)
ejiang wrote in message <01be2ee3$988799b0$5501a8c0_at_edj>...
>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
>
Received on Wed Dec 23 1998 - 22:07:12 CST