本帖最後由 87728854 于 2014-8-25 13:49 編輯
昨天通過OEM檢查oracle，發現如下兩條告警資訊：
2014-08-25_132828.png (10.62 KB, 下載下傳次數: 0)
2014-8-25 13:31 上傳
分别點選相關條目後顯示下圖：
2014-08-25_132851.png (42.09 KB, 下載下傳次數: 2)
2014-8-25 13:33 上傳
2014-08-25_132920.png (41.94 KB, 下載下傳次數: 0)
2014-8-25 13:33 上傳
根據圖中顯示資訊，連接配接oracle伺服器查找相關檔案，log.xml中相關記錄如下：
msg_id='2264250469' type='INCIDENT_ERROR' level='1'
host_id='ERP-DB' host_addr='fe80::820:2840:3f53:9014%13' prob_key='ORA 3137 [12333]'
upstream_comp='' downstream_comp='' ecid=''
errid='89297' detail_path='d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4140.trc'>
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4140.trc (incident=89297):
ORA-03137: TTC 協定内部錯誤: [12333] [0] [0] [34] [] [] [] []
-------------------------------------------------------------------------------------------------------------------
msg_id='2264250469' type='INCIDENT_ERROR' level='1'
host_id='ERP-DB' host_addr='fe80::820:2840:3f53:9014%13' prob_key='ORA 3137 [12333]'
upstream_comp='' downstream_comp='' ecid=''
errid='89121' detail_path='d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8408.trc'>
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8408.trc (incident=89121):
ORA-03137: TTC 協定内部錯誤: [12333] [0] [0] [34] [] [] [] []
orcl_ora_4140.trc檔案内容如下：
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4140.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
Windows NT Version V6.1
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total)： Ph:17094M/32755M, Ph+PgF:49479M/65508M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 35
Windows thread id: 4140, image: ORACLE.EXE (SHAD)
*** 2014-07-14 12:09:35.718
*** SESSION ID：(617.3828) 2014-07-14 12:09:35.718
*** CLIENT ID：() 2014-07-14 12:09:35.718
*** SERVICE NAME：(orcl) 2014-07-14 12:09:35.718
*** MODULE NAME：(w3wp.exe) 2014-07-14 12:09:35.718
*** ACTION NAME：() 2014-07-14 12:09:35.718
--------Dumping Sorted Master Trigger List --------
Trigger Owner : TELSALE
Trigger Name : TRI_SX_PRODUCT_DATAVALID
--------Dumping Trigger Sublists --------
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : TELSALE
Trigger Name : TRI_SX_PRODUCT_DATAVALID
trigger sublist 4 :
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4140.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
Windows NT Version V6.1
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total)： Ph:17015M/32755M, Ph+PgF:49413M/65508M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 41
Windows thread id: 4140, image: ORACLE.EXE (SHAD)
*** 2014-07-26 13:30:45.853
*** SESSION ID：(250.9652) 2014-07-26 13:30:45.853
*** CLIENT ID：() 2014-07-26 13:30:45.853
*** SERVICE NAME：(orcl) 2014-07-26 13:30:45.853
*** MODULE NAME：([email protected] (TNS V1-V3)) 2014-07-26 13:30:45.853
*** ACTION NAME：() 2014-07-26 13:30:45.853
--------Dumping Sorted Master Trigger List --------
Trigger Owner : TELSALE
Trigger Name : TRIG_STOCK_CACHE
--------Dumping Trigger Sublists --------
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : TELSALE
Trigger Name : TRIG_STOCK_CACHE
trigger sublist 4 :
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4140.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
Windows NT Version V6.1
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total)： Ph:15808M/32755M, Ph+PgF:48238M/65508M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 62
Windows thread id: 4140, image: ORACLE.EXE (SHAD)
*** 2014-08-18 18:48:56.380
*** SESSION ID：(410.50727) 2014-08-18 18:48:56.380
*** CLIENT ID：() 2014-08-18 18:48:56.380
*** SERVICE NAME：(orcl) 2014-08-18 18:48:56.380
*** MODULE NAME：() 2014-08-18 18:48:56.380
*** ACTION NAME：() 2014-08-18 18:48:56.380
ttcdrvdmplocation: msg-0 ln-1004 reporting 12333
Dumping 'Buffer dump info:' addr=0x000000002D8BCE88 size=3 bytes
Dump of memory from 0x000000002D8BCE88 to 0x000000002D8BCE8C
02D8BCE80 84220000 [..".]
Dumping 'Buffer dump info:' addr=0x000000002D8BCE8B size=5 bytes
Dump of memory from 0x000000002D8BCE88 to 0x000000002D8BCE90
02D8BCE80 84220000 80220000 [.."...".]
hstflg: 0x40202d91
hstcflg: 0x00000000
hstpro: 6
hstccs: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.6)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=WANGD-040D3B624)(USER=NETWORK?SERVICE))))
--- dump of hsttti ---
0495E6100 00 01 01 0C 0E 09 0B 0F 01 0A 03 03 01 00 00 0A [................]
0495E6110 00 00 00 00 00 00 00 01 01 01 01 01 01 01 01 01 [................]
0495E6120 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00 [................]
0495E6130 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00 [................]
0495E6140 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00 [................]
0495E6150 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11 [................]
0495E6160 04 09 00 00 00 00 05 00 22 00 12 00 13 13 15 15 [........".......]
0495E6170 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00 [....!...........]
0495E6180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6190 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00 [............ ...]
0495E61A0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00 [................]
0495E61B0 00 00 01 01 01 01 01 01 2A 2A 2A 2A 2A 2B 2B 00 [........*****++.]
0495E61C0 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00 [...###..........]
0495E61D0 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ["...............]
0495E61E0 00 00 00 00 00 00 00 35 2A 00 00 00 00 00 00 00 [.......5*.......]
0495E61F0 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 36 [...............6]
0495E6200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6220 00 00 03 01 03 01 01 00 00 00 03 03 03 01 03 03 [................]
0495E6230 03 03 02 01 03 03 03 03 03 03 00 03 03 03 03 01 [................]
0495E6240 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03 [................]
0495E6250 03 03 01 03 03 03 03 01 00 03 01 00 03 01 00 00 [................]
0495E6260 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00 [................]
0495E6270 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03 [................]
0495E6280 03 03 03 03 03 03 03 01 00 03 03 01 01 03 03 03 [................]
0495E6290 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03 [................]
0495E62A0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03 [................]
0495E62B0 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E62C0 00 03 03 00 00 00 03 03 03 03 03 03 03 03 03 03 [................]
0495E62D0 00 00 03 03 00 00 03 03 03 03 03 03 03 03 03 03 [................]
0495E62E0 03 03 03 03 03 03 03 00 00 00 00 00 00 00 00 00 [................]
0495E62F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6310 00 00 00 00 1A 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6330 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6340 00 00 00 00 00 00 00 00 00 00 [..........]
ttclxlccst: 852
ttclxrccst: 852
ttclxlncst: 2000
ttclxrncst: 2000
ttclxccl2nr: 1
ttclxccn2lr: 1
ttclxncl2nr: 1
ttclxncn2lr: 1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 2
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags: 0x21
prev funcode: 0x5e
*** 2014-08-18 18:48:56.707
Incident 89297 created, dump file: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_89297\orcl_ora_4140_i89297.trc
ORA-03137: TTC 協定内部錯誤: [12333] [0] [0] [34] [] [] [] []
ttcdrvdmplocation: msg-0 ln-252 reporting 3137
Dumping 'Buffer dump info:' addr=0x000000002D8BCE88 size=3 bytes
Dump of memory from 0x000000002D8BCE88 to 0x000000002D8BCE8C
02D8BCE80 84220000 [..".]
Dumping 'Buffer dump info:' addr=0x000000002D8BCE8B size=5 bytes
Dump of memory from 0x000000002D8BCE88 to 0x000000002D8BCE90
02D8BCE80 84220000 80220000 [.."...".]
hstflg: 0x40202d91
hstcflg: 0x00000000
hstpro: 6
hstccs: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.6)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=WANGD-040D3B624)(USER=NETWORK?SERVICE))))
--- dump of hsttti ---
0495E6100 00 01 01 0C 0E 09 0B 0F 01 0A 03 03 01 00 00 0A [................]
0495E6110 00 00 00 00 00 00 00 01 01 01 01 01 01 01 01 01 [................]
0495E6120 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00 [................]
0495E6130 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00 [................]
0495E6140 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00 [................]
0495E6150 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11 [................]
0495E6160 04 09 00 00 00 00 05 00 22 00 12 00 13 13 15 15 [........".......]
0495E6170 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00 [....!...........]
0495E6180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6190 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00 [............ ...]
0495E61A0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00 [................]
0495E61B0 00 00 01 01 01 01 01 01 2A 2A 2A 2A 2A 2B 2B 00 [........*****++.]
0495E61C0 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00 [...###..........]
0495E61D0 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ["...............]
0495E61E0 00 00 00 00 00 00 00 35 2A 00 00 00 00 00 00 00 [.......5*.......]
0495E61F0 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 36 [...............6]
0495E6200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6220 00 00 03 01 03 01 01 00 00 00 03 03 03 01 03 03 [................]
0495E6230 03 03 02 01 03 03 03 03 03 03 00 03 03 03 03 01 [................]
0495E6240 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03 [................]
0495E6250 03 03 01 03 03 03 03 01 00 03 01 00 03 01 00 00 [................]
0495E6260 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00 [................]
0495E6270 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03 [................]
0495E6280 03 03 03 03 03 03 03 01 00 03 03 01 01 03 03 03 [................]
0495E6290 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03 [................]
0495E62A0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03 [................]
0495E62B0 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E62C0 00 03 03 00 00 00 03 03 03 03 03 03 03 03 03 03 [................]
0495E62D0 00 00 03 03 00 00 03 03 03 03 03 03 03 03 03 03 [................]
0495E62E0 03 03 03 03 03 03 03 00 00 00 00 00 00 00 00 00 [................]
0495E62F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6310 00 00 00 00 1A 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6330 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
0495E6340 00 00 00 00 00 00 00 00 00 00 [..........]
ttclxlccst: 852
ttclxrccst: 852
ttclxlncst: 2000
ttclxrncst: 2000
ttclxccl2nr: 1
ttclxccn2lr: 1
ttclxncl2nr: 1
ttclxncn2lr: 1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 2
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags: 0x21
orcl_ora_8408.trc檔案内容如下：
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8408.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
Windows NT Version V6.1
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total)： Ph:15818M/32755M, Ph+PgF:48266M/65508M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 40
Windows thread id: 8408, image: ORACLE.EXE (SHAD)
*** 2014-08-18 19:19:20.288
*** SESSION ID：(50.54264) 2014-08-18 19:19:20.288
*** CLIENT ID：() 2014-08-18 19:19:20.288
*** SERVICE NAME：(orcl) 2014-08-18 19:19:20.288
*** MODULE NAME：() 2014-08-18 19:19:20.288
*** ACTION NAME：() 2014-08-18 19:19:20.288
ttcdrvdmplocation: msg-0 ln-1004 reporting 12333
Dumping 'Buffer dump info:' addr=0x0000000023F3CE88 size=3 bytes
Dump of memory from 0x0000000023F3CE88 to 0x0000000023F3CE8C
023F3CE80 84220000 [..".]
Dumping 'Buffer dump info:' addr=0x0000000023F3CE8B size=5 bytes
Dump of memory from 0x0000000023F3CE88 to 0x0000000023F3CE90
023F3CE80 84220000 80220000 [.."...".]
hstflg: 0x40202d91
hstcflg: 0x00000000
hstpro: 6
hstccs: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.6)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=WANGD-040D3B624)(USER=NETWORK?SERVICE))))
--- dump of hsttti ---
02BCCD010 00 01 01 0C 0E 09 0B 0F 01 0A 03 03 01 00 00 0A [................]
02BCCD020 00 00 00 00 00 00 00 01 01 01 01 01 01 01 01 01 [................]
02BCCD030 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00 [................]
02BCCD040 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00 [................]
02BCCD050 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00 [................]
02BCCD060 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11 [................]
02BCCD070 04 09 00 00 00 00 05 00 22 00 12 00 13 13 15 15 [........".......]
02BCCD080 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00 [....!...........]
02BCCD090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD0A0 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00 [............ ...]
02BCCD0B0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00 [................]
02BCCD0C0 00 00 01 01 01 01 01 01 2A 2A 2A 2A 2A 2B 2B 00 [........*****++.]
02BCCD0D0 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00 [...###..........]
02BCCD0E0 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ["...............]
02BCCD0F0 00 00 00 00 00 00 00 35 2A 00 00 00 00 00 00 00 [.......5*.......]
02BCCD100 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 36 [...............6]
02BCCD110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD130 00 00 03 01 03 01 01 00 00 00 03 03 03 01 03 03 [................]
02BCCD140 03 03 02 01 03 03 03 03 03 03 00 03 03 03 03 01 [................]
02BCCD150 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03 [................]
02BCCD160 03 03 01 03 03 03 03 01 00 03 01 00 03 01 00 00 [................]
02BCCD170 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00 [................]
02BCCD180 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03 [................]
02BCCD190 03 03 03 03 03 03 03 01 00 03 03 01 01 03 03 03 [................]
02BCCD1A0 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03 [................]
02BCCD1B0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03 [................]
02BCCD1C0 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD1D0 00 03 03 00 00 00 03 03 03 03 03 03 03 03 03 03 [................]
02BCCD1E0 00 00 03 03 00 00 03 03 03 03 03 03 03 03 03 03 [................]
02BCCD1F0 03 03 03 03 03 03 03 00 00 00 00 00 00 00 00 00 [................]
02BCCD200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD220 00 00 00 00 1A 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD230 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD250 00 00 00 00 00 00 00 00 00 00 [..........]
ttclxlccst: 852
ttclxrccst: 852
ttclxlncst: 2000
ttclxrncst: 2000
ttclxccl2nr: 1
ttclxccn2lr: 1
ttclxncl2nr: 1
ttclxncn2lr: 1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 2
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags: 0x21
prev funcode: 0x5e
DDE: Problem Key 'ORA 3137 [12333]' was flood controlled (0x2) (incident: 89121)
ORA-03137: TTC 協定内部錯誤: [12333] [0] [0] [34] [] [] [] []
ttcdrvdmplocation: msg-0 ln-252 reporting 3137
Dumping 'Buffer dump info:' addr=0x0000000023F3CE88 size=3 bytes
Dump of memory from 0x0000000023F3CE88 to 0x0000000023F3CE8C
023F3CE80 84220000 [..".]
Dumping 'Buffer dump info:' addr=0x0000000023F3CE8B size=5 bytes
Dump of memory from 0x0000000023F3CE88 to 0x0000000023F3CE90
023F3CE80 84220000 80220000 [.."...".]
hstflg: 0x40202d91
hstcflg: 0x00000000
hstpro: 6
hstccs: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.6)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=WANGD-040D3B624)(USER=NETWORK?SERVICE))))
--- dump of hsttti ---
02BCCD010 00 01 01 0C 0E 09 0B 0F 01 0A 03 03 01 00 00 0A [................]
02BCCD020 00 00 00 00 00 00 00 01 01 01 01 01 01 01 01 01 [................]
02BCCD030 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00 [................]
02BCCD040 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00 [................]
02BCCD050 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00 [................]
02BCCD060 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11 [................]
02BCCD070 04 09 00 00 00 00 05 00 22 00 12 00 13 13 15 15 [........".......]
02BCCD080 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00 [....!...........]
02BCCD090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD0A0 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00 [............ ...]
02BCCD0B0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00 [................]
02BCCD0C0 00 00 01 01 01 01 01 01 2A 2A 2A 2A 2A 2B 2B 00 [........*****++.]
02BCCD0D0 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00 [...###..........]
02BCCD0E0 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ["...............]
02BCCD0F0 00 00 00 00 00 00 00 35 2A 00 00 00 00 00 00 00 [.......5*.......]
02BCCD100 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 36 [...............6]
02BCCD110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD130 00 00 03 01 03 01 01 00 00 00 03 03 03 01 03 03 [................]
02BCCD140 03 03 02 01 03 03 03 03 03 03 00 03 03 03 03 01 [................]
02BCCD150 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03 [................]
02BCCD160 03 03 01 03 03 03 03 01 00 03 01 00 03 01 00 00 [................]
02BCCD170 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00 [................]
02BCCD180 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03 [................]
02BCCD190 03 03 03 03 03 03 03 01 00 03 03 01 01 03 03 03 [................]
02BCCD1A0 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03 [................]
02BCCD1B0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03 [................]
02BCCD1C0 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD1D0 00 03 03 00 00 00 03 03 03 03 03 03 03 03 03 03 [................]
02BCCD1E0 00 00 03 03 00 00 03 03 03 03 03 03 03 03 03 03 [................]
02BCCD1F0 03 03 03 03 03 03 03 00 00 00 00 00 00 00 00 00 [................]
02BCCD200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD220 00 00 00 00 1A 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD230 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
02BCCD250 00 00 00 00 00 00 00 00 00 00 [..........]
ttclxlccst: 852
ttclxrccst: 852
ttclxlncst: 2000
ttclxrncst: 2000
ttclxccl2nr: 1
ttclxccn2lr: 1
ttclxncl2nr: 1
ttclxncn2lr: 1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 2
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags: 0x21
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8408.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
Windows NT Version V6.1
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total)： Ph:15554M/32755M, Ph+PgF:48007M/65508M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 39
Windows thread id: 8408, image: ORACLE.EXE (SHAD)
*** 2014-08-24 15:55:41.865
*** SESSION ID：(609.36851) 2014-08-24 15:55:41.865
*** CLIENT ID：() 2014-08-24 15:55:41.865
*** SERVICE NAME：(orcl) 2014-08-24 15:55:41.865
*** MODULE NAME：([email protected] (TNS V1-V3)) 2014-08-24 15:55:41.865
*** ACTION NAME：() 2014-08-24 15:55:41.865
--------Dumping Sorted Master Trigger List --------
Trigger Owner : TELSALE
Trigger Name : TRIG_STOCK_CACHE
--------Dumping Trigger Sublists --------
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
Trigger Owner : TELSALE
Trigger Name : TRIG_STOCK_CACHE
trigger sublist 4 :
資料庫和作業系統版本如下：
2014-08-25_133814.png (9.58 KB, 下載下傳次數: 0)
2014-8-25 13:39 上傳
2014-08-25_134050.png (18.6 KB, 下載下傳次數: 2)
2014-8-25 13:42 上傳
應用基于微軟.net開發
請幫忙分析下是什麼原因導緻的，具體該如何解決，謝謝！