Home > Oracle Rac > 11g ASM rolling upgrade from 11.1.0.6 to 11.1.0.7

11g ASM rolling upgrade from 11.1.0.6 to 11.1.0.7

In Oracle 11g, we can now do rolling upgrades of the ASM instanaces in a RAC cluster configuration. In this example shown below, one of the ASM instances is being upgraded to 11.1.0.7 while the other instance is still running on version 11.1.0.6. While the ASM software is being upgraded, client connections to the RAC database will continue as the service will get relocated to the other node in the cluster which is not being currently upgraded. So in other words this is an online patch application.

On one of the nodes in the cluster, connect to the ASM instance (+ASM1) and issue the command to start the rolling migration.

SQL> alter system start rolling migration to '11.1.0.7'

System altered.

Stop the database instance testrac1, shutdown the ASM instance +ASM1 and
then stop the listener which is running from the ASM home which will now be upgraded to 11.1.0.7.


[oracle@nesdbts01]$ srvctl stop instance -d testrac -i testrac1

[oracle@nesdbts01]$ sqlplus sys as sysasm

SQL*Plus: Release 11.1.0.7.0 - Production on Mar 29 09:44:46 2010

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

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> shutdown immediate;

ASM diskgroups dismounted

ASM instance shutdown

SQL> quit

[oracle@nesdbts01] lsnrctl stop LISTENER_TESTRAC1

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-MAR-2010 14:53:50

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nesdbts02-p.ncs.local)(PORT=50235)))

The command completed successfully

The service running on TESTRAC1 will be relocated to the other surviving on node TESTRAC2


[oracle@nesdbts01]  sqlplus olasadm/*******@testrac1
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Dec 11 09:11:44 2009

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> select count(*) from tedran;

  COUNT(*)

----------

    92888388

SQL> select host_name from v$instance;

HOST_NAME

----------------------------------------------------------------
 Nesdbts01


********ASM and Database Instance is shutdown here ****************

SQL> /

HOST_NAME

----------------------------------------------------------------
 Nesdbts02
SQL> select count (*) from tedtran;

  COUNT(*)

----------

    92888388

When installing the 11.1.0.7 patch , only one node in the cluster must be selected where the patch will be applied, the other node in the cluster is where the 11.1.0.6 ASM and Database instance is running and where all the client connection are being hosted

Run the 11.1.0.7 patch.

Once completed, we should start the listener, the upgraded ASM instance and the database instance.


[oracle@nesdbts01]$ lsnrctl start LISTENER_TESTRAC1

[oracle@nesdbts01]$  sqlplus sys as sysasm

SQL*Plus:  Release 11.1.0.7.0  - Production on Mar 29 10:44:46 2010

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

Enter password:

Connected to an idle instance.

SQL> startup

ASM instance started

Total System Global Area  283930624 bytes

Fixed Size                  2153056 bytes

Variable Size             256611744 bytes

ASM Cache                  25165824 bytes

ASM diskgroups mounted

[oracle@nesdbts01] srvctl start instance -d testrac -i testrac1

We will now repeat all the same steps on the other node middba2. After the 11.1.0.7 patch has been applied to all the ASM Oracle Home’s we will see a message indicating that we now can turn off the ASM rolling upgrade.

Note: while the ASM in in ‘rolling upgrade’ mode, a limited number of ASM operations can be performed and certain ASM operations like rebalancing cannot be carried out.

SQL> alter system stop rolling migration;

System altered.

We can finally relocate the service back to its original node - nesdbts01

[oracle@nesdbts01]  srvctl relocate service -d testrac -s testrac1_service  -i testrac2 -t testrac1 -f
[oracle@nesdbts01]  srvctl status service -d testrac -s testrac1_service
 

Service testrac1_service is running on instance(s) testrac1

Advertisements
Categories: Oracle Rac
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

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

%d bloggers like this: