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
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......
Nice article.
ReplyDelete12.1.0.1 is Oracle 12cR1
12.1.0.2 is patchset?
12.2.0.1 - Oracle 12cR2