Upgrade Oracle Database 12c with ASM 12.1.0.1 to 12.1.0.2
In previous tutorial of this topic, we covered installation of Oracle Database 12c R1 on Linux 6 with ASM version 12.1.0.1.0. Now it’s the time to upgrade our database to version 12.1.0.2.0 which introduces long awaited “In-Memory Aggregation” and “In-Memory Column store” features. There is obviously much more – full description of Oracle Database 12c R1 (12.1.0.2) New Features can be found here. Readme Information for Oracle Database 12c Release 1 (12.1.0.2) available here.
Upgrade plan:
- Download software packages from Oracle eDelivery.
- Upgrade Oracle Grid Infrastructure 12c R1 to version 12.1.0.2.0
- Install software and upgrade Oracle Database 12c R1 to version 12.1.0.2.0
- Configure database listener – netca
- Post-Upgrade steps
1. Downloading Oracle Grid Infrastructure and Oracle Database 12c software
- Get the software packages from Oracle Software Delivery Cloud
- You may download Oracle software also from OTN websites (Development only)
2. Upgrade Oracle Grid Infrastructure 12c R1 to version 12.1.0.2
Unzip Oracle Database 12c Release 1 Grid Infrastructure (12.1.0.2.0) Part 1 and 2 installation packages into the same directory and run Oracle Universal Installer:
- Output from rootupgrade.sh script
[root@zeus ~]# /u01/app/grid/product/12.1.0/grid/rootupgrade.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/grid/product/12.1.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/product/12.1.0/grid/crs/install/crsconfig_params
ASM Configuration upgraded successfully.
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node zeus successfully pinned.
CRS-4123: Oracle High Availability Services has been started.
2014/08/01 14:30:16 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.conf'
2014/08/01 14:31:01 CLSRSC-482: Running command: 'upgrade model -s 12.1.0.1.0 -d 12.1.0.2.0 -p first'
2014/08/01 14:31:08 CLSRSC-482: Running command: 'upgrade model -s 12.1.0.1.0 -d 12.1.0.2.0 -p last'
zeus 2014/08/01 14:31:08 /u01/app/grid/product/12.1.0/grid/cdata/zeus/backup_20140801_143108.olr 0
zeus 2014/03/12 23:46:51 /u01/app/12.1.0/grid/cdata/zeus/backup_20140312_234651.olr -
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zeus'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'zeus'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'zeus'
CRS-2677: Stop of 'ora.FRA.dg' on 'zeus' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'zeus'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'zeus'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'zeus'
CRS-2677: Stop of 'ora.CRS.dg' on 'zeus' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'zeus' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'zeus'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'zeus' succeeded
CRS-2677: Stop of 'ora.evmd' on 'zeus' succeeded
CRS-2677: Stop of 'ora.asm' on 'zeus' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'zeus'
CRS-2677: Stop of 'ora.cssd' on 'zeus' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zeus' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2014/08/01 14:32:27 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
[root@zeus ~]#
3. Install software and upgrade Oracle Database 12c R1 to version 12.1.0.2.0
Unzip Oracle Database 12c Release 1 (12.1.0.2.0) Part 1 and 2 installation packages into the same directory and run Oracle Universal Installer.
Note: We’re installing new database software version in new ORACLE_HOME directory.
ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1
We can’t forget to update /home/oracle/.bash_profile to reflect this change.
Oracle installer will also run Database Upgrade Assistant.
4. Configure database listener – netca
5. Post-upgrade steps
- Run the Post-Upgrade Status Tool (utlu121s.sql) to display a summary of
upgrade results - Review the log files generated during the upgrade
- Recompile invalid objects by running utlrp.sql
- Verify that objects recompiled cleanly by running utluiobj.sql
That’s it!
Next we will take a closer look at In-Memory option. Oracle claims that database response time is as much as 300 times faster when using these new features.
