Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Oracle upgrade on veritas cluster 5.1 SP1

Created: 06 May 2013 • Updated: 14 May 2013 | 3 comments
This issue has been solved. See solution.

Hi ,

 

We are planning to upgrade oracle from 10.2.0.4 to 11.2.0.3 on windows 2008 environment. We have SAP Portal Ehp1 for that uses this database.

both the SAP and oracle group are clustered with the VCS version 5.1 SP1 over 2 nodes.

Would like to know the process for upgrading the oracle in this clustered environment.

Do we need to install & upgrade only on one node or do it on both the nodes/

Kindly share relevant documentation for this purpose.

 

regards,

Sreek

Operating Systems:

Comments 3 CommentsJump to latest comment

mikebounds's picture

If the Oracle binaries are on shared storage then you just run the upgrade on one node (the one that has the binaries).  If the Oracle binaries are on local storage, then you need to run the upgrade on each node.

If their are any updates to the database as part of the upgrade, then these need to be run just once as there is only one shared database.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

sreek's picture

Hi Mike,

 

Thanks for the info.

The binaries are installed on local disks. That means I got to install on both nodes but run DBUA on 1 node.

Again, after the upgrade are there any tasks at cluster end like environment variables, services , update files to be done ?

Is there any documentation that I can refer to.

 

kindly revert.

 

regards,

Sreekanth

mikebounds's picture

Correct, install new binaires on both nodes and upgrade the database on one node.

For VCS, you will need to update anything that changes for the VCS Oracle and NetLsnr resources which is likely to be just "Home" attribute.  You may have to upgrade the agent itself if it does not support your new 11.2.0.3 version - you will need to check the agent doc for the version you have installed.

You should freeze the oracle service group while you are doing the upgrade.

I don't know of any docs for upgrading Oracle in VCS - I only found this in the UNIX agent guide, but the information is applicable to Windows too:

$ORACLE_HOME directory on local disks

You can install the Oracle Database Server
($ORACLE_HOME) on the local disk. The advantage
(over $ORACLE_HOME directory on shared disks) is that
you can upgrade the Oracle database binaries on an offline
node while the database server runs on another node. The
database server can later be switched to the upgraded node
(provided the database is compatible), permitting a minimum
amount of downtime.
The disadvantage of this approach is that with a large
number of nodes, it becomes difficult to maintain the various
Oracle installations.
 
Mike

 

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

SOLUTION