Borndba

We have 2 node cluster running in 11gR1 crs and asm. We have a requirement to upgrade to 11gR2 grid infrastrcuture. As we know grid infrastructure is one home for crs and asm unlike 11gR1. Also in case of upgrade if the crs and asm of 11gR1 was installed in oracle account, you can install the new grid infrastructure only on oracle account.  Where as for new install you can have grid infrastructure in grid account and your DBs in oracle accounts.

What we tried is a rolling upgrade, since the steps are not clear we didn’t actually test the application after upgrading one node. But guess what outlined here will give you a clue and may help you to do rolling upgrade.

There are totalling 7 zip files for linux, download to a folder and unzip each one of it. At the end of unzip you will have folder like grid,database,client etc.,

grid folder will have installables for grid infrastrucutre,

set the display and run the runInstaller. Some reason our environment we used  -ignoreInternaldriver flag with runInstaller.

skip the software updates,

Select the ‘Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management”

Though you select one node, software will be pushed to all the nodes in that cluster. You can choose to run rootupgrade.sh or not later. Since you selected one node asm upgrade has to be done manually.

Next screen will ask for scan ip info and the port. Port give which ever required.

Make sure everything it is oinstall group  or whatever relevant in your environment.

Next

 

Next

 Next you will get the summary tab. If everything fine select Next click ‘Install’.

End of this it will ask to run rootupgrade.sh. You can run one node at a time. At the end of ‘rootupgrade.sh’ it will bring the crs in new home and ASM with older version. Pls node only if you run rootupgrade.sh the asm will come up.

“Configuration assistants have not been executed by the installer, since only a subset of nodes was selected for the upgrade. Run rootupgrade.sh on the rest of the nodes and then proceed to execute the configuration assistants.

“/u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands” script contains all commands that the configuration assistants will complete. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before you can run the script.”

Note you will have run rootupgrade.sh in all the node and comeback and run “/u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands”. This is because you have selected only one node during the upgrade. configToolAllCommands is a script which call runconfig.sh

Set the environment variable to new grid infrastructure and start the asmca for upgrading the +asm. If you have specified asmca_rolling_upgrade=true, it will upgrade asm in each node in rolling fashion.

This is the stage we are not sure what to do. We ran the rootupgrade.sh in both the node and started asmca with asmca_rolling_upgrade=true. asmca_rolling_upgrade needs to be set as environment variable. When you set this environment variable, it does the asm upgrade in both the node.

I belive after rootupgrade.sh and asmca on one node could have brought the application up on one node.

When you set the environment variable pointing to new grid and run asmca from $ORACLE_HOME/bin/asmca you will see the screen like below.

convert this post to pdf.

You don’t need tns or ldap entry to connect to your db from your desktop. 10g uses service name and 11g uses sid.

C:\Documents and Settings>tnsping hostname:1141/emrep

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 – Production on 24-FEB-2

011 18:42:59

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

c:\tns\sqlnet.ora

Used EZCONNECT adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=emrep))(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxx)(PORT=1141)))

OK (440 msec)

C:\Documents and Settings\>sqlplus dbsnmp/*******@hostname:1141/emrep

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 24 18:44:30 2011

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine

and Real Application Testing options

SQL> select host_name from v$instance;

HOST_NAME

—————————————————————-

hostname

SQL> show parameter db_name

NAME TYPE

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

VALUE

——————————

db_name string

emrep

to work you need below entry in your sqlnet.ora,

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

convert this post to pdf.