{"id":11497,"date":"2018-07-30T15:30:20","date_gmt":"2018-07-30T13:30:20","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/"},"modified":"2018-07-30T15:30:20","modified_gmt":"2018-07-30T13:30:20","slug":"patching-oda-lite-to-12-2-1-4-0","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/","title":{"rendered":"Patching ODA lite to 12.2.1.4.0"},"content":{"rendered":"<p>Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed.<\/p>\n<p><strong>1) Download the patch<\/strong><\/p>\n<p>The patch number is 28216794. This patch will update the following components:\u00a0 dcs (odacli), operating system, bios\/firmwares, ilom, GI, dbhomes and databases.<br \/>\nDownload and copy the patch to a temporary folder on the server, for example \/opt\/patch. You&#8217;ll have to be root to apply the patch.<\/p>\n<p><strong>2) Check the actual versions and free space on disk<\/strong><\/p>\n<p>First check the current version:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli describe-component\n\nSystem Version\n---------------\n12.2.1.2.0\n\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK                                       12.2.1.2.0            up-to-date\nGI                                        12.2.0.1.171017       up-to-date\nDB {\n[ OraDB12201_home1 ]                      12.2.0.1.171017       up-to-date\n[ OraDB11204_home1 ]                      11.2.0.4.171017       up-to-date\n}\nDCSAGENT                                  12.2.1.2.0            up-to-date\nILOM                                      4.0.0.28.r121827      4.0.0.22.r120818\nBIOS                                      41017600              41017100\nOS                                        6.8                   up-to-date<\/pre>\n<p>The &#8220;available version&#8221; stands for &#8220;what&#8217;s available in the ODA repository?&#8221;. As this ODA has never been patched, it seems that some of the components are already in newer versions than those provided in the initial deployment package. Registering a new patch will refresh this repository.<\/p>\n<p>Check that folders \/, \/u01 and \/opt have enough free GB to process (&gt;=10GB).<\/p>\n<p><strong>3) Prepare the patch files<\/strong><\/p>\n<p>Previous patch was slightly different from the others because Oracle simply forgot to double zip the file 2 and 3 of the patch. Now this patch is back to a more classic update: unzip and register the 3 unzipped files (they are zip files, too).<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">cd \/opt\/patch\nunzip p28216794_122140_Linux-x86-64_1of3.zip\nunzip p28216794_122140_Linux-x86-64_2of3.zip\nunzip p28216794_122140_Linux-x86-64_3of3.zip\n\nodacli update-repository -f \/tmp\/oda-sm-12.2.1.4.0-180708-server1of3.zip\nodacli update-repository -f \/tmp\/oda-sm-12.2.1.4.0-180708-server2of3.zip\nodacli update-repository -f \/tmp\/oda-sm-12.2.1.4.0-180708-server3of3.zip<\/pre>\n<p>Updating the repository, as other tasks through odacli, will generate a job-id you can look at to confirm that everything is running fine:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli describe-job -i \"4087f0f4-2582-4621-b75c-59c9915a0cb5\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  4087f0f4-2582-4621-b75c-59c9915a0cb5\n            Description:  Repository Update\n                 Status:  Success\n                Created:  July 19, 2018 10:32:53 AM CEST\n                Message:  oda-sm-12.2.1.4.0-180703-server1of3.zip<\/pre>\n<p><span style=\"text-decoration: underline\">Note:<\/span> you can update the repository with a single update-repository command including the 3 files. But it&#8217;s better to do the update separately in case of a corrupted file.<\/p>\n<p>New feature with this patch, you can check if your system is ready for patching with this command:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli create-prepatchreport -s -v 12.2.1.4.0\nodacli describe-prepatchreport -i f45f9750-ec9b-411f-ba53-43205cb17f87<\/pre>\n<p><strong>4) Update the dcs-agent<\/strong><\/p>\n<p>First, you&#8217;ll have to update the dcs-agent:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">\/opt\/oracle\/dcs\/bin\/odacli update-dcsagent -v 12.2.1.4.0\n\nodacli describe-job -i \"5cc9174e-bd7a-435d-aaff-0113e9ab01bc\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  5cc9174e-bd7a-435d-aaff-0113e9ab01bc\n            Description:  DcsAgent patching\n                 Status:  Success\n                Created:  July 19, 2018 10:36:18 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nPatch location validation                July 19, 2018 10:36:18 AM CEST      July 19, 2018 10:36:19 AM CEST      Success\ndcs-agent upgrade                        July 19, 2018 10:36:19 AM CEST      July 19, 2018 10:36:19 AM CEST      Success<\/pre>\n<p>This update takes only few seconds. Check again the version and you will see a new 18c component:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli describe-component\n\nSystem Version\n---------------\n12.2.1.4.0\n\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK                                       12.2.1.2.0            12.2.1.4.0\nGI                                        12.2.0.1.171017       12.2.0.1.180417\nDB {\n[ OraDB12201_home1 ]                      12.2.0.1.171017       12.2.0.1.180417\n[ OraDB11204_home1 ]                      11.2.0.4.171017       11.2.0.4.180417\n}\nDCSAGENT                                  18.2.1.0.0            up-to-date\nILOM                                      4.0.0.28.r121827      4.0.2.20.b.r123704\nBIOS                                      41017600              41021300\nOS                                        6.8                   6.9\nFIRMWARECONTROLLER                        QDV1RE0F              qdv1re14<\/pre>\n<p><strong>5) Update the server<\/strong><\/p>\n<p>Updating the server will update OS, ILOM, BIOS, firmwares and the GI. Update process will assume that no additionnal packages have been installed. If you installed additionnal packages, please remove them as they can prevent the patch to apply correctly.<\/p>\n<p>This part of the update is the longest one (about 1 hour), and will end with a reboot of the server.<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli update-server -v 12.2.1.4.0\n\nodacli describe-job -i \"a2e296c2-1b3e-4ed1-a5cc-0cb7c4d23120\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  a2e296c2-1b3e-4ed1-a5cc-0cb7c4d23120\n            Description:  Server Patching\n                 Status:  Success\n                Created:  July 19, 2018 12:12:53 PM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nPatch location validation                July 19, 2018 12:12:53 PM CEST      July 19, 2018 12:12:53 PM CEST      Success\ndcs-controller upgrade                   July 19, 2018 12:12:54 PM CEST      July 19, 2018 12:12:54 PM CEST      Success\nPatch location validation                July 19, 2018 12:12:54 PM CEST      July 19, 2018 12:12:54 PM CEST      Success\ndcs-cli upgrade                          July 19, 2018 12:12:54 PM CEST      July 19, 2018 12:12:54 PM CEST      Success\nCreating repositories using yum          July 19, 2018 12:12:54 PM CEST      July 19, 2018 12:12:55 PM CEST      Success\nApplying HMP Patches                     July 19, 2018 12:12:55 PM CEST      July 19, 2018 12:14:31 PM CEST      Success\nPatch location validation                July 19, 2018 12:14:31 PM CEST      July 19, 2018 12:14:31 PM CEST      Success\noda-hw-mgmt upgrade                      July 19, 2018 12:14:31 PM CEST      July 19, 2018 12:14:31 PM CEST      Success\nCreating repositories using yum          July 19, 2018 12:14:31 PM CEST      July 19, 2018 12:14:35 PM CEST      Success\nApplying OS Patches                      July 19, 2018 12:14:35 PM CEST      July 19, 2018 12:16:18 PM CEST      Success\nOSS Patching                             July 19, 2018 12:16:18 PM CEST      July 19, 2018 12:16:18 PM CEST      Success\nApplying Firmware Disk Patches           July 19, 2018 12:16:18 PM CEST      July 19, 2018 12:16:23 PM CEST      Success\nApplying Firmware Expander Patches       July 19, 2018 12:16:23 PM CEST      July 19, 2018 12:16:26 PM CEST      Success\nApplying Firmware Controller Patches     July 19, 2018 12:16:26 PM CEST      July 19, 2018 12:16:30 PM CEST      Success\nChecking Ilom patch Version              July 19, 2018 12:16:31 PM CEST      July 19, 2018 12:16:33 PM CEST      Success\nPatch location validation                July 19, 2018 12:16:33 PM CEST      July 19, 2018 12:16:34 PM CEST      Success\nApply Ilom patch                         July 19, 2018 12:16:35 PM CEST      July 19, 2018 12:16:36 PM CEST      Success\nCopying Flash Bios to Temp location      July 19, 2018 12:16:37 PM CEST      July 19, 2018 12:16:37 PM CEST      Success\nStarting the clusterware                 July 19, 2018 12:16:57 PM CEST      July 19, 2018 12:16:58 PM CEST      Success\nclusterware patch verification           July 19, 2018 12:16:58 PM CEST      July 19, 2018 12:17:00 PM CEST      Success\nPatch location validation                July 19, 2018 12:17:00 PM CEST      July 19, 2018 12:17:03 PM CEST      Success\nOpatch updation                          July 19, 2018 12:17:33 PM CEST      July 19, 2018 12:17:35 PM CEST      Success\nPatch conflict check                     July 19, 2018 12:17:35 PM CEST      July 19, 2018 12:18:16 PM CEST      Success\nclusterware upgrade                      July 19, 2018 12:18:16 PM CEST      July 19, 2018 12:33:07 PM CEST      Success\nUpdating GiHome version                  July 19, 2018 12:33:07 PM CEST      July 19, 2018 12:33:11 PM CEST      Success\npreRebootNode Actions                    July 19, 2018 12:33:30 PM CEST      July 19, 2018 12:34:11 PM CEST      Success\nReboot Ilom                              July 19, 2018 12:34:11 PM CEST      July 19, 2018 12:34:11 PM CEST      Success<\/pre>\n<p>If there is a problem during the patching process (you forgot to remove an additionnal rpm or one of the patch file is missing for example), you can relaunch the patching and it will skip the already patched components.<\/p>\n<p>Once this part of the patch is successfuly applied, check again the components:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli describe-component\n\nSystem Version\n---------------\n12.2.1.4.0\n\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK                                       12.2.1.4.0            up-to-date\nGI                                        12.2.0.1.180417       up-to-date\nDB {\n[ OraDB12201_home1 ]                      12.2.0.1.171017       12.2.0.1.180417\n[ OraDB11204_home1 ]                      11.2.0.4.171017       11.2.0.4.180417\n}\nDCSAGENT                                  18.2.1.0.0            up-to-date\nILOM                                      4.0.2.20.b.r123704    up-to-date\nBIOS                                      41017600              41021300\nOS                                        6.9                   up-to-date\nFIRMWARECONTROLLER                        QDV1RE14              up-to-date<\/pre>\n<p><span style=\"text-decoration: underline\">Note:<\/span> at this time, BIOS is not yet updated. Don&#8217;t know why but check this later and it will be OK.<\/p>\n<p><strong>6) Patch the dbhomes<\/strong><\/p>\n<p>You now need to patch the dbhomes separately. First of all, list them:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli list-dbhomes\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n90556d26-6756-4fed-9546-d44d55b6fc04     OraDB11204_home1     11.2.0.4.171017 (26609929, 26392168)     \/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1     Configured\n18a9c067-3629-409d-9bae-60d27516c914     OraDB12201_home1     12.2.0.1.171017 (27020386, 26710464)     \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1     Configured<\/pre>\n<p>Patch the first one. Target version is actually version of the patch. Remember that updating the ODA through a patch will never upgrade your database to a newer release, your 11gR2 databases will stay in 11.2.0.4 and 12cR1 databases will stay in 12.1.0.2 (if you&#8217;re using one or both of these versions). Only the PSU number will change (the fifth number which is actually a date).<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli update-dbhome -i 90556d26-6756-4fed-9546-d44d55b6fc04 -v 12.2.1.4.0\n\nodacli describe-job -i \"c1abf083-d597-4673-b07b-d7cb79ec434a\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  c1abf083-d597-4673-b07b-d7cb79ec434a\n            Description:  DB Home Patching: Home Id is 90556d26-6756-4fed-9546-d44d55b6fc04\n                 Status:  Success\n                Created:  July 19, 2018 12:59:11 PM CEST\n                Message:  WARNING::Failed to run the datapatch as db DB03_S2 is not registered with clusterware##WARNING::Failed to run the datapatch as db DB04_S2 is not registered with clusterware##WARNING::Failed to run the datapatch as db DB05_S2 is not r\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nclusterware patch verification           July 19, 2018 12:59:12 PM CEST      July 19, 2018 12:59:15 PM CEST      Success\nPatch location validation                July 19, 2018 12:59:15 PM CEST      July 19, 2018 12:59:19 PM CEST      Success\nOpatch updation                          July 19, 2018 12:59:39 PM CEST      July 19, 2018 12:59:40 PM CEST      Success\nPatch conflict check                     July 19, 2018 12:59:40 PM CEST      July 19, 2018 12:59:49 PM CEST      Success\ndb upgrade                               July 19, 2018 12:59:49 PM CEST      July 19, 2018 1:01:22 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:22 PM CEST       July 19, 2018 1:01:22 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:22 PM CEST       July 19, 2018 1:01:22 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:22 PM CEST       July 19, 2018 1:01:23 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:23 PM CEST       July 19, 2018 1:01:23 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:23 PM CEST       July 19, 2018 1:01:23 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:23 PM CEST       July 19, 2018 1:01:23 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:23 PM CEST       July 19, 2018 1:01:23 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:23 PM CEST       July 19, 2018 1:01:24 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:24 PM CEST       July 19, 2018 1:01:24 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:24 PM CEST       July 19, 2018 1:01:24 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:24 PM CEST       July 19, 2018 1:01:24 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:24 PM CEST       July 19, 2018 1:01:24 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:01:24 PM CEST       July 19, 2018 1:01:25 PM CEST       Success<\/pre>\n<p>Despite the overall Success status, some database could stay in previous version for some reason:<br \/>\n&#8211; database is a StandBy database : no update is possible on the dictionary (dictionary will be updated when the primary server will be patched)<br \/>\n&#8211; database is not correctly registered in the Oracle Cluster repository (if you create the database with odacli in instance-only mode: create-database -io &#8211; Probably a bug)<\/p>\n<p>After applying the patch, please check the version of your dictionary on each database with this statement :<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">select ACTION_TIME, ACTION, VERSION, ID, BUNDLE_SERIES, COMMENTS from  DBA_REGISTRY_HISTORY;\nACTION_TIME                    ACTION       VERSION                  ID BUNDLE_SERIES   COMMENTS\n------------------------------ ------------ ---------------- ---------- --------------- ------------------------------\n23\/07\/18 20:25:26,765974       APPLY        11.2.0.4             180417 PSU             PSU 11.2.0.4.180417<\/pre>\n<p>Then update the next dbhome:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli update-dbhome -i 18a9c067-3629-409d-9bae-60d27516c914 -v 12.2.1.4.0\n\nodacli describe-job -i \"ef53a8a6-bd74-40f6-a338-343489d41a1c\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  ef53a8a6-bd74-40f6-a338-343489d41a1c\n            Description:  DB Home Patching: Home Id is 18a9c067-3629-409d-9bae-60d27516c914\n                 Status:  Success\n                Created:  July 19, 2018 1:20:20 PM CEST\n                Message:  WARNING::Failed to run datapatch on db DB12TST Failed to run Utlrp script##WARNING::Failed to run the datapatch as db DB12DEV: is not registered with clusterware\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nclusterware patch verification           July 19, 2018 1:20:41 PM CEST       July 19, 2018 1:20:42 PM CEST       Success\nPatch location validation                July 19, 2018 1:20:42 PM CEST       July 19, 2018 1:20:42 PM CEST       Success\nOpatch updation                          July 19, 2018 1:20:42 PM CEST       July 19, 2018 1:20:42 PM CEST       Success\nPatch conflict check                     July 19, 2018 1:20:42 PM CEST       July 19, 2018 1:20:42 PM CEST       Success\ndb upgrade                               July 19, 2018 1:20:42 PM CEST       July 19, 2018 1:20:42 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:20:42 PM CEST       July 19, 2018 1:20:47 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:20:47 PM CEST       July 19, 2018 1:20:47 PM CEST       Success\nSqlPatch upgrade                         July 19, 2018 1:20:47 PM CEST       July 19, 2018 1:21:03 PM CEST       Success<\/pre>\n<p>As previously patched dbhome, this one also has warnings. Please check if each database is OK.<\/p>\n<p>Check the \/opt\/oracle\/dcs\/log\/dcs-agent.log for extended warning messages if needed, and then check the DB Version after the update of all dbhomes:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli list-dbhomes\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n90556d26-6756-4fed-9546-d44d55b6fc04     OraDB11204_home1     11.2.0.4.180417 (27441052, 27338049)     \/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1     Configured\n18a9c067-3629-409d-9bae-60d27516c914     OraDB12201_home1     12.2.0.1.180417 (27464465, 27674384)     \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1     Configured<\/pre>\n<p>Jump to step 8 if your databases are OK.<\/p>\n<p><strong>7) Update the databases where datapatch failed<\/strong><\/p>\n<p>If for some reason datapatch was not applied on some of your databases and it should have been, you&#8217;ll have to do it manually:<\/p>\n<p>For 12c :<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">su \u2013 oracle\n. oraenv &lt;&lt;&lt; DB12TST\ncd $ORACLE_HOME\/OPatch\n.\/datapatch -verbose<\/pre>\n<p>For 11gR2 :<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">su \u2013 oracle\n. oraenv &lt;&lt;&lt; DB11TST\nsqlplus \/ as sysdba\n@?\/rdbms\/admin\/catbundle.sql psu apply<\/pre>\n<p><strong>8) Patch the storage<\/strong><\/p>\n<p>No update-storage is needed for this patch on this ODA.<\/p>\n<p><strong>9) Optional: deploy the latest db clone files<\/strong><\/p>\n<p>If you&#8217;ll never deploy a new dbhome this step is not necessary. If you will, or simply if you don&#8217;t know if you&#8217;ll have to do that later, download and register the new db clone files in the repository to be able to create a new dbhome at the same patch level than the one already deployed, for example:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">cd \/opt\/patch\n\nunzip p27119402_122140_Linux-x86-64.zip\nArchive:  p27119402_122140_Linux-x86-64.zip\n extracting: odacli-dcs-12.2.1.4.0-180617-DB-12.2.0.1.zip\n  inflating: README.txt\n\nupdate-image --image-files odacli-dcs-12.2.1.4.0-180617-DB-12.2.0.1.zip\nUnpacking will take some time,  Please wait...\nUnzipping odacli-dcs-12.2.1.4.0-180617-DB-12.2.0.1.zip<\/pre>\n<p><strong>10) Control the final version of the components<\/strong><\/p>\n<p>Now the patching is done. \u00b12 hours were needed, if everything is OK.<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">oodacli describe-component\n\nSystem Version\n---------------\n12.2.1.4.0\n\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK                                       12.2.1.4.0            up-to-date\nGI                                        12.2.0.1.180417       up-to-date\nDB {\n[ OraDB12201_home1 ]                      12.2.0.1.180417       up-to-date\n[ OraDB11204_home1 ]                      11.2.0.4.180417       up-to-date\n}\nDCSAGENT                                  18.2.1.0.0            up-to-date\nILOM                                      4.0.2.20.b.r123704    up-to-date\nBIOS                                      41021300              up-to-date\nOS                                        6.9                   up-to-date\nFIRMWARECONTROLLER                        QDV1RE14              up-to-date<\/pre>\n<p><strong>11) Optional: patch the SFP firmware<\/strong><\/p>\n<p>If you&#8217;re using SFP network interfaces on your ODA X7 (fiber connected network), you may encounter network troubles (lost of pings, failover not working correctly, and so on). SFP are not part of the ODA patching process, but there is a firmware update available for those kind of SFP on Oracle X7 server familly (including ODA). Please review note 2373070.1 for more information :<\/p>\n<p><a title=\"Using the onboard SFP28 ports on an ODA X7-2 server node (Doc ID 2373070.1)\" href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2373070.1\" target=\"_blank\" rel=\"noopener\">Using the onboard SFP28 ports on an ODA X7-2 server node (Doc ID 2373070.1)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the patch The patch number is 28216794. This patch will update the following components:\u00a0 dcs (odacli), [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59],"tags":[1413,1414,1415,79,96,572,1416,1329],"type_dbi":[],"class_list":["post-11497","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-12-2-1-4-0","tag-datapatch","tag-fiber","tag-oda","tag-oracle","tag-patch","tag-sfp","tag-x7"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Patching ODA lite to 12.2.1.4.0 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Patching ODA lite to 12.2.1.4.0\" \/>\n<meta property=\"og:description\" content=\"Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the patch The patch number is 28216794. This patch will update the following components:\u00a0 dcs (odacli), [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-30T13:30:20+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"Patching ODA lite to 12.2.1.4.0\",\"datePublished\":\"2018-07-30T13:30:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/\"},\"wordCount\":885,\"commentCount\":0,\"keywords\":[\"12.2.1.4.0\",\"datapatch\",\"fiber\",\"ODA\",\"Oracle\",\"patch\",\"SFP\",\"X7\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/\",\"name\":\"Patching ODA lite to 12.2.1.4.0 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-07-30T13:30:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/patching-oda-lite-to-12-2-1-4-0\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Patching ODA lite to 12.2.1.4.0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\\\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-dubar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Patching ODA lite to 12.2.1.4.0 - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/","og_locale":"en_US","og_type":"article","og_title":"Patching ODA lite to 12.2.1.4.0","og_description":"Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the patch The patch number is 28216794. This patch will update the following components:\u00a0 dcs (odacli), [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/","og_site_name":"dbi Blog","article_published_time":"2018-07-30T13:30:20+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"Patching ODA lite to 12.2.1.4.0","datePublished":"2018-07-30T13:30:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/"},"wordCount":885,"commentCount":0,"keywords":["12.2.1.4.0","datapatch","fiber","ODA","Oracle","patch","SFP","X7"],"articleSection":["Database Administration &amp; Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/","url":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/","name":"Patching ODA lite to 12.2.1.4.0 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-07-30T13:30:20+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-lite-to-12-2-1-4-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Patching ODA lite to 12.2.1.4.0"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11497"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11497\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11497"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}