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.
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.
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
$ /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
$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
- Upgrade Grid Infrastructure 11g to 12c
- Upgrade/Patch Oracle Database 12.1.0.1 to 12.1.0.2
- Upgrading Oracle Database 11g to 12c
No comments:
Post a Comment