OraFAQ Forum: Server Administration » ORA-03113 end of file on communication channel

Home » RDBMS Server » Server Administration » ORA-03113 end of file on communication channel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03113 end of file on communication channel [message #58658]

Wed, 24 September 2003 08:04

Arvind Bhandari
Messages: 50
Registered: May 2003

Member

i am using ORACLE 8i on Windows NT. today i just receive an error when i login to SQL "ORA-01092 instance terminated.Disconnect forced" then i run SVRMGRL on DOS Prompt and connect through internal/oracle and start the Database by giving command Startup but it gives an message Oracle is running already shutdown it first.then i shutdown immediate and it gives an error ORACLE not available then i again give command shutdown abort and again give startup command then i got an error "ORA-03113 end of file on communication channel" can anybody help for this type of problem.
Here when i see all redo and DBF and control file in D:ORACLEoradataorcl folder it shows all 3 control for todays Date and all redo and Data DBF file of 22/09/2003 7:28 pm.

Report message to a moderator

Re: ORA-03113 end of file on communication channel [message #58659 is a reply to message #58658]

Wed, 24 September 2003 08:16

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

goto command prompt ->  cmd
set your sid        ->  set ORACLE_SID=< yourSid >
start /shut database  ->  using svrmgrl

Report message to a moderator

Re: ORA-03113 end of file on communication channel [message #58722 is a reply to message #58659]

Fri, 26 September 2003 23:43

Arvind Bhandari
Messages: 50
Registered: May 2003

Member

Hello Mahesh first of all thanks for taking interest. i have tried and set ORACLE_SID= ORCL in the DOS Prompt and startup through SVRMGRL and again its gives same error.
anyway i have recreate all 3 control files through Create Control file command and refer all datafiles and Redolog files.then i gave command
SVRMGRL> Alter database backup control file to trace and then gave command
SVRMGRL> Recover database using backup controlfile. this results to Complete recovery and gave command
SVRMRL> Alter database open resetlogs.
Now Databaase is open and i have recover all users and Data.

Arvind

Report message to a moderator

Previous Topic:	Add System User
Next Topic:	Re: ORA-03113 end of file on communication channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:33:00 CDT 2024