eMarcel.com

Oracle Database, Fusion Middleware, Linux

Upgrade Oracle Database 12c with ASM 12.1.0.1 to 12.1.0.2

db12c_logoIn 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:

  1. Download software packages from Oracle eDelivery.
  2. Upgrade Oracle Grid Infrastructure 12c R1 to version 12.1.0.2.0
  3. Install software and upgrade Oracle Database 12c R1 to version 12.1.0.2.0
  4. Configure database listener – netca
  5. Post-Upgrade steps

1. Downloading Oracle Grid Infrastructure and Oracle Database 12c software

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
[[email protected] ~]# /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

[[email protected] ~]#

 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.

Oracle Database 12c In-Memory How To Get Started >>

(Visited 1,387 times, 1 visits today)

, , , ,

0 Shares
Tweet
Share
+1
Share

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close