{"id":481,"date":"2008-12-10T18:25:18","date_gmt":"2008-12-10T16:25:18","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=481"},"modified":"2008-12-11T11:34:53","modified_gmt":"2008-12-11T09:34:53","slug":"troublshooting-trace-files-of-diag-background-process","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2008\/12\/10\/troublshooting-trace-files-of-diag-background-process\/","title":{"rendered":"Troublshooting Trace Files of DIAG Background Process"},"content":{"rendered":"<p>In trace files of the background process DIAG, I saw an interesting section that I would like to share.<\/p>\n<blockquote><p><code><br \/>\n*** 2008-12-09 03:46:33.280<br \/>\nDump requested by process [orapid=6]<br \/>\nREQUEST:custom dump [2] with parameters [6][27][4][2]<br \/>\nDumping process info of pid[27.31384] requested by pid[6.31160]<br \/>\nORA-00494: Message 494 not found; No message file for product=RDBMS, facility=ORA; arguments: [ [CF]] [ (more than 900 seconds)] [inst<br \/>\n2, osid 31384]<br \/>\n-------------------------------------------------------------------------------<br \/>\nENQUEUE [CF] HELD FOR TOO LONG<br \/>\nenqueue holder: 'inst 2, osid 31384'<br \/>\nProcess 'inst 2, osid 31384' is holding an enqueue for maximum allowed time.<br \/>\nThe process will be terminated.<br \/>\nOracle Support Services triaging information: to find the root-cause, look<br \/>\nat the call stack of process 'inst 2, osid 31384' located below. Ask the<br \/>\ndeveloper that owns the first NON-service layer in the stack to investigate.<br \/>\nCommon service layers are enqueues (ksq), latches (ksl), library cache<br \/>\npins and locks (kgl), and row cache locks (kqr).<br \/>\n<\/code><\/p><\/blockquote>\n<p>It is very nice of diag to tell me what to do with the output. \ud83d\ude09  Especially:<\/p>\n<blockquote><p>Ask the developer that owns the first NON-service layer in the stack to investigate.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>In trace files of the background process DIAG, I saw an interesting section that I would like to share. *** 2008-12-09 03:46:33.280 Dump requested by process [orapid=6] REQUEST:custom dump [2] with parameters [6][27][4][2] Dumping process info of pid[27.31384] requested by pid[6.31160] ORA-00494: Message 494 not found; No message file for product=RDBMS, facility=ORA; arguments: [ [CF]] [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,14,15,19,5,35],"tags":[],"class_list":["post-481","post","type-post","status-publish","format-standard","hentry","category-10g","category-11g","category-9ir2","category-metalink","category-oracle-database","category-real-application-clusters-oracle-database-2"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=481"}],"version-history":[{"count":5,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/481\/revisions"}],"predecessor-version":[{"id":495,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/481\/revisions\/495"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}