Re: ORA-03113: end-of-file on communication channel --- what causes it??

rvaratha <rengarajan_varatharajanNOreSPAM_at_hp.com.invalid> wrote in message <01ebce32.1769a5c6_at_usw-ex0101-001.remarq.com>...
> Let me know the environment, please answer the following Questions:
>
> 1. Is your Database down/crashed after you receive this Oracle Error ?

No. The database is still up and running. In fact, I use tkprof (I set trace on before running the select statement) to look at the trace file, but it doesn't give me much clue.

> 2. Do you run other Oracle Version (8.0.x, 7.3.x) Databases ?

Yes. Oracle 7.3.2.2.0, Oracle 7.3.4.0.0, and Oracle 8.0.5.0.0

> 3. If so, Do you run separate Listener for each Version of Oracle ?

Yes. I have two listeners running on the HPUX 10.20 host: host::/users/oracle/app/oracle/product/7.3.2.2 $ ps -ef | grep tns   oracle 3780 1 0 Oct 25 ? 2:51 /bscs13/oracle/product/7.3.4/bin/tnslsnr LISTENER -inherit   oracle 28034 1 0 Nov 2 ? 0:24 /bscs12/oracle/product/8.0.5/bin/tnslsnr LISTENER -inherit   oracle 11109 11083 1 17:44:13 ttypc 0:00 grep tns host::/users/oracle/app/oracle/product/7.3.2.2 $

> 4. Do you connect to the Database using TNS alias ?

Yes. Here's how I connect:
host::/users/oracle/app/oracle/product/7.3.2.2 $ sqlplus abc/def_at_ijk

SQL*Plus: Release 3.3.2.0.0 - Production on Wed Dec 1 17:47:40 1999

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Connected to:
Oracle7 Server Release 7.3.2.2.0 - Production Release With the distributed, parallel query and Spatial Data options PL/SQL Release 2.3.2.2.0 - Production

SQL> I also tried connecting by setting TWO_TASK in UNIX environment, and connect without using TNS alias, and, I got exactly the same error message, save for a longer wait in "hang" state.

>
> Thanks and Regards
> Varatha.
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Dec 01 1999 - 04:01:06 CST