{"id":96,"date":"2015-01-30T11:21:50","date_gmt":"2015-01-30T10:21:50","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=96"},"modified":"2015-11-17T20:27:22","modified_gmt":"2015-11-17T19:27:22","slug":"oracle-january-2015-cpu-quick-and-dirty-install-on-11-2-0-4-and-12-1-0-2","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2015\/01\/30\/oracle-january-2015-cpu-quick-and-dirty-install-on-11-2-0-4-and-12-1-0-2\/","title":{"rendered":"Oracle January 2015 CPU &#8211; quick and dirty install on 11.2.0.4 and 12.1.0.2"},"content":{"rendered":"<p>While one should always read the documentation accompanying the patches, the new January 2015 (and in some extend also October 2014) are more complex to install with a java and a db components.<\/p>\n<p>If you are single instance database (no RAC) and either 11.2.0.4 or 12.1.0.2 here are the quick summary\u00a0of the installation. Tested on Linux and Solaris SPARC:<\/p>\n<h4>Oracle 12.1.0.2 &#8211; January 2015 CPU installation<\/h4>\n<p><strong>Bundle 12.1.0.2 &#8211; Patch 20132434<\/strong><\/p>\n<ul>\n<li>Patch 19769480 &#8211; Database Patch Set Update 12.1.0.2.2 (Jan2015) &#8211;&gt; RAC-Rolling Installable<\/li>\n<li>Patch 19877336 &#8211; Oracle JavaVM Component 12.1.0.2.2 Database PSU (JAN2015) &#8211;&gt; Non RAC-Rolling Installable<\/li>\n<\/ul>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nexport PATCH_LOC=&quot;\/tmp&quot;\r\n<\/pre>\n<p>1. Download + Upgrade OPatch<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nunzip ${PATCH_LOC}\/p6880880_121010_Linux-x86-64.zip -d $ORACLE_HOME\r\n<\/pre>\n<p>2. Stop database+listeners+agent<\/p>\n<p>3. Apply DB PSU (19769480) but do NOT run DB PSU post install steps<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd\u00a0${PATCH_LOC}\r\nunzip p2*\r\ncd 2*\r\ncd 19769480\/\r\n$ORACLE_HOME\/OPatch\/opatch apply\r\n<\/pre>\n<p>3. Apply OJVM PSU patch<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd ..\/19877336\/\r\n$ORACLE_HOME\/OPatch\/opatch apply\r\n<\/pre>\n<p>4. Restart database<\/p>\n<p>5. Run post install steps<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd $ORACLE_HOME\/OPatch\r\n.\/datapatch -verbose\r\n<\/pre>\n<hr \/>\n<p>&nbsp;<\/p>\n<h4>Oracle 11.2.0.4 &#8211; January 2015 CPU installation<\/h4>\n<p>&nbsp;<\/p>\n<p><strong>Bundle 11.2.0.4 &#8211; Patch 20132517<\/strong><\/p>\n<ul>\n<li>Patch 19854503 &#8211; Database Security Patch Update 11.2.0.4.0 (CPUJAN2015) &#8211;&gt; RAC-Rolling Installable<\/li>\n<li>Patch 19877440 &#8211; Oracle JavaVM Component 11.2.0.4.2 Database PSU (JAN2015) &#8211;&gt; Non RAC-Rolling Installable<\/li>\n<\/ul>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nexport PATCH_LOC=&quot;\/tmp&quot;\r\ncd\u00a0${PATCH_LOC}\r\nunzip p20132517_112040_Linux-x86-64.zip\r\ncd 2*\r\n<\/pre>\n<p>1. Shutdown databases and services<br \/>\n2.\u00a0Apply DB PSU (19854503) but do NOT run DB PSU post install steps<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd 19854503\r\n$ORACLE_HOME\/OPatch\/opatch napply -skip_subset -skip_duplicate\r\n<\/pre>\n<p>3. Apply OJVM PSU patch<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd ..\/19877440\/\r\n$ORACLE_HOME\/OPatch\/opatch apply\r\n<\/pre>\n<p>4. For 11.2.0.3 and 11.2.0.4 run the OJVM PSU post install steps followed by the DB PSU (or equivalent) post install steps.<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd $ORACLE_HOME\/sqlpatch\/19877440\r\nsqlplus \/ as sysdba\r\n<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSQL&gt; startup upgrade\r\nSQL&gt; @postinstall.sql\r\nSQL&gt; shutdown immediate\r\nSQL&gt; exit;\r\n<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\ncd $ORACLE_HOME\/rdbms\/admin\r\n$ sqlplus \/ as sysdba\r\n<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSQL&gt; startup\r\nSQL&gt; @catbundle.sql cpu apply\r\nSQL&gt; @utlrp.sql\r\nSQL&gt; exit;\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While one should always read the documentation accompanying the patches, the new January 2015 (and in some extend also October 2014) are more complex to install with a java and a db components. If you are single instance database (no RAC) and either 11.2.0.4 or 12.1.0.2 here are the quick summary\u00a0of the installation. Tested on [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,2,7,19,9],"tags":[],"class_list":{"0":"post-96","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle","7":"category-oracle-11g","8":"category-oracle-12c","9":"category-psu","10":"category-security","11":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/96","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=96"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/96\/revisions"}],"predecessor-version":[{"id":97,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/96\/revisions\/97"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}