Manual database upgrade from 12.1.0.1 to 12.1.0.2



Today I've come to do my first upgrade from 12.1.0.1 (12cR1) to 12.1.0.2 (12cR2). I always do these upgrades manually (it's kind of stuck since you had to do it that way in the 'old' days).

So the first thing i normally do is check on metalink "my oracle support" for the manual upgrade steps.

And i couldn't find it, i just kept finding references to cloud control and even times ten but nothing specific about the database update i wanted to do.

So i turned to google

And i quickly found this link to the oracle documentation which covers all the steps

http://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD12408

I'm not going to cover all the steps in detail - you can read that in the docs for yourself - i would however pick out a couple of points.

I was doing an upgrade of a "cdb/seed/single pdb"/multitenant database so followed the notes for that.

I found that between steps 9 and 10 there is a missing missing startup upgrade

When the upgrade finished (which was all fine by the way) - this line is recorded in the screen output

Upgrade Summary Report Located in:
/oracle/12.1.0.2/cfgtoollogs/RICH/upgrade/upg_summary.log

Opening this file gives a nice summary of the CDB/SEED and PDB

Oracle Database 12.1 Post-Upgrade Status Tool           10-22-2014 08:13:59
                             [CDB$ROOT:1]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.1.0.2.0  00:06:55
JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:01:56
Oracle Real Application Clusters     OPTION OFF      12.1.0.2.0  00:00:01
Oracle Workspace Manager                  VALID      12.1.0.2.0  00:01:11
OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:18
Oracle OLAP API                           VALID      12.1.0.2.0  00:00:20
Oracle Label Security                     VALID      12.1.0.2.0  00:00:11
Oracle XDK                                VALID      12.1.0.2.0  00:00:36
Oracle Text                               VALID      12.1.0.2.0  00:00:23
Oracle XML Database                       VALID      12.1.0.2.0  00:00:52
Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:12
Oracle Multimedia                         VALID      12.1.0.2.0  00:01:45
Spatial                                UPGRADED      12.1.0.2.0  00:02:00
Oracle Application Express                VALID     4.2.5.00.08  00:02:49
Oracle Database Vault                     VALID      12.1.0.2.0  00:00:11
Final Actions                                                    00:00:11
Post Upgrade                                                     00:01:36

Total Upgrade Time: 00:21:39 [CDB$ROOT]

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.09

Oracle Database 12.1 Post-Upgrade Status Tool           10-22-2014 08:33:48
                             [MARKER:3]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.1.0.2.0  00:09:46
JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:01:04
Oracle Real Application Clusters     OPTION OFF      12.1.0.2.0  00:00:01
Oracle Workspace Manager                  VALID      12.1.0.2.0  00:00:54
OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:19
Oracle OLAP API                           VALID      12.1.0.2.0  00:00:15
Oracle Label Security                     VALID      12.1.0.2.0  00:00:04
Oracle XDK                                VALID      12.1.0.2.0  00:00:28
Oracle Text                               VALID      12.1.0.2.0  00:00:06
Oracle XML Database                       VALID      12.1.0.2.0  00:00:38
Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:07
Oracle Multimedia                         VALID      12.1.0.2.0  00:00:56
Spatial                                UPGRADED      12.1.0.2.0  00:01:26
Oracle Application Express                VALID     4.2.5.00.08  00:01:40
Oracle Database Vault                     VALID      12.1.0.2.0  00:00:10
Final Actions                                                    00:00:10
Post Upgrade                                                     00:01:07

Total Upgrade Time: 00:19:20 [MARKER]

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.10

Oracle Database 12.1 Post-Upgrade Status Tool           10-22-2014 08:34:43
                             [PDB$SEED:2]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                             VALID      12.1.0.2.0  00:09:40
JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:00:57
Oracle Real Application Clusters     OPTION OFF      12.1.0.2.0  00:00:01
Oracle Workspace Manager                  VALID      12.1.0.2.0  00:00:51
OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:18
Oracle OLAP API                           VALID      12.1.0.2.0  00:00:14
Oracle Label Security                     VALID      12.1.0.2.0  00:00:05
Oracle XDK                                VALID      12.1.0.2.0  00:00:26
Oracle Text                               VALID      12.1.0.2.0  00:00:06
Oracle XML Database                       VALID      12.1.0.2.0  00:00:39
Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:08
Oracle Multimedia                         VALID      12.1.0.2.0  00:01:01
Spatial                                   VALID      12.1.0.2.0  00:01:26
Oracle Application Express                VALID     4.2.5.00.08  00:01:37
Oracle Database Vault                     VALID      12.1.0.2.0  00:00:12
Final Actions                                                    00:00:10
Post Upgrade                                                     00:01:04

Total Upgrade Time: 00:19:05 [PDB$SEED]

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.12

Upgrade Times Sorted In Descending Order

Total Upgrade Time: 00:21:39 [CDB$ROOT]
Total Upgrade Time: 00:19:20 [MARKER]
Total Upgrade Time: 00:19:05 [PDB$SEED]
Grand Total Upgrade Time:    [0d:0h:43m:20s]

The overall summary time is quite useful and it seems that the new parallel upgrade seems to work well with the catctl script (we can see SEED and PDB were done at the same time based on the total and individual timings)

There is a step in the notes about checking if catuppst.sql has been run - this check does not seem to be correct - i think it is more valid to search for this string to see if it ran OK

COMP_TIMESTAMP POSTUP_BGN 

Before you run utlrp (via catctl) - the following needs to be run to open all the PDB's (again missing from the steps)

SQL> alter pluggable database all open;

Pluggable database altered.

Other than those minor doc issues (which I've fed back through the documentation comment process - we'll see how well that works as i never did that before) it was very smooth.

I'm sure dbua would have done just as good a job but i can't give up the command line upgrades - I've converted to some GUI's but I'm still stuck in the past with this......



Comments

  1. Nice article.

    12.1.0.1 is Oracle 12cR1

    12.1.0.2 is patchset?

    12.2.0.1 - Oracle 12cR2

    ReplyDelete

Post a Comment