Step 7: Patch Oracle Database

After you verify that both nodes upgraded successfully to Oracle Linux 6, apply the Oracle Database Appliance 12.1.2.6 patch set to update Oracle Database on Node 0 and Node 1.

Caution:

You must patch the infrastructure and Oracle Grid Infrastructure on both Node0 and Node1 before patching Oracle Database.

Run the command oakcli show databases on Node 0.

For example:

#oakcli show databases

Name Type     Storage  HomeName         HomeLocation                              Version
---- ----     -------  --------         ------------                              -------
db1 RAC        ACFS    OraDb12102_home1 /u01/app/oracle/product/12.1.0.2/dbhome_1 12.1.0.5.0(20831110,20831110)
db2 SINGLE     ACFS    OraDb12102_home2 /u01/app/oracle/product/12.1.0.2/dbhome_2 12.1.0.2.160119(21948354,21948344))
db3 RACOneNode ACFS    OraDb12102_home3 /u01/app/oracle/product/12.1.0.2/dbhome_3 12.1.0.5.0(20831110,20831110)
db4 RAC        ACFS    OraDb12102_home4 /u01/app/oracle/product/12.1.0.2/dbhome_4 12.1.0.2.160119(21948354,21948344)

Note:

You cannot perform individual database updates for databases running in the same home. All databases running in the homes that you update are patched to the Oracle Database 12c release 1 patch for Oracle Database Appliance (12.1.0.2.160119).

Run the oakcli update -patch 12.1.2.6.0 --database command, on Node 0 only. The command automatically patches both nodes. If you have more than one database home that can be patched, then the software provides a selection list. You can select, one, a set, or all of the Oracle Database homes to upgrade.

After the command completes on both nodes, use the following command on Node 0 to check your database version:

oakcli show databases

For example:

#oakcli show databases
 
Name Type     Storage  HomeName         HomeLocation                               Version
---- ----     -------  --------         ------------                               -------
db1 RAC        ACFS    OraDb12102_home1 /u01/app/oracle/product/12.1.0.2/dbhome_1  12.1.0.2.160119(21948354,21948344)
db2 SINGLE     ACFS    OraDb12102_home2 /u01/app/oracle/product/12.1.0.2/dbhome_2  12.1.0.2.160119(21948354,21948344)
db3 RACOneNode ACFS    OraDb12102_home3 /u01/app/oracle/product/12.1.0.2/dbhome_3  12.1.0.2.160119(21948354,21948344)
db4 RAC        ACFS    OraDb12102_home4 /u01/app/oracle/product/12.1.0.2/dbhome_4  12.1.0.2.160119(21948354,21948344)

Run the command oakcli validate -c ol6upgrade -postchecks to validate your Oracle Linux 6 upgrade on both nodes.
Run the following command to verify the completeness of the Oracle Linux 6 upgrade:
```
oakcli validate -c ol6upgrade -postchecks
```
The - postchecks option causes the command to perform checks to validate that the operating system is active, that the network services and interfaces are up and running and reachable, and that the storage system components are online, and are configured correctly.