Originally posted by padmam
Dear Rahul, 22nd April 2001 14:18 hrs chennai

For the end of Communication channel oracle DOC suggest like this

ORA-03113 end-of-file on communication channel

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

Why dont you try setting up the net8 driver once again.?

it looks from the alert log the control file header and datafile header mismatch or block corruption try contacting oracle i am really sorry to say i have not experienced such a problem but interested in knowing the exact solution.

Cheers

Padmam


Finally i recovered the database-I have followed the following steps-

Connect using svrmgrl from dos prompt.
svrmgr> startup nomount;
svrmgr> alter database mount;
svrmgr> alter database backup controlfile to trace;
svrmgr> shutdown;
svrmgr> startup nomount;
Execeuted the create contol file command which is created in ora81\udump\
svrmgr> recover database;
svrmgr> alter database open;
svrmgr> shutdown;

Cheers
Rahul