{"id":851,"date":"2023-09-07T09:32:35","date_gmt":"2023-09-07T07:32:35","guid":{"rendered":"https:\/\/anjo.pt\/?p=851"},"modified":"2025-04-15T11:17:14","modified_gmt":"2025-04-15T09:17:14","slug":"my-ardci-cheatsheet","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2023\/09\/07\/my-ardci-cheatsheet\/","title":{"rendered":"My ADRCI cheatsheet"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Check last problems<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nadrci&gt; show problem -last 10\nadrci&gt; show incident -last 10\nadrci&gt; show incident -p &quot;CREATE_TIME &gt; systimestamp - 5&quot;\n\nadrci&gt; show incident -p &quot;incident_id=180781&quot; -mode detail\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Create Package<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nadrci&gt; ips create package problem 5\nadrci&gt; ips generate package 1 in &quot;\/tmp&quot;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Purge<\/h2>\n\n\n\n<p>Value for control is hours<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nadrci&gt; show control\nadrci&gt; set control (SHORTP_POLICY = 720)   \/* 30 days *\/\nadrci&gt; set control (LONGP_POLICY= 8760)   \/* 1 year *\/\n<\/pre><\/div>\n\n\n<p>Value for purge is minutes<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nadrci&gt; purge -age 1440  \/* 1 day *\/\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Fix &#8220;No ADR base is set&#8221;<\/h2>\n\n\n\n<p>Sometimes also &#8220;DIA-48494: ADR home is not set&#8221;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; select value from v$diag_info where name=&#039;ADR Base&#039;;\nVALUE\n------------------\n\/u01\/app\/oracle\n<\/pre><\/div>\n\n\n<p>Create a <code>${ORACLE_HOME}\/log\/diag\/adrci_dir.mif<\/code> file with:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ mkdir -p ${ORACLE_HOME}\/log\/diag\/\n$ printf &quot;%s\\0&quot; &quot;\/u01\/app\/oracle&quot; &gt; ${ORACLE_HOME}\/log\/diag\/adrci_dir.mif\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">DIA-48448: This command does not support multiple ADR homes<\/h2>\n\n\n\n<p>Use <code>set home diag\/xxxxx<\/code> (remove the ORACLE_BASE path)<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nadrci&gt; show problems -last 10\n\nADR Home = \/u01\/app\/oracle\/diag\/rdbms\/mydb1\/MYDB1:\n...\n\nadrci&gt;  set home diag\/rdbms\/mydb1\/MYDB1\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Check last problems Create Package Purge Value for control is hours Value for purge is minutes Fix &#8220;No ADR base is set&#8221; Sometimes also &#8220;DIA-48494: ADR home is not set&#8221; Create a ${ORACLE_HOME}\/log\/diag\/adrci_dir.mif file with: DIA-48448: This command does not support multiple ADR homes Use set home diag\/xxxxx (remove the ORACLE_BASE path)<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":{"0":"post-851","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle","7":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=851"}],"version-history":[{"count":4,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/851\/revisions"}],"predecessor-version":[{"id":985,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/851\/revisions\/985"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}