Thursday, December 18, 2014

Grid Infrastructure 12c Patch/Upgrade from 12.1.0.1 to 12.1.0.2

In this post, I will be demonstrating the steps to upgrade/patch the Grid Infrastructure (GI) 12.1.0.1 to 12.1.0.2. Since ASM runs from GI home, ASM would be upgraded while upgrade of GI home. As we know that Oracle now provides full installation binaries for patchset releases so the binaries are required to be downloaded from MOS. You would need to download Patch
17694377 disk 3 and 4. This upgrade was done on Oracle Linux 6 (x86-64) on running on Oracle Virtual Box. There is a 12.1.0.1 (cdb) database and an 11.2.0.4 (db11g) database running on this host having files on ASM.

You may like to visit here to view patch/upgrade guide for Oracle RDBMS version 12.1.0.1 to 12.1.0.2

Steps are as follows
You should log in as Grid Infrastructure software owner to perform this installation. Stop the databases (db11g) which depends on GI (ASM). Stop all databases (2 in this example) which depend on GI.
$srvctl stop database –d cdb
$
/u02/oracle/11.2.4/db_1/bin/srvctl stop database -d db11g

Initiate the installer from unzipped 12.1.0.2 GI software downloaded from MOS with patch number 17694377 (Disk 3,4)

First of all, you should unset ORACLE_HOME and ORACLE_BASE environment variables as these would be set automatically during the installation

$unset ORACLE_BASE
$unset ORACLE_HOME
$./runInstaller 
Select 3rd option for upgrade and Click Next





























Click Next




























Click Next




























Click Next




























Provide path for Oracle Base and Oracle Home and click Next




























Click Next




























In my case, installer returned me Warning/Fail for a couple of prerequisites for which I clicked “Fix and Check Again” button – which actually created a script (/tmp/…/runfixup.sh) which was required to be executed as user root to fix the warnings, which I did.




























Click “Install”




























Open a terminal and log in as user “root” and execute the script as instructed by the installer.

























Output of script is as follows
[root@salman1 ~]# /u02/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=  /u02/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: /u02/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 salman1 successfully pinned.
CRS-4123: Oracle High Availability Services has been started.

2014/12/08 15:21:22 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.conf'

2014/12/08 15:22:12 CLSRSC-482: Running command: 'upgrade model  -s 12.1.0.1.0 -d 12.1.0.2.0 -p first'

2014/12/08 15:22:20 CLSRSC-482: Running command: 'upgrade model  -s 12.1.0.1.0 -d 12.1.0.2.0 -p last'


salman1     2014/12/08 15:22:21     /u02/app/grid/product/12.1.0/grid/cdata/salman1/backup_20141208_152221.olr     0

salman1     2014/02/28 16:28:31     /u01/grid/11.2.0/grid_1/cdata/salman1/backup_20140228_162831.olr     -
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'salman1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'salman1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'salman1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'salman1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'salman1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'salman1'
CRS-2677: Stop of 'ora.asm' on 'salman1' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'salman1'
CRS-2677: Stop of 'ora.evmd' on 'salman1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'salman1'
CRS-2677: Stop of 'ora.cssd' on 'salman1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'salman1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2014/12/08 15:31:01 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

Installation is finish, Click Close




























Edit .bash_profile file and set values of all environment variables according to new 12.1.0.2 oracle home. During installation, all GI services were upgraded and not running from the new home. Old GI installation 12.1.0.1 can be removed now using "deinstall".


Related Articles

No comments:

Popular Posts - All Times