admin 管理员组文章数量: 887021
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服务器查找相关文件，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 :
本文标签： ttc error oracle ORA
版权声明：本文标题：ttc error oracle,ORA 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.freenas.com.cn/jishu/1731024895h1426751.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论