PMON: fatal error while deleting s.o. 0x9f49d530

[weixin_38705522]

Trace file /app/oracle/app/oracle/diag/rdbms/xbook/XBOOK/trace/XBOOK_pmon_14051.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: linux
Release: 3.10.0-1062.12.1.el7.x86_64
Version: #1 SMP Tue Feb 4 23:02:59 UTC 2020
Machine: x86_64
Instance name: XBOOK
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 14051, image: oracle@linux (PMON)


*** 2021-04-01 22:21:54.061
*** SESSION ID:(63.1) 2021-04-01 22:21:54.061
*** CLIENT ID:() 2021-04-01 22:21:54.061
*** SERVICE NAME:(SYS$BACKGROUND) 2021-04-01 22:21:54.061
*** MODULE NAME:() 2021-04-01 22:21:54.061
*** ACTION NAME:() 2021-04-01 22:21:54.061

KGX cleanup...
KGX Atomic Operation Log 0x973e54f0
Mutex 0x979cb6e0(156, 0) idn df0b0a66 oper EXCL
Cursor Pin uid 156 efd 7 whr 10 slp 0
Incident 9623 created, dump file: /app/oracle/app/oracle/diag/rdbms/xbook/XBOOK/incident/incdir_9623/XBOOK_pmon_14051_i9623.trc
ORA-00600: internal error code, arguments: [17112], [0x08E2B0F80], [], [], [], [], [], [], [], [], [], []

PMON: fatal error while deleting s.o. 0x9f49d530 in this tree:
----------------------------------------
SO: 0x9f49d530, type: 2, owner: (nil), flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x9f49d530, name=process, file=ksu.h LINE:11459, pg=0
(process) Oracle pid:37, ser:67, calls cur/top: 0x9f07c8a8/0x9f07c8a8
flags : (0x1) DEAD
flags2: (0x0), flags3: (0x0)
intr error: 0, call error: 0, sess error: 0, txn error 0
intr queue: empty
ksudlp FALSE at location: 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 26
last post sent-location: ksa2.h LINE:282 ID:ksasnd
last process posted by me: 9f482eb0 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 0x9f51de70
O/S info: user: oracle, term: UNKNOWN, ospid: 7006 (DEAD)
OSD pid info: Unix process pid: 7006, image: oracle@linux
Dump of memory from 0x000000009F469668 to 0x000000009F469870
09F469660 00000000 00000000 [........]
09F469670 00000000 00000000 00000000 00000000 [................]
Repeat 31 times
(FOB) flags=2050 fib=0x9e726e40 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/XIR_MD_IDX.DBF
fno=11 lblksz=8192 fsiz=143872
(FOB) flags=2050 fib=0x9e726828 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/XIR_MD_DAT.DBF
fno=10 lblksz=8192 fsiz=924672
(FOB) flags=2050 fib=0x9e7231c8 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/system01.dbf
fno=1 lblksz=8192 fsiz=101120
(FOB) flags=2050 fib=0x9e723de0 incno=0 pending i/o cnt=0
fname=/app/oracle/app/oracle/oradata/XBOOK/undotbs01.dbf
fno=3 lblksz=8192 fsiz=1520000
----------------------------------------
SO: 0x9f748668, type: 4, owner: 0x9f49d530, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x9f49d530, name=session, file=ksu.h LINE:11467, pg=0
(session) sid: 156 ser: 205 trans: (nil), creator: 0x9f49d530
flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40008) -/-
DID: , short-term DID:
txn branch: (nil)
oct: 0, prv: 0, sql: (nil), psql: 0x8e56ba90, user: 97/XIR_TRD_FC
ksuxds FALSE at location: 0
service name: XBOOK
client details:
O/S info: user: Administrator, term: WINDOWS, ospid: 3132:9500
machine: WORKGROUP\WINDOWS program: httpd.exe
application name: httpd.exe, hash value=2794960912
Current Wait Stack:
Not in wait; last wait ended 2.708060 sec ago
Wait State:
fixed_waits=0 flags=0x21 boundary=(nil)/-1
Session Wait History:
elapsed time of 2.708079 sec since last wait
0: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53155 seq_num=53156 snap_id=1
wait times: snap=0.006616 sec, exc=0.006616 sec, total=0.006616 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000025 sec of elapsed time
1: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53154 seq_num=53155 snap_id=1
wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000046 sec of elapsed time
2: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53153 seq_num=53154 snap_id=1
wait times: snap=0.000742 sec, exc=0.000742 sec, total=0.000742 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000003 sec of elapsed time
3: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53152 seq_num=53153 snap_id=1
wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000044 sec of elapsed time
4: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53151 seq_num=53152 snap_id=1
wait times: snap=0.000896 sec, exc=0.000896 sec, total=0.000896 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000017 sec of elapsed time
5: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53150 seq_num=53151 snap_id=1
wait times: snap=0.000002 sec, exc=0.000002 sec, total=0.000002 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.001243 sec of elapsed time
6: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53149 seq_num=53150 snap_id=1
wait times: snap=0.002193 sec, exc=0.002193 sec, total=0.002193 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000002 sec of elapsed time
7: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53148 seq_num=53149 snap_id=1
wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000017 sec of elapsed time
8: waited for 'SQL*Net message from client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53147 seq_num=53148 snap_id=1
wait times: snap=0.000733 sec, exc=0.000733 sec, total=0.000733 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000003 sec of elapsed time
9: waited for 'SQL*Net message to client'
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=53146 seq_num=53147 snap_id=1
wait times: snap=0.000000 sec, exc=0.000000 sec, total=0.000000 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000037 sec of elapsed time
Sampled Session History of session 156 serial 205
---------------------------------------------------
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).

The history is displayed in reverse chronological order.

sample interval: 1 sec, max history 120 sec
---------------------------------------------------
[3 samples, 22:21:52 - 22:21:54]
not in wait at each sample
[10 samples, 22:21:42 - 22:21:51]
idle wait at each sample
[1 sample, 22:21:41]
not in wait at each sample
[21 samples, 22:21:20 - 22:21:40]
idle wait at each sample
[1 sample, 22:21:19]
not in wait at each sample
[4 samples, 22:21:15 - 22:21:18]
idle wait at each sample
[1 sample, 22:21:14]
not in wait at each sample
[7 samples, 22:21:07 - 22:21:13]
idle wait at each sample
[2 samples, 22:21:05 - 22:21:06]
not in wait at each sample
[71 samples, 22:19:54 - 22:21:04]
idle wait at each sample
temporary object counter: 0
----------------------------------------
Virtual Thread:
kgskvt: 0x9ee1ff60, sess: 0x9f748668, vc: (nil), proc: 0x9f49d530, id: 156
consumer group cur: OTHER_GROUPS (upd? 0), mapped: DEFAULT_CONSUMER_GROUP, orig:
vt_state: 0x4, vt_flags: 0xA030, blkrun: 0, numa: 1
inwait: 0
location where insched last set: kgskewt
location where insched last cleared: kgskewt3
location where inwait last set: kgskbwt
location where inwait last cleared: kgskewtint2
is_assigned: 1, in_sched: 0 (0)
vt_active: 0 (pending: 0)
used quanta: 8331600 (cg: 8331600) usec
cpu start time: 4091949354
idle time: 0, active time: 2245 (cg: 2245)
cpu yields: 0 (cg: 0), waits: 0 (cg: 0), wait time: 0

[好记忆不如烂笔头abc]

检查下内存问题： ORA-600 [17112] "Internal Heap Error" [ID 47411.1] Modified 24-NOV-2010 Type REFERENCE Status PUBLISHED Note: For additional ORA-600 related information please read Note:146580.1 PURPOSE: This article discusses the internal error "ORA-600 [17112]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [17112] [a] VERSIONS: versions 7.0 to 10.1 DESCRIPTION: Oracle has detected that the magic number in a memory chunk header has been overwritten. This is a heap (in memory) corruption and there is no underlying data corruption. The error may occur in the one of the process specific heaps (the Call heap, PGA heap, or session heap) or in the shared heap (SGA). ARGUMENTS: Arg [a] Pointer to chunk header FUNCTIONALITY: HEAP MANAGEMENT IMPACT: PROCESS FAILURE MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE. NON DATA CORRUPTIVE - No underlying data corruption. SUGGESTIONS: This is likely to be an effect rather than the cause of the problem. May be due to an Operating System (OS) memory overwrite. Run diagnostics to check the physical memory on the machine and check the OS system logs. For repeatable occurrences, please submit the trace files and alert.log to Oracle Support Services for further analysis.