GI (Oracle Restart) Upgrade from 11.2.0.1 to 11.2.0.3

Recently I have upgraded Single node GI (Oracle Restart) from 11.2.0.1.0 to 11.2.0.3.0 and thought to share with you. Though it’s not something very interesting to share yet not that bad at all.J

In this blog I’ll use GI or Grid Infrastructure, which is also Oracle Restart in our case. Here are details of GI (Oracle Restart):

Grid Infra Version: 11.2.0.1.0

Grid Home: /u01/app/oracle/product/11.2.0/grid

Host Name: mask11g

Storage: ASM

DB Version: 11.2.0.1.0

Purpose: Upgrade GI from 11.2.0.1.0 to 11.2.0.3.0

Path for upgrade: Out of place (New location on same server) followed by removal of old GI home.

Going forward from 11gR2 oracle recommend to go with out of place upgrade though in place upgrade is still available. I tried both and both are almost similar except the few minor things. In place upgrade enables you to upgrade an existing installation of GI into the same directory by replacing the existing installation files. The patch set application requires more downtime and is not recommended. This upgrade type requires less disk space.

For out of place upgrade we need almost 5 GB extra space during upgrade and we would be able to release space by removing the old grid software.

In order to make it easily understandable as a step by step approach I am attaching snapshots of upgrade process.

Software is available on MOS with patch number 10404530 and could be easily downloadable. This patch contains total 7 files but we need only p10404530_112030_platform_3of7.zip (933 MB) to complete GI upgrade. This patch is actually full release so it could be used to perform new installation as well as upgrade from old versions.

I would suggest you to read the instructions from all aspects before you test the upgrade on your environment. I couldn’t share more details or else this blog looks like upgrade companion doc J.

  1. Download and unzip the p10404530_112030_platform_3of7.zip into staging location on your server.
  2. Take backup of existing environment
  3. Upgrade the GI software
  4. Once upgrade is done then you could remove the old GI installation as it’s of no use or could leave it as it is in case you have plenty of space on your server.

cd <location of grid software>

./runInstaller

Opt for “Skip Software Update” and click on “Next”

Opt for “Upgrade oracle Grid Infrastructure or Oracle Automatic Storage Management” and click on “Next”

Click on “Next”

Use appropriate roles as per your environment. I used dba & oper. Oracle recommends Job role separation by different roles.

As I am not using recommended groups so I have to ignore the warnings J.

Initially OUI picked existing home

But as soon as it detected that this location is already containing software it raised warning.

So I have decided to go back and change the path

Time for prerequisite checks

Shmmni & semmni sessions are not as per required value so OUI raised warnings.

Click on “Fix and check again”

It suggested to execute runfixup.sh as root

[root@mask11g ~]# /tmp/CVU_11.2.0.3.0_oracle/runfixup.sh

Response file being used is :/tmp/CVU_11.2.0.3.0_oracle/fixup.response

Enable file being used is :/tmp/CVU_11.2.0.3.0_oracle/fixup.enable

Log file location: /tmp/CVU_11.2.0.3.0_oracle/orarun.log

Setting Kernel Parameters…

The value for shmmni in response file is not greater than value of shmmni for current session. Hence not changing it.

The value for semmni in response file is not greater than value of semmni for current session. Hence not changing it.

Now come back to OUI and Click OK

Summary screen, click on “Install”

Execute rootugrade.sh script as root user.

Here we hit one bug and it seems session hanged

logs showing that following line is in progress.

Executing cmd: /bin/su oracle -c “/u01/app/oracle/product/11.2.0.3/grid/bin/asmca -silent -upgradeLocalASM”

Here is MOS doc

rootupgrade.sh Hangs During Upgrade of Standalone Grid Infrastructure From Lower 11gR2 to Higher 11gR2 (Doc ID 1446226.1)

1. Create ASMSNMP user in +ASM instance:
Startup +ASM in 11.2.0.2 GRID_HOME

SQL> create user asmsnmp identified by <password>;
SQL> grant sysdba to asmsnmp;

SQL>  select * from v$pwfile_users
Verify both SYS and ASMSNMP user show up
2. Copy orapw+ASM from 11.2.0.2 $GRID_HOME/dbs to 11.2.0.3 $GRID_HOME/dbs

3. Retry rootupgrade.sh

It completes successfully after above.

Note, this issue could also happen from 11.2.0.1 to 11.2.0.3 upgrade.

Here is o/p from our system.

[oracle@mask11g.lgk.nmk] srvctl start asm

idle> create user asmsnmp identified by asmsnmp;

create user asmsnmp identified by asmsnmp

*

ERROR at line 1:

ORA-01920: user name ‘ASMSNMP’ conflicts with another user or role name

idle> select * from v$pwfile_users

2 ;

USERNAME SYSDB SYSOP SYSAS

—————————— —– —– —–

SYS TRUE TRUE TRUE

ASMSNMP TRUE FALSE FALSE

In our case actually issue was something else. We can see that ASMSNMP is not having SYSASM privilege. So just need to grant that.

idle> grant sysasm to ASMSNMP;

Grant succeeded.

idle> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

—————————— —– —– —–

