{"id":247,"date":"2017-01-18T10:32:22","date_gmt":"2017-01-18T02:32:22","guid":{"rendered":"http:\/\/www.lisq.net.cn\/?p=247"},"modified":"2017-02-03T16:48:18","modified_gmt":"2017-02-03T08:48:18","slug":"11-2-0-1-trace-%e5%be%88%e5%a4%9a%e8%a7%a6%e5%8f%91%e5%99%a8trace","status":"publish","type":"post","link":"https:\/\/www.lisq.net\/?p=247","title":{"rendered":"11.2.0.1 trace \u5f88\u591a\u89e6\u53d1\u5668trace"},"content":{"rendered":"

[oracle@TEST11 trace]$ vim TEST1_ora_10283.trc
\nTrace file \/u01\/app\/oracle\/diag\/rdbms\/TEST1\/TEST1\/trace\/TEST1_ora_10283.trc
\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
\nData Mining and Real Application Testing options
\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2\/db
\nSystem name: Linux
\nNode name: TEST11
\nRelease: 2.6.18-348.el5
\nVersion: #1 SMP Tue Jan 8 17:53:53 EST 2013
\nMachine: x86_64
\nInstance name: TEST1
\nRedo thread mounted by this instance: 1
\nOracle process number: 32
\nUnix process pid: 10283, image: oracle@TEST11
\n*** 2017-01-18 09:49:34.696
\n*** SESSION ID:(39.7228) 2017-01-18 09:49:34.696
\n*** CLIENT ID:() 2017-01-18 09:49:34.696
\n*** SERVICE NAME:(TEST1) 2017-01-18 09:49:34.696
\n*** MODULE NAME:(JDBC Thin Client) 2017-01-18 09:49:34.696
\n*** ACTION NAME:() 2017-01-18 09:49:34.696<\/p>\n

——–Dumping Sorted Master Trigger List ——–<\/p>\n

MOS\u6587\u6863\u5b9a\u4e49\u4e3aBUG\u00a0Traces Generated With The Message ‘Dumping Sorted Master Trigger List’ (\u6587\u6863 ID 1098363.1)<\/p>\n

APPLIES TO:<\/h2>\n

Oracle Database – Enterprise Edition – Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
\nInformation in this document applies to any platform.
\n***Checked for relevance on 18-Jul-2012***<\/p>\n

<\/a>SYMPTOMS<\/h2>\n

You are seeing trace files with the following message:<\/p>\n

——–Dumping Sorted Master Trigger List ——–
\nTrigger Owner : OWN
\nTrigger Name : TRG_XXX
\n——–Dumping Trigger Sublists ——–
\ntrigger sublist 0 :
\ntrigger sublist 1 :
\ntrigger sublist 2 :
\ntrigger sublist 3 :
\nTrigger Owner : OWN
\nTrigger Name : TRG_XXX
\ntrigger sublist 4 : dumping from triggers is fixed
\n…<\/div>\n

<\/a>CAUSE<\/h2>\n

Bug 9382101<\/a> A LOT OF TRACE FILES KEEP GENERATED,CONTAIN DUMPS FOR SORTED MASTER TRIGGER<\/p>\n

<\/a>SOLUTION<\/h2>\n

1. Apply Patch 9382101<\/a> if available for your DB version and OS platform.<\/p>\n

– OR –<\/p>\n

2. Upgrade to patch set 11.2.0.2<\/p>\n

P.S: For windows Apply 11.2.0.1.0 Patch 4 (11.2.0.1.4P) or higher
\nFor 32-Bit, apply\u00a0Patch:9888297, For 64-Bit (x64), apply\u00a0Patch:9888298<\/p>\n","protected":false},"excerpt":{"rendered":"

[oracle@TEST11 trace]$ vim TES …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[8],"tags":[12],"class_list":["post-247","post","type-post","status-publish","format-standard","hentry","category-8","tag-bug"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-3Z","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=247"}],"version-history":[{"count":1,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions"}],"predecessor-version":[{"id":248,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions\/248"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}