ttc error oracle,ORA-03137: TTC 协议内部错误

本帖最后由 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：(python@crm (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：(python@crm (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开发

请帮忙分析下是什么原因导致的，具体该如何解决，谢谢！