oracle通信通道的文件结尾_如何解决ORA-03113: 通信通道的文件结尾？

主机蓝屏后，虚拟机里的数据库启动不了。

SQL> alter database open;

alter database open

*

第 1 行出现错误:

ORA-03113: 通信通道的文件结尾

进程 ID: 2348

会话 ID: 1 序列号: 5

SQL> select status from v$instance;

ERROR:

ORA-03114: 未连接到 ORACLE

Trace file E:\ORCL11\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_2348.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Windows NT Version V6.1 Service Pack 1

CPU : 1 – type 8664, 1 Physical Cores

Process Affinity : 0x0x0000000000000000

Memory (Avail/Total): Ph:2579M/4410M, Ph+PgF:5562M/8819M

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 19

Windows thread id: 2348, image: ORACLE.EXE (SHAD)

* 2015-10-29 19:01:34.584

* SESSION ID:(1.5) 2015-10-29 19:01:34.584

* CLIENT ID:() 2015-10-29 19:01:34.584

* SERVICE NAME:() 2015-10-29 19:01:34.584

* MODULE NAME:(sqlplus.exe) 2015-10-29 19:01:34.584

* ACTION NAME:() 2015-10-29 19:01:34.584

Thread 1 checkpoint: logseq 10, block 2, scn 2656402

cache-low rba: logseq 10, block 3

on-disk rba: logseq 10, block 102, scn 2656497

start recovery at logseq 10, block 3, scn 0

* 2015-10-29 19:01:34.974

Started writing zeroblks thread 1 seq 10 blocks 124-131

* 2015-10-29 19:01:34.990

Completed writing zeroblks thread 1 seq 10

==== Redo read statistics for thread 1 ====

Total physical reads (from disk and memory): 4096Kb

— Redo read_disk statistics —

Read rate (ASYNC): 60Kb in 0.82s => 0.07 Mb/sec

Longest record: 2Kb, moves: 0/116 (0%)

Longest LWN: 16Kb, moves: 0/38 (0%), moved: 0Mb

Last redo scn: 0x0000.00288906 (2656518)

—– Recovery Hash Table Statistics ———

Hash table buckets = 262144

Longest hash chain = 1

Average hash chain = 28/28 = 1.0

Max compares per lookup = 1

Avg compares per lookup = 211/239 = 0.9

* 2015-10-29 19:01:35.412

KCRA: start recovery claims for 28 data blocks

* 2015-10-29 19:01:35.427

KCRA: blocks processed = 28/28, claimed = 28, eliminated = 0

* 2015-10-29 19:01:35.474

Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0

* 2015-10-29 19:01:35.771

Completed redo application of 0.04MB

* 2015-10-29 19:01:36.021

Completed recovery checkpoint

—– Recovery Hash Table Statistics ———

Hash table buckets = 262144

Longest hash chain = 1

Average hash chain = 28/28 = 1.0

Max compares per lookup = 1

Avg compares per lookup = 239/239 = 1.0

Recovery sets nab of thread 1 seq 10 to 124 with 8 zeroblks

* 2015-10-29 19:01:37.287

kwqmnich: current time:: 11: 1: 36: 0

kwqmnich: instance no 0 repartition flag 1

kwqmnich: initialized job cache structure

kwqinfy: Call kwqrNondurSubInstTsk

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x44FDFF14] [PC:0xF345FE, kgegpa()+38]

DDE previous invocation failed before phase II

DDE was called in a ‘No Invocation Mode’

—– Start Diag Diagnostic Dump —–

Diag diagnostic dump is performed due to an error in the diagfw code during error handling.

DDE is switched to protected mode during the diagnostic dump to prevent recursive errors in the error hadnling code.

Dump error and call stack for the diagnostic dump:

* 2015-10-29 19:01:37.943

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)

—– Error Stack Dump —–

Dump file e:\orcl11\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_2348.trc

Thu Oct 29 19:01:37 2015

ORACLE V11.2.0.3.0 – 64bit Production vsnsta=0

vsnsql=16 vsnxtr=3

Dumping diagnostics for abrupt exit from ksedmp

ksedmp exception at address PC:0xF345FE

ksedmp exception at kgegpa()

Dumping initial exception call-stack

——————- Call Stack Trace ———————

Frameptr RetAddr Param#1 Param#2 Param#3 Param#4 Function Name

0000000000F345FE 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 kgegpa()+38

0000000000F35507 0000000000F345D8 0000000000000001 0000000000F35465 000000000CC61640 0000000000000001 kgeprm()+89

0000000000CE2E13 0000000000F354AE 000000000431FB50 000000014015BD85 0000000000002000 000007FF6287E608 dbgexPopulateErrorKGEFrame

0000000000CE2D22 0000000000CE2DF1 0000000000000008 000000000058AEEC 0000000000000001 0000000100002000 dbgexPopulateErrorKGE()+94

0000000000C916AF 0000000000CE2CC4 0000000011CDBD50 0000000000B23BB9 000000000CC61640 0000000000000001 dbgePostErrorKGE()+2213

