I have read "ORA-03113: end-of-file on communication channel" on startup and others from this site to solve my problem but I still have not solved it. All I get is the following:
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Windows\system32>sqlplus /nolog SQL*Plus: Release 18.104.22.168.0 - Production on Sat Jun 28 17:28:20 2014 Copyright (c) 1982, 2007, Oracle. All rights reserved. SQL> connect / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 209235968 bytes Fixed Size 1332188 bytes Variable Size 125832228 bytes Database Buffers 75497472 bytes Redo Buffers 6574080 bytes Database mounted. SQL> alter system set db_recovery_file_dest_size=35G scope=both; System altered. SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 209235968 bytes Fixed Size 1332188 bytes Variable Size 125832228 bytes Database Buffers 75497472 bytes Redo Buffers 6574080 bytes Database mounted. Database opened. SQL> select instance_name from v$instace; select instance_name from v$instace * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 43880 Session ID: 170 Serial number: 5 SQL>
Environment: Windows 7 64 bit, Oracle 11g.
Here are the details from alerts.log:
Sat Jun 28 17:32:26 2014 Flush retried for xcb 0x8a6711a8, pmd 0x8afba968 Doing block recovery for file 3 block 2686 Block recovery from logseq 13, block 68 to scn 132386303 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13 Reading mem 0 Mem# 0: E:\APP\TRUCNGUYEN\ORADATA\XDLL\REDO01.LOG Block recovery completed at rba 13.69.16, scn 0.132386305 Errors in file e:\app\trucnguyen\diag\rdbms\xdll\xdll\trace\xdll_pmon_55932.trc (incident=36103): ORA-00600: internal error code, arguments: , , , , , , ,  Errors in file e:\app\trucnguyen\diag\rdbms\xdll\xdll\trace\xdll_pmon_55932.trc: ORA-00600: internal error code, arguments: , , , , , , ,  PMON (ospid: 55932): terminating the instance due to error 472 Sat Jun 28 17:32:27 2014 Errors in file e:\app\trucnguyen\diag\rdbms\xdll\xdll\trace\xdll_q001_79168.trc: ORA-00472: PMON process terminated with error ORA-1092 : opidrv aborting process Q001 ospid (2836_79168) Sat Jun 28 17:32:27 2014 ORA-1092 : opidrv aborting process W000 ospid (2836_56844) Sat Jun 28 17:32:29 2014 ORA-472 : opidrv aborting process S000 ospid (2836_85052) Instance terminated by PMON, pid = 55932
I'm a newbie in Oracle. I would really appreciate any direction and especially step by step instructions to fix this.
I have run the commands:
recover database; alter database open;
but it still has the same error when I run:
select instance_name from v$instance;