Oracle 12c upgrade process general impression

I am testing the 12c upgrades for a half a year now and I have done a lot of 10g to 11g upgrades in the past. How much better the upgrade process is comparing with older versions?

My general impression is the whole process got much better.

  • Parallel Upgrade. The biggest achievement from my point of view is that now its possible to run the upgrade in parallel. In 11g the main upgrade process could run more than 30 minutes. Now with using parallel option this time could be decreased.
<br />Analyzing file catupgrd.sql
Log files in /u01/app/oracle/product/12.1.0.2/rdbms/admin
catcon: ALL catcon-related output will be written to catupgrd_catcon_4747.lst
catcon: See catupgrd*.log files for output generated by scripts
catcon: See catupgrd_*.lst files for spool files, if any
Number of Cpus        = 4
SQL Process Count     = 0
New SQL Process Count = 4

  • Pre-Upgrade script. Now the preupgrade script not only checking for more issues, it also writes the action in the script which can be executed before the upgrade.
<br />====>> PRE-UPGRADE RESULTS for UPGR <<====

ACTIONS REQUIRED:

1. Review results of the pre-upgrade checks:
/u01/app/oracle/cfgtoollogs/UPGR/preupgrade/preupgrade.log

2. Execute in the SOURCE environment BEFORE upgrade:
/u01/app/oracle/cfgtoollogs/UPGR/preupgrade/preupgrade_fixups.sql

3. Execute in the NEW environment AFTER upgrade:
/u01/app/oracle/cfgtoollogs/UPGR/preupgrade/postupgrade_fixups.sql

  • Instrumentation. During the upgrade the status of progress is shown, now its possible to estimate where you are in the process.
<br />------------------------------------------------------
Phases [0-73]         Start Time:[2016_10_30 16:36:05]
------------------------------------------------------
Serial   Phase #: 0      Files: 1     Time: 252s
Serial   Phase #: 1      Files: 5
Time: 139s
Restart  Phase #: 2      Files: 1     Time: 0s
Parallel Phase #: 3      Files: 18    Time: 29s
Restart  Phase #: 4      Files: 1     Time: 1s
Serial   Phase #: 5      Files: 5     Time: 46s

  • TiemZone upgrade. The time zone upgrade before was a set of 10 steps or so, now its much simpler, just to scripts to run
DST_prepare.sql
DST_adjust.sql

 

The Oracle 12c upgrade workshop virtual environment

The great option for those who want to get into 12c upgrade as fast as possible is to look at Oracle provided virtual box environment with pre-configured linux os and 11g and 12c installations.

The virtual machine could be obtained from

http://www.oracle.com/technetwork/community/developer-vm/vts-hol-2415742.html

There are 8 zip files with total size of 15GB required to be downloaded from the internet.

You must have 30GB free space to store and unzip them, and  about 75GB of storage for virtual machine disks.

The 4 tasks could be performed here:

  1. Upgrade the 11g into 12c using common approach of running new perl script
  2. Using transportable databases to migrate to 12c
  3. Moving the database between homes
  4. Explore 12c and its new features

upgrade_workshop

Thanks to Roy Swonger and Mike Dietrich from Oracle for a great work!

Installing oracle 11g: ld-linux.so.2: bad ELF interpreter

Installing the oracle database software could bring you the following error:

./runInstaller: /u01/insta/database/install/.oui: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

Which indicates that 32bit version of libs are missing. At least two possible reasons for that, some 32 bit libs are really missing and we could start digging into the cause or ask your self a question, what we are trying to achieve here? Are we trying to install 32bit software on 64bit linux by mistake?

The 64bit software distribution will have 64 in the name of the zip, like:

p10404530_112030_Linux-x86-64_3of7

If there is NO 64 in the naming, then most likely you are installing 32 bit on 64 bit linux.

12c HR examples schema download

Even if you want just HR schema then  you need to download examples distribution about 800MB. Then you have to unzip it on the server and install using GUI to the oracle home into demo directory , this will consume some space and will contain bunch of other schemas too. Only after that its possible to deploy HR schema.

This process is cumbersome and time consuming if only HR schema is required. For convenience, I zipped just the HR scripts (17KB) and this could be obtained from here. To install run hr_main as usual.

note: by downloading you accept the oracle examples terms and conditions, scripts obtained this way are not supported, proceed on you own risk