0000000140C734D7 0000000000C90E0A 0000000011CDC310 0000000005261168 0000000000000258 0000122B4FEEF1F9 dbkePostKGE_kgsf()+77

0000000000F337F1 0000000140C7348A 0000000000000000 0000000000000000 00000001FFFFFFFF 0000027F00000000 kgeade()+563

0000000000F2FDE7 0000000000F335BE 0000000000000000 00000000135C23E8 0000000011CDBD50 00000000135C23A0 kgeriv_int()+139

0000000000F320BF 0000000000F2FD5C 0000000000000000 00000000135C0D50 0000000000024258 00000000135C0D50 kgeriv()+29

000000014001B647 0000000000F320A2 0000000000000000 0000000000C92D42 0000000011C89370 000007FF6284CED4 kseric2()+111

0000000142C9081D 000000014001B5D8 0000000000001062 0000000000000009 0000000000000017 000007FF3E854014 kturdb()+1671

00000001411E5D7C 0000000142C90196 0000000011CDC310 000000000000004E 000007FF00000055 000007FF6192D710 kco_issue_callback()+196

00000001411E74A6 00000001411E5CB8 00000001477A1980 0000000011CDC310 00000000018EEA90 0000000000FAB999 kcoapl()+746

00000001406ABE13 00000001411E71BC 00000000135C2310 000007FF3E854000 000007FF00000001 000000007FFFFFFF kcbapl()+241

00000001412D3C7B 00000001406ABD22 000000000431FB50 00000000FFFFFF00 0000000000000000 000000000025AD35 kcrfw_redo_gen()+3821

00000001406A3C21 00000001412D2D8E 000007FF5FF10838 0000001500000002 0000008000000007 0000000000000000 kcbchg1_main()+4607

00000001406A251B 00000001406A2A22 0000000000000001 00000000005D8D5E 000000000CC61640 0000000100000500 kcbchg1()+299

00000001408236D4 00000001406A23F0 0000000000000000 0000000100000002 0000000000000000 00000000135C2478 ktubgn()+1654

0000000140657A22 000000014082305E 000007FF61FD5FC8 000000000073CC38 0000000005270118 000000000527FD78 krvgfci_GatherFixedCommonI

000000014064EF8C 00000001406579AE 0000000011CDC010 0000000000B7DF50 0000000005250F05 0000000000000064 krvgrgd()+354

00000001441AC499 000000014064EE2A 0000000000000000 0000000000000000 0000000000000000 0000000000000000 knldcddl()+977

0000000142F8A216 00000001441AC0C8 0000000100000001 0000000000000000 5C6C637200000000 656C615C00000000 adbdrv()+742

0000000143473679 0000000142F89F30 000007FF00000023 000007FF00000003 0000000000000000 00000000135CA0E0 opiexe()+21501

00000001453602AA 000000014346E27C 000007FF00000004 0000000100000000 00000000135CA7C0 000007FF61930F60 opiosq0()+5150

00000001432CEA55 000000014535EE8C 0000000000000003 000000000000000E 00000000135CAAA0 00000000000000A4 kpooprx()+365

00000001432CD185 00000001432CE8E8 00000000135CAA30 00000000135CAA80 0000000011C89370 0000000000000001 kpoal8()+8619

0000000140C89322 00000001432CAFDA 000000000000005E 000000000000001C 00000000135CE080 0000000005193128 opiodr()+1644

00000000009434D3 0000000140C88CB6 000000000000005E 000000000000001C 00000000135CE080 0000000000000000 ttcpip()+1325

0000000140C85ABA 0000000000942FA6 0000000011CF8550 0000000000000000 0000000000000000 0000000000000000 opitsk()+2092

0000000143584C74 0000000140C8528E 000000000000001E 0000000000000000 0000000100000000 00000000006FCD8D opiino()+1246

0000000140C89322 0000000143584796 000000000000003C 0000000000000004 00000000135CFAB0 0000000000000000 opiodr()+1644

00000001400BD19C 0000000140C88CB6 000000000000003C 0000000000000004 00000000135CFAB0 4F5C3A4500000000 opidrv()+862

00000001400BE250 00000001400BCED4 000000000000003C 0000000000000004 00000000135CFAB0 0000000000000000 sou2o()+98

000000014000126C 00000001400BE1EE 01D11237445A2E97 0000000000000000 0012001D000A07DF 000403CB0036002F opimai_real()+158

00000001400010CD 00000001400011CE 0000000000000000 00000000135CFC68 0000000011C89370 00000000135CFC68 opimai()+191

0000000140002244 000000014000100E 0000000000000000 00000001476B9510 00000000000000E8 0000000000000644 OracleThreadStart()+724

000000007744652D 0000000140001F70 0000000013ACFF18 0000000000000000 0000000000000000 0000000000000000 000000007744652D

000000007757C521 0000000077446520 0000000000000000 0000000000000000 0000000000000000 0000000000000000 000000007757C521

—————- End of Call Stack Trace —————–

sss_xcpt_EvalFilterEx: setmav: Unable to convert access violation to OER(602)

retval is 1, InSXE is 1, kge data OK 0, setmav_allowed 1