Upgrade Oracle 11.2.0.4 standalone Grid and ASM to Oracle 12.1.0.2

This Document describe the procedure to upgrade the Oracle 11.2.0.4 standalone Grid and ASM to Oracle 12.1.0.2 standalone Grid and ASM using OUI Oracle Universal Installer.
Starting from Oracle 11g , Oracle recommends out of place upgrades. means upgrade will happen in new ORACLE_HOME.

Prerequisites :-
1. Take a full Backup of Database and existing GRID_HOME.
2. Create new directory structure for the new GRID_HOME.
3. Copy the Oracle Grid 12c binaries at your choice location and unzip it.
4. unset the following before starting the upgrade.

  unset ORACLE_BASE
  unset ORACLE_HOME
  unset ORACLE_SID

In my testing environment i'm using Oracle user as owner of my GRID_HOME.

As Oracle user run installer.



Installation Option.
choose Upgrade Oracle Grid infrastructure or Oracle ASM

Select Language.

Management option provide option to register with Enterprise Manager to manage the Grid and ASM.

i'm using only DBA group. we can use different groups to separate the duties.

It will show the warning cause i'm using DBA group only.

Specify the new location of the ORACLE_BASE and ORACLE_HOME.

Click on Automatically run configuration scripts. it will prompt to provide the root password to execute the scripts by itself.

Due to limited resources on my laptop, i have allocated 2G memory in my virtual box. ignore this error. In real environment all prerequisites should met.
For OS Kernel Parameter panic_on_oops.

It will show warning cause i have ignored prerequisites. click on yes.

Review the summary. and click on install.

Review the progress.

New window will pop-up to confirm the execution of scripts as root. Click on yes.

Once the scripts executed. we can see the upgrade of GRID was successful window. click on close.

Verify the  release version and software version.

[oracle@oracle123 bin]$ ./crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [12.1.0.2.0]
[oracle@oracle123 bin]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.1.0.2.0]


Connect to the ASM instance and verify the version.

[oracle@oracle123 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 22 18:03:32 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> select * from v$version;

BANNER     CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production  0
PL/SQL Release 12.1.0.2.0 - Production  0
CORE 12.1.0.2.0 Production  0
TNS for Linux: Version 12.1.0.2.0 - Production  0
NLSRTL Version 12.1.0.2.0 - Production

Connect to ASM instance and change the Compatible parameter to enable new features.

alter diskgroup data set attribute 'compatible.asm'='12.1.0.2';
alter diskgroup fra set attribute 'compatible.asm'='12.1.0.2';

Verify the COMPATIBILITY.

SQL> select group_number, name, compatibility, database_compatibility from v$asm_diskgroup;

GROUP_NUMBER NAME    COMPATIBILITY            DATABASE_COMPATIBILITY
------------ ------------------------------ ------------------------------------------------------------ ------------------
  2 FRA    12.1.0.2.0      10.1.0.0.0
  1 DATA    12.1.0.2.0      10.1.0.0.0


Change the diagnostic_dest to new GRID_HOME

alter system set diagnostic_dest='/u02/app/grid' scope=spfile;

Once we find everything is working fine from new GRID_HOME. we can delete the old GRID_HOME.

Thanks.