|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|
|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.|
Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 22.214.171.124 - Release: 11.2 to 11.2
Information in this document applies to any platform.
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 126.96.36.199.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORACLE_HOME = /opt/oracle/product/188.8.131.52
System name: SunOS
Node name: node_test
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
This problem has been introduced with patch-set 184.108.40.206.
Unnecessary trace has been added into the 220.127.116.11.
This is Bug 9943960 (not public on My Oracle Support).
Bug has been fixed on RDBMS patchset 18.104.22.168 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
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