ttc error oracle,ORA

ttc error oracle,ORA

本帖最后由 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服务器查找相关文件，l中相关记录如下：

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:appadministratordiagrdbmsorclorcltraceorcl_'>

Errors in file d:appadministratordiagrdbmsorclorcltraceorcl_  (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:appadministratordiagrdbmsorclorcltraceorcl_'>

Errors in file d:appadministratordiagrdbmsorclorcltraceorcl_  (incident=89121):

ORA-03137: TTC 协议内部错误: [12333] [0] [0] [34] [] [] [] []

orcl_文件内容如下：

Trace file d:appadministratordiagrdbmsorclorcltraceorcl_

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：() 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:appadministratordiagrdbmsorclorcltraceorcl_

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:appadministratordiagrdbmsorclorcltraceorcl_

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                 :