SYS TRUE TRUE TRUE

ASMSNMP TRUE FALSE TRUE

idle>

[oracle@mask11g.lgk.nmk] cp -p /u01/app/oracle/product/11.2.0/grid/dbs/orapw+ASM /u01/app/oracle/product/11.2.0.3/grid/dbs/.

Leave the ASM instance running from old grid home. Rerun /u01/app/oracle/product/11.2.0.3/grid/rootupgrade.sh again from root user.

It completed successfully.

In our case rootupgrade.sh script was not able to start ASM instance and prompting for password in background which we were not able to notice. After granting SYSASM privilege to ASMSNMP user password file got updated and we copied that file into new grid home to allow access and it resolved the issue.

Now come to OUI screen and click “OK”

Oracle will do configuration of standalone GI.

And finally confirmation of sucessful upgrade.

At this stage if we check the oratab then we could see update for +ASM.

Let’s check version of GI

[oracle@mask11g.lgk.nmk] crsctl query has releaseversion

Oracle High Availability Services release version on the local node is [11.2.0.3.0]

[oracle@mask11g.lgk.nmk] crsctl query has softwareversion

Oracle High Availability Services version on the local node is [11.2.0.3.0]

Now proceed with removal of the old home (optional)

Detach Old Grid Home from Central Inventory

[oracle@mask11g grid]$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/grid

[oracle@mask11g grid]$ /u01/app/oracle/product/11.2.0/grid/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid

Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 3999 MB Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/app/oraInventory

‘DetachHome’ was successful.

Verify that old grid home has no link with central inventory

[oracle@mask11g grid]$ /u01/app/oracle/product/11.2.0/grid/OPatch/opatch lsinventory -all

Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6

Copyright (c) 2009, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0/grid

Central Inventory : /u01/app/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.1.0.6.6

OUI version : 11.2.0.1.0

OUI location : /u01/app/oracle/product/11.2.0/grid/oui

Log file location : /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2013-02-15_20-53-18PM.log

Patch history file: /u01/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

List of Homes on this system:

Home name= OraDb11g_home1, Location= “/u01/app/oracle/product/11.2.0/dbhome_1”

Home name= Ora11g_gridinfrahome2, Location= “/u01/app/oracle/product/11.2.0.3/grid”

Inventory load failed… OPatch cannot load inventory for the given Oracle Home.

Possible causes are:

Oracle Home dir. path does not exist in Central Inventory

Oracle Home is a symbolic link

Oracle Home inventory is corrupted

LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

Remove the folder including unlink software as root user.

[root@mask11g ~]# rm -rf /u01/app/oracle/product/11.2.0/grid

Finally our GPnP single node is on 11.2.0.3

References:

How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete (Doc ID 1346305.1)

rootupgrade.sh Hangs During Upgrade of Standalone Grid Infrastructure From Lower 11gR2 to Higher 11gR2 (Doc ID 1446226.1)


Advertisements

4 Responses to GI (Oracle Restart) Upgrade from 11.2.0.1 to 11.2.0.3

  1. Om Virkud says:

    Hi Amit,

    we are planning to upgrade GI (Oracle Restart) from 11.2.0.1 to 11.2.0.3. My question is that

    1] Do we need to apply pre-patch before upgrading to 11.2.0.3 (i,e PATCH 9706490 if on AIX).

    Pls suggest

    • Hi Om

      I think its too late to respond to your comment. Still for any upgrade we must have apply some pre-requisites patches as well. Please open a ticket with Oracle support along with
      -> opatch lsinventory -detail from DB & GI (in case RAC)
      -> list of parameters (spfile or pfile)
      -> Alert log (optional, but it sometimes can give an options to look for parameters or any known/unknown issues going on with your DB).

      Regards,
      Amit S.

  2. excellent!!1 you saved me day 🙂

Share Your Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Pierre blog

Pierre Forstmann Oracle Database blog

flashdba

Oracle databases, storage and the high-performance world of flash memory

Future Veterans

Ramblings about Oracle

Ranjeet Srivastava

Smile! You’re at the best blog ever

Kevin Closson's Blog: Platforms, Databases and Storage

Platform, Database and Storage Topics

Real Life Database / SQL Experiences : An Oracle Blog from Vivek Sharma

Being an Oracle Professional, I like to share all my Real Life Performance Tuning Challenges and Experiences. The Content and Views on this site are my own and not necessarily those of Oracle. While, I write on my real life experiences, the resolutions mentioned are solely mine. Comments / Criticisms are always a welcome.

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

OraStory

Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design ... (Now with added Sets Appeal)

ASM Support Guy

Just Another Crazy Oracle DBA

Exadata Certification

Just Another Crazy Oracle DBA

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Sangram keshari's Oracle Blog

The Fusion Middleware Administration & Database Administration Blog

Amit Saraswat

Just Another Crazy Oracle DBA

Oracle Scratchpad

Just another Oracle weblog

The Tom Kyte Blog

Just Another Crazy Oracle DBA

Hemant's Oracle DBA Blog

Just Another Crazy Oracle DBA

Uwe Hesse

about Database Technology

Richard Foote's Oracle Blog

Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music

%d bloggers like this: