注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

常在心

淡泊明志,人生自在

 
 
 

日志

 
 

ORACLE 11.2.0.2 "TTX ID1: %X ID2: %X RET: %D WAITOPT: %D" MESSAGE IN TRACE FILE  

2011-12-19 11:26:31|  分类: ORACLE BUG |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Several Trace Files Generated By Database Foreground Processes Showing: "TTX id1: nnnnnn id2: nnnnn ret: n waitopt: n" [ID 1359902.1]

  修改时间 05-OCT-2011     类型 PROBLEM     状态 MODERATED  

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.


Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2
Information in this document applies to any platform.
Symptoms
You notice lots of trace files from the regular database foreground processes have been generated at the USER_DUMP_DEST directory, and the same traces are filed up with  following pattern:
Trace file /opt/oracle/admin/TEST/diag/rdbms/test/TEST/trace/TEST_ora_11143.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORACLE_HOME = /opt/oracle/product/11.2.0.2
System name: SunOS
Node name: node_test
Release: 5.10
Version: Generic_144488-01
Machine: sun4u
Instance name: TEST
Redo thread mounted by this instance: 1
Oracle process number: 81
Unix process pid: 11143, image: oracle@node_test
*** 2011-04-19 10:24:36.548
*** SESSION ID:(259.6311) 2011-04-19 10:24:36.548
*** CLIENT ID:() 2011-04-19 10:24:36.548
*** SERVICE NAME:(TEST.oracle.com) 2011-04-19 10:24:36.548
*** MODULE NAME:(test@test (TNS V1-V3)) 2011-04-19 10:24:36.548
*** ACTION NAME:() 2011-04-19 10:24:36.548
TTX id1: b0013 id2: 600a4 ret: 0 waitopt: 2
TTX id1: 60021 id2: 7ac6 ret: 0 waitopt: 2
TTX id1: b0015 id2: 60087 ret: 0 waitopt: 2
TTX id1: 5001f id2: 7a8c ret: 0 waitopt: 2
TTX id1: b000d id2: 60089 ret: 0 waitopt: 2
TTX id1: 10005 id2: 7ac9 ret: 0 waitopt: 2
TTX id1: b0011 id2: 60075 ret: 0 waitopt: 2
TTX id1: 8001c id2: 7ee3 ret: 0 waitopt: 2
...
...
...
Changes
This problem has been introduced with patch-set 11.2.0.2.
Cause
Unnecessary trace has been added into the 11.2.0.2.
This is Bug 9943960 (not public on My Oracle Support).
Solution
Bug has been fixed on RDBMS patchset 11.2.0.3 and release 12.1.
For previous versions, please check back-port availability to your RDBMS and platform versions on My Oracle Support Portal, "Patches & Updates" tab.
Still have questions ?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Streams and Distributed Database Community.
The goal of this community is to exchange knowledge and concepts about Oracle Streams Advanced Queuing (AQ) and distributed databases, with special consideration for the components listed below:
    -    Distributed Databases
    -    Streams Replication and Advanced Queuing
    -    Advanced Replication
    -    XA
If you feel that a Service Request is needed, please be sure to provide the information listed below:
1. Instance alert log file.
2. Trace file if generated
3. RDA report. Document 314422.1


To provide feedback on this note, click on the "Rate this document" link above

上面的意思就是说:目前在这个版本中还没有解决的方案,只能通过打patch到11.2.0.3方可解决

  评论这张
 
阅读(1442)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017