{"id":187,"date":"2016-02-02T09:46:59","date_gmt":"2016-02-02T08:46:59","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=187"},"modified":"2016-02-02T09:47:29","modified_gmt":"2016-02-02T08:47:29","slug":"back-to-the-basics-correct-parameter-from-spfile-in-asm","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2016\/02\/02\/back-to-the-basics-correct-parameter-from-spfile-in-asm\/","title":{"rendered":"Back to the basics: correct parameter from SPFILE in ASM"},"content":{"rendered":"<p>When you change the size of memory and forget to update SGA_MAX_SIZE it might happen:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\noracle@anjo01:\/home\/oracle &#x5B;] srvctl start database -d p05ltm02\r\nPRCR-1079 : Failed to start resource ora.p05ltm02.db\r\nCRS-5017: The resource action &quot;ora.p05ltm02.db start&quot; encountered the following error:\r\nORA-01078: failure in processing system parameters\r\nORA-00823: Specified value of sga_target greater than sga_max_size\r\n<\/pre>\n<p>As this is a clustered database with ASM, here the easiest way to solve:<\/p>\n<p>1. Find the full path of the SPFILE on ASM<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\noracle@anjo01:\/home\/oracle &#x5B;p05ltm02_1] srvctl config database -d p05ltm02 -a\r\nDatabase unique name: p05ltm02\r\nDatabase name: ltm02\r\nOracle home: \/oracle\/app\/product\/11.2.0.4\r\nOracle user: oracle\r\nSpfile: +DGDATA\/p05ltm02\/spfileltm02.ora\r\nDomain:\r\nStart options: open\r\nStop options: immediate\r\nDatabase role: PRIMARY\r\nManagement policy: AUTOMATIC\r\nServer pools: sp_ha01\r\nDatabase instances:\r\nDisk Groups: DGDATA,DGFRA\r\nMount point paths:\r\nServices: p05ltm02_app.anjo01\r\nType: RACOneNode\r\nOnline relocation timeout: 30\r\nInstance name prefix: p05ltm02\r\nCandidate servers: anjo01,anjo02\r\nDatabase is enabled\r\nDatabase is policy managed\r\n<\/pre>\n<p>2. Create a PFILE from SPFILE on the local filesystem<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\noracle@anjo01:\/home\/oracle &#x5B;p05ltm02_1] sqh\r\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 2 09:33:47 2016\r\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\nConnected to an idle instance.\r\n\r\nSQL&gt; create pfile='\/tmp\/pfile.txt' from spfile='+DGDATA\/p05ltm02\/spfileltm02.ora';\r\nFile created.\r\n\r\nSQL&gt; exit\r\nDisconnected\r\n<\/pre>\n<p>3. Correct the damn parameter <\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\noracle@anjo01:\/home\/oracle &#x5B;p05ltm02_1] vi \/tmp\/pfile.txt\r\n<\/pre>\n<p>4. Recreate the SPFILE on ASM:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\noracle@anjo01:\/home\/oracle &#x5B;p05ltm02_1] sqh\r\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 2 09:34:44 2016\r\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\nConnected to an idle instance.\r\n\r\nSQL&gt; create spfile='+DGDATA\/p05ltm02\/spfileltm02.ora' from pfile='\/tmp\/pfile.txt';\r\nFile created.\r\n\r\nSQL&gt; exit\r\nDisconnected\r\n<\/pre>\n<p>5. And finally restart the database:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\noracle@anjo01:\/home\/oracle &#x5B;p05ltm02_1] srvctl start database -d p05ltm02\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>When you change the size of memory and forget to update SGA_MAX_SIZE it might happen: oracle@anjo01:\/home\/oracle &#x5B;] srvctl start database -d p05ltm02 PRCR-1079 : Failed to start resource ora.p05ltm02.db CRS-5017: The resource action &quot;ora.p05ltm02.db start&quot; encountered the following error: ORA-01078: failure in processing system parameters ORA-00823: Specified value of sga_target greater than sga_max_size As this [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34,6,2],"tags":[],"class_list":{"0":"post-187","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-asm","7":"category-oracle","8":"category-oracle-11g","9":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/187","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=187"}],"version-history":[{"count":5,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/187\/revisions"}],"predecessor-version":[{"id":192,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/187\/revisions\/192"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}