Updating to Oracle Database 12.1.0.2.160119 from Previous Oracle Database 12.1.0.2.x Releases

Use this example to understand steps required to update Oracle Database 12c release 1 (12.1) releases on Oracle Database Appliance.

You use Oracle Appliance Manager (OAKCLI) to update Oracle Database installations. In this scenario, you have updated two databases to Oracle Database 12c release 1 12.1.0.2.160119 when you ran the Oracle Database Appliance 12.1.2.6 patch set update, but you have not updated two other Oracle Database instances that are patched at Oracle Database 12c release 1 (12.1.0.2.4). This procedure describes how to update databases manually after the patch set update.

The Oracle Database Appliance patch set for Oracle Database uses a new numbering sequence. The Oracle Database update for Oracle Database Appliance patch set 12.1.2.6 is 12.1.0.2.160119.

1. Run the command oakcli show databases on Node 0 only. Review the output of this command to confirm that you have databases with the appropriate release number for this update.

   The following example shows that there are four databases, db1, db2, db3, and db4:

   # 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.4(20831110,20831110)
   db2 SINGLE     ACFS   OraDb12102_home2 /u01/app/oracle/product/12.1.0.2/dbhome_2 12.1.0.2.4(20831110,20831110)
   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)
   

   Note:

   In this example, the databases are in separate Oracle home locations. This option provides the ability to update individual databases, but requires more administration and storage allocation. Databases in separate homes must be updated individually.

   Databases in the same database home require less storage allocation, and can be updated as a group. However, you cannot update individual databases in a shared Oracle database home location.

2. Run the command oakcli update -patch 12.1.2.6.0 --database on Node 0 only. When you run this command without specifying a database or a database home, the command automatically patches both nodes.

   If you have more than one database home that is a candidate for patching, then the command displays a selection list from which you can pick one, some, or all of the candidate database homes that you want to update.

3. After the update command completes running, run the command oakcli show databases on Node 0 again.

   The command and output should now look similar to the following 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)
   

   The Oracle Database instances db1 and db2 are now updated to 12.1.0.2.160119.