SQL> startup mount ;
ORACLE instance started.
ORA-03113: end-of-file on communication channel
Process ID: 15384
Session ID: 355 Serial number: 40197----详细trace日志
Trace file /u01/app/oracle/diag/rdbms/aibs/AIBS/trace/AIBS_ora_15118.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME: /u01/app/oracle/product/12.2.0.1/db_1
System name: Linux
Node name: FC-database-200-135
Release: 2.6.32-358.el6.x86_64
Version: #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine: x86_64
Instance name: AIBS
Redo thread mounted by this instance: 0 <none>
Oracle process number: 35
Unix process pid: 15118, image: oracle@FC-database-200-135 (TNS V1-V3)
*** 2017-07-15T09:35:47.042152+08:00 (CDB$ROOT(1))
*** SESSION ID:(355.15156) 2017-07-15T09:35:47.042213+08:00
*** CLIENT ID:() 2017-07-15T09:35:47.042221+08:00
*** SERVICE NAME:() 2017-07-15T09:35:47.042227+08:00
*** MODULE NAME:(sqlplus@FC-database-200-135 (TNS V1-V3)) 2017-07-15T09:35:47.042233+08:00
*** ACTION NAME:() 2017-07-15T09:35:47.042239+08:00
*** CLIENT DRIVER:(SQL*PLUS) 2017-07-15T09:35:47.042245+08:00
*** CONTAINER ID:(1) 2017-07-15T09:35:47.042251+08:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2D] [PC:0x3573C30, qergsAllocate()] [flags: 0x0, count: 1]
2017-07-15T09:35:47.097090+08:00
Incident 165937 created, dump file: /u01/app/oracle/diag/rdbms/aibs/AIBS/incident/incdir_165937/AIBS_ora_15118_i165937.trc
ORA-07445: exception encountered: core dump [qergsAllocate()] [SIGSEGV] [ADDR:0x2D] [PC:0x3573C30] [Address not mapped to object] []ssexhd: crashing the process...
Shadow_Core_Dump = partial
ksdbgcra: writing core file to directory '/u01/app/oracle/diag/rdbms/aibs/AIBS/cdump'
(END)
----详细AIBS_ora_15118_i165937.trc信息[TOC00001-END]
[TOC00002]
========= Dump for incident 165937 (ORA 7445 [qergsAllocate]) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 11857.66M / 15951.59M
Swap (Avail / Total) = 8047.99M / 8047.99M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2D] [PC:0x3573C30, qergsAllocate()] [flags: 0x0, count: 1]
Registers:
%rax: 0x000000000000002d %rbx: 0x0000000071ff5710 %rcx: 0x00007f6082376f20
%rdx: 0x0000000000000001 %rdi: 0x00007f6081cfb810 %rsi: 0x0000000000000000
%rsp: 0x00007fffd99fcfd8 %rbp: 0x00007fffd99fd080 %r8: 0x00000000677c9400
%r9: 0x00007f6081cfb810 %r10: 0x0000000000000001 %r11: 0x0000000000053f08
%r12: 0x00007f6082376f20 %r13: 0x0000000000000000 %r14: 0x00007f6081cfb810
%r15: 0x0000000000000000 %rip: 0x0000000003573c30 %efl: 0x0000000000010293
> (0x3573c30) add %al,(%rax)
(0x3573c32) add %al,(%rax)
(0x3573c34) add %al,(%rax)
(0x3573c36) add %al,(%rax)
(0x3573c38) add %al,(%rax)*** 2017-07-15T09:35:47.099498+08:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=0mtwvr49kxt2m) -----
SELECT DECODE(null,'','Total System Global Area','') NAME_COL_PLUS_SHOW_SGA, SUM(VALUE), DECODE (null,'', 'bytes','') units_col_plus_show_sga FROM V$SGA UNION ALL SELECT NAME NAME_COL
_PLUS_SHOW_SGA , VALUE, DECODE (null,'', 'bytes','') units_col_plus_show_sga FROM V$SGA
[TOC00004-END][TOC00005]
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+119 call kgdsdst() 7F608204B7B8 000000003
7F608202D220 ? 7F608202D338 ?
2442444300000000 000000083 ?
dbkedDefDump()+1200 call ksedst() 000000001 000000003 ?
7F608202D220 ? 7F608202D338 ?
2442444300000000 ?
000000083 ?
ksedmp()+259 call dbkedDefDump() 000000003 000000003
7F608202D220 ? 7F608202D338 ?
2442444300000000 ?
000000083 ?
ssexhd()+3188 call ksedmp() 00000044F 000000003 ?
7F608202D220 ? 7F608202D338 ?
2442444300000000 ?
000000083 ?
sslssSynchHdlr()+39 call ssexhd() 000000001 000000000
9 7F608204ED70 7F608204EC40
7F608204EB80 000000083 ?
sslsshandler()+118 call sslssSynchHdlr() 000002000 000000000 000000000
7F608204EC40 ? 7F608204EB80 ?
000000083 ?
__sighandler() call sslsshandler() 00000000B 7F608204ED70
7F608204EC40 7F608204EC40 ?
7F608204EB80 ? 000000083 ?
qergsAllocate() signal __sighandler() 7F6081CFB810 000000000
000000001 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknRwsAllocateTree( call qergsAllocate() 7F6081CFB810 ? 000000000 ?
)+206 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknRwsAllocateTree( call qknRwsAllocateTree( 7F6081CFB810 ? 000000000 ?
)+176 ) 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknRwsAllocateTree( call qknRwsAllocateTree( 7F6081CFB5D8 ? 000000000 ?
)+176 ) 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknDoRwsAllocate()+ call qknRwsAllocateTree( 7F6081CFB248 ? 000000000 ?
32 ) 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qkaTraverseQknDesce call qknDoRwsAllocate() 7F6081CFB248 ? 000000000 ?
ndents()+714 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qkaTraverseQkn()+22 call qkaTraverseQknDesce 7F6081CEFA78 ? 000000000 ?
7 ndents() 000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
qkadrv2Post()+1111 call qkaTraverseQkn() 7F6081CEFA78 ? 000000000 ?
000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
qkadrv2()+418 call qkadrv2Post() 000000001 ? 000000000 ?
000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
opitca()+2511 call qkadrv2() 071FFFC18 ? 000000000 ?
000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
kksLoadChild()+1132 call opitca() 7F6081CDCAC8 071FFFC18
6 7FFFD99FF9B0 000000000 ?
000000000 ? 7F6081CFB810 ?
kxsGetRuntimeLock() call kksLoadChild() 7F6082334980 071FFFC18 ?
+2029 7FFFD99FF9B0 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
kksfbc()+15091 call kxsGetRuntimeLock() 7F6082334980 7F6081CDCAC8
7FFFD99FF930 000000000 ?
000000000 ? 074B8ED20
kkspsc0()+2130 call kksfbc() 7F6081CDCAC8 7F6081CDCAC8 ?
7FFFD99FF930 ? 000000000 ?
000000000 ? 074B8ED20 ?
kksParseCursor()+12 call kkspsc0() 7F6081CC2410 7FFFD9A01D00
3 00000011A 000000003 000000006
0000000A4
opiosq0()+2391 call kksParseCursor() 7FFFD9A00728 ? 7FFFD9A01D00 ?
00000011A ? 000000003 ?
000000006 ? 0000000A4 ?
kpooprx()+392 call opiosq0() 000000003 7FFFD9A01D00 ?
000000000 ? 0000000A4
000000000 000000000
:
ORACLE instance started.
ORA-03113: end-of-file on communication channel
Process ID: 15384
Session ID: 355 Serial number: 40197----详细trace日志
Trace file /u01/app/oracle/diag/rdbms/aibs/AIBS/trace/AIBS_ora_15118.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME: /u01/app/oracle/product/12.2.0.1/db_1
System name: Linux
Node name: FC-database-200-135
Release: 2.6.32-358.el6.x86_64
Version: #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine: x86_64
Instance name: AIBS
Redo thread mounted by this instance: 0 <none>
Oracle process number: 35
Unix process pid: 15118, image: oracle@FC-database-200-135 (TNS V1-V3)
*** 2017-07-15T09:35:47.042152+08:00 (CDB$ROOT(1))
*** SESSION ID:(355.15156) 2017-07-15T09:35:47.042213+08:00
*** CLIENT ID:() 2017-07-15T09:35:47.042221+08:00
*** SERVICE NAME:() 2017-07-15T09:35:47.042227+08:00
*** MODULE NAME:(sqlplus@FC-database-200-135 (TNS V1-V3)) 2017-07-15T09:35:47.042233+08:00
*** ACTION NAME:() 2017-07-15T09:35:47.042239+08:00
*** CLIENT DRIVER:(SQL*PLUS) 2017-07-15T09:35:47.042245+08:00
*** CONTAINER ID:(1) 2017-07-15T09:35:47.042251+08:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2D] [PC:0x3573C30, qergsAllocate()] [flags: 0x0, count: 1]
2017-07-15T09:35:47.097090+08:00
Incident 165937 created, dump file: /u01/app/oracle/diag/rdbms/aibs/AIBS/incident/incdir_165937/AIBS_ora_15118_i165937.trc
ORA-07445: exception encountered: core dump [qergsAllocate()] [SIGSEGV] [ADDR:0x2D] [PC:0x3573C30] [Address not mapped to object] []ssexhd: crashing the process...
Shadow_Core_Dump = partial
ksdbgcra: writing core file to directory '/u01/app/oracle/diag/rdbms/aibs/AIBS/cdump'
(END)
----详细AIBS_ora_15118_i165937.trc信息[TOC00001-END]
[TOC00002]
========= Dump for incident 165937 (ORA 7445 [qergsAllocate]) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 11857.66M / 15951.59M
Swap (Avail / Total) = 8047.99M / 8047.99M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2D] [PC:0x3573C30, qergsAllocate()] [flags: 0x0, count: 1]
Registers:
%rax: 0x000000000000002d %rbx: 0x0000000071ff5710 %rcx: 0x00007f6082376f20
%rdx: 0x0000000000000001 %rdi: 0x00007f6081cfb810 %rsi: 0x0000000000000000
%rsp: 0x00007fffd99fcfd8 %rbp: 0x00007fffd99fd080 %r8: 0x00000000677c9400
%r9: 0x00007f6081cfb810 %r10: 0x0000000000000001 %r11: 0x0000000000053f08
%r12: 0x00007f6082376f20 %r13: 0x0000000000000000 %r14: 0x00007f6081cfb810
%r15: 0x0000000000000000 %rip: 0x0000000003573c30 %efl: 0x0000000000010293
> (0x3573c30) add %al,(%rax)
(0x3573c32) add %al,(%rax)
(0x3573c34) add %al,(%rax)
(0x3573c36) add %al,(%rax)
(0x3573c38) add %al,(%rax)*** 2017-07-15T09:35:47.099498+08:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=0mtwvr49kxt2m) -----
SELECT DECODE(null,'','Total System Global Area','') NAME_COL_PLUS_SHOW_SGA, SUM(VALUE), DECODE (null,'', 'bytes','') units_col_plus_show_sga FROM V$SGA UNION ALL SELECT NAME NAME_COL
_PLUS_SHOW_SGA , VALUE, DECODE (null,'', 'bytes','') units_col_plus_show_sga FROM V$SGA
[TOC00004-END][TOC00005]
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+119 call kgdsdst() 7F608204B7B8 000000003
7F608202D220 ? 7F608202D338 ?
2442444300000000 000000083 ?
dbkedDefDump()+1200 call ksedst() 000000001 000000003 ?
7F608202D220 ? 7F608202D338 ?
2442444300000000 ?
000000083 ?
ksedmp()+259 call dbkedDefDump() 000000003 000000003
7F608202D220 ? 7F608202D338 ?
2442444300000000 ?
000000083 ?
ssexhd()+3188 call ksedmp() 00000044F 000000003 ?
7F608202D220 ? 7F608202D338 ?
2442444300000000 ?
000000083 ?
sslssSynchHdlr()+39 call ssexhd() 000000001 000000000
9 7F608204ED70 7F608204EC40
7F608204EB80 000000083 ?
sslsshandler()+118 call sslssSynchHdlr() 000002000 000000000 000000000
7F608204EC40 ? 7F608204EB80 ?
000000083 ?
__sighandler() call sslsshandler() 00000000B 7F608204ED70
7F608204EC40 7F608204EC40 ?
7F608204EB80 ? 000000083 ?
qergsAllocate() signal __sighandler() 7F6081CFB810 000000000
000000001 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknRwsAllocateTree( call qergsAllocate() 7F6081CFB810 ? 000000000 ?
)+206 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknRwsAllocateTree( call qknRwsAllocateTree( 7F6081CFB810 ? 000000000 ?
)+176 ) 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknRwsAllocateTree( call qknRwsAllocateTree( 7F6081CFB5D8 ? 000000000 ?
)+176 ) 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qknDoRwsAllocate()+ call qknRwsAllocateTree( 7F6081CFB248 ? 000000000 ?
32 ) 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qkaTraverseQknDesce call qknDoRwsAllocate() 7F6081CFB248 ? 000000000 ?
ndents()+714 000000001 ? 7F6082376F20 ?
0677C9400 ? 7F6081CFB810 ?
qkaTraverseQkn()+22 call qkaTraverseQknDesce 7F6081CEFA78 ? 000000000 ?
7 ndents() 000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
qkadrv2Post()+1111 call qkaTraverseQkn() 7F6081CEFA78 ? 000000000 ?
000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
qkadrv2()+418 call qkadrv2Post() 000000001 ? 000000000 ?
000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
opitca()+2511 call qkadrv2() 071FFFC18 ? 000000000 ?
000000001 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
kksLoadChild()+1132 call opitca() 7F6081CDCAC8 071FFFC18
6 7FFFD99FF9B0 000000000 ?
000000000 ? 7F6081CFB810 ?
kxsGetRuntimeLock() call kksLoadChild() 7F6082334980 071FFFC18 ?
+2029 7FFFD99FF9B0 ? 000000000 ?
000000000 ? 7F6081CFB810 ?
kksfbc()+15091 call kxsGetRuntimeLock() 7F6082334980 7F6081CDCAC8
7FFFD99FF930 000000000 ?
000000000 ? 074B8ED20
kkspsc0()+2130 call kksfbc() 7F6081CDCAC8 7F6081CDCAC8 ?
7FFFD99FF930 ? 000000000 ?
000000000 ? 074B8ED20 ?
kksParseCursor()+12 call kkspsc0() 7F6081CC2410 7FFFD9A01D00
3 00000011A 000000003 000000006
0000000A4
opiosq0()+2391 call kksParseCursor() 7FFFD9A00728 ? 7FFFD9A01D00 ?
00000011A ? 000000003 ?
000000006 ? 0000000A4 ?
kpooprx()+392 call opiosq0() 000000003 7FFFD9A01D00 ?
000000000 ? 0000000A4
000000000 000000000
:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货