Clusterware and ASM upgrade (GI Upgrade) – Bits & Pieces

 

Upgrade from old (11.1, or 10G) to 11gR2

The upgrade to Oracle Clusterware 11gR2 will be an out of place upgrade hence a new CRS_HOME including ASM will be created which will be referred as the new GRID_Infrastructure home. If an existing ASM_HOME is present in 10gR1/10gR2 or 11gR1 then ASM will be upgraded automatically as well.

SQL> startup upgrade

SQL> @catupgrd.sql

SQL> startup

SQL> @utlu112s.sql
SQL> @catuppst.sql

SQL> SELECT count(*) FROM dba_invalid_objects;
SQL> SELECT distinct object_name FROM dba_invalid_objects;

SQL> @utlrp.sql

srvctl upgrade database -d db-unique-name -o oraclehome

ocrconfig -upgrade

# GRID_Home/rootupgrade.sh
(to be run from all nodes)

 

You can refer to below for more details :

http://askdba.org/weblog/2010/10/upgrading-grid-infrastructure-11201-to-11202-on-rhel4/

Oracle Clusterware (CRS or GI) Rolling Upgrades (Doc ID 338706.1)

Advertisements

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