Trace the file/app/oracle/app/oracle/diag/RDBMS/xbook xbook/Trace/XBOOK_pmon_14051 TRC
Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options
ORACLE_HOME=/app/oracle/app/oracle/product/11.2.0/dbhome_1
Linux System name:
The 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
The Instance name: XBOOK
Redo thread mounted by this instance: 1
Oracle process number:
2Unix process pid: 14051, image: oracle @ Linux (PMON)
* * * 2021-04-01 22:21:54. 061
* * * the SESSION ID: (63.1) 2021-04-01 22:21:54. 061
* * * CLIENT ID: () the 2021-04-01 22:21:54. 061
* * * SERVICE NAME: (SYS $BACKGROUND) the 2021-04-01 22:21:54. 061
* * * the MODULE NAME: () the 2021-04-01 22:21:54. 061
* * * the ACTION NAME: () the 2021-04-01 22:21:54. 061
KGX cleanup...
KGX Atomic Operation Log 0 x973e54f0
Mutex 0 x979cb6e0 (156, 0) the idn df0b0a66 oper EXCL
Cursor Pin uid 156 efd 7 WHR 10 SLP 0
Incident 9623 created, the dump file:/app/oracle/app/oracle/diag/RDBMS/xbook/xbook/Incident/incdir_9623/XBOOK_pmon_14051_i9623 TRC
ORA - 00600: internal error code, the arguments: [17112], [0 x08e2b0f80], [], [], [], [], [], [], [], [], [], []
PMON: fatal error while deleting the s.o. 0 x9f49d530 in this tree:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SO: 0 x9f49d530, type: 2, owner: (nil), flag: INIT/-/-/0 x00 if: 0 x3 c: 0 x3
Proc=0 x9f49d530, name=process, file=ksu. H LINE: 11459, pg=0
Oracle pid (process) : 37, ser: 67, calls cur/top: 0 x9f07c8a8/0 x9f07c8a8
Flags: (0 x1) DEAD
Flags2: (0 x0), flags3: (0 x0)
Intr error: 0, call the error: 0, sess error: 0, TXN error 0
Intr queue: empty
Ksudlp FALSE at the location: 0
The last post (post info) received: 0 0 0
The last post received - location: No post
The last process to post me: none
The last post sent: 0 0 26
The last post sent - location: ksa2. H LINE: 282 ID: ksasnd
The last process posted by me: 9 f482eb0 1 6
(latch info) wait_event=0 bits=0
The Process Group: DEFAULT, pseudo proc: 0 x9f51de70
O/S info: user: oracle, term: UNKNOWN, ospid: 7006 (DEAD)
OSD pid info: Unix process pid: 7006, image: oracle @ Linux
X000000009f469668 Dump of the memory from 0 to 0 x000000009f469870
09 00000000 00000000 f469660 [...]
09 f469670 00000000 00000000 00000000 00000000 [...]
Repeat 31 times
(FOB) flags=2050 fib=0 x9e726e40 incno=0 pending I/o CNT=0
Fname=/app/oracle/app/oracle/oradata/XBOOK/XIR_MD_IDX. DBF
11 LBLKSZ fno==8192 fsiz=143872
(FOB) flags=2050 fib=0 x9e726828 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=0 x9e7231c8 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=0 x9e723de0 incno=0 pending I/o CNT=0
Fname=/app/oracle/app/oracle/oradata/XBOOK/undotbs01. DBF
Fno LBLKSZ=3=8192 fsiz=1520000
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SO: 0 x9f748668, type: 4, the owner: 0 x9f49d530, flag: INIT/-/-/0 x00 if: 0 x3 c: 0 x3
Proc=0 x9f49d530, name=session, file=ksu. H LINE: 11467, pg=0
(session) sid: 156 ser: 205 trans: (nil), the creator: 0 x9f49d530
Flags: (0 x45) USR/- flags_idl: (0 x1) BSY/-/-/-/-/-
Flags2: (0 x40008) -/-
DID: short - term DID:
TXN branch: (nil)
PRV oct: 0:0, SQL: (nil), PSQL: 0 x8e56ba90, user: 97/XIR_TRD_FC
Ksuxds FALSE at the location: 0
The service name: XBOOK
The client details:
O/S info: user: Administrator, term: WINDOWS, ospid: 3132-9500
Machine: a WORKGROUP \ WINDOWS program: HTTPD. Exe
The application name: HTTPD. Exe, hash value=https://bbs.csdn.net/topics/2794960912
The Current Wait Stack:
Not in wait; The last wait ended 2.708060 SEC line
Wait State:
Fixed_waits=0 flags=0 x21 boundary=(nil)/- 1
The Session Wait History:
Elapsed time of 2.708079 SEC since last wait
0: waited for 'SQL * Net message from client'
Driver id=0 x54435000, # bytes=0 x1=0 x0
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=0 x54435000, # bytes=0 x1=0 x0
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=0 x54435000, # bytes=0 x1=0 x0
Wait_id=53153 seq_num=53154 snap_id=1
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull