oracle 11g upgrade in AIX 6.1 with HACMP

[Former Member]

Hi Friends,

As i have two Power Servers running in AIX 6.1 with oracle 10g in HACMP in which SAP application is running.

The one is standalone Database and other is central Instance.

I have done the 11g upgrades successfully in my DEV and QAS servers which are non-cluster Environment.

Now i want to do the same upgrade in PRD which is in HACMP.

Please let me know what are the areas should i concentrate specially for cluster environment servers.

Thanks,

Hari

[sandeep_kumar60]

HI Hari

We r in process of oracle upgrade to 11.2, we r using 10.2.0.4 with sap ECC system and AIX 6.1

Could you please provide some basi steps to how toproceed for the Upgrading oracle db.

iam completely new to thi sarea, could you please guide how to proceed further

Regards

[Former Member]

Hello all together,

there is a SAP Note linking to all relevant documentation you need: 1379340.

There are three major things:

1) to make the solutions work you have to install your oracle with a virtual hostname, not the hostname of the LPAR.

2) You have to evaluate if you can use the Product Smart Assist comming from PowerHA 7.1 onwards on no charge and get full product support for the scripts on top out of one hand. The other solution IBM provides is a Summary of "Best Practices" you are free to use, but without any support.

3) How to splitup the mountpoints into the diffrernt volumes wii depend on the solution you are using. The documentation will come along for whatever solution you shoot for.

Best Regards,

Katharina

[former_member185954]

Hello Hari,

Speak to your UNIX guys (if you are unsure) as to which filesystems are included in the HACMP cluster.

Identify which directories would be needed to be manually synced.

Filesystems such as the following exists locally in a typical HACMP cluster:

/etc

/home

Hence you will need to manually sync user environments for ora<sid> and <sid>adm (as described by Bhavik earlier), as well as key files such as /etc/oratab, /etc/oraInst.loc

Hope that helps.

Regards,

Siddhesh

[former_member524429]

Hi Hari,

The Procedure for Database Upgrade will be same in Clustered environment unless DB is installed with RAC/ASM.

You need to refer official Upgrade Guide Upgrade to Oracle Database 11g Release 2 (11.2): UNIX  step by step to perform Oracle Upgrade. As a part of Post Upgradation steps , you will required to sent some required environment variables for ora<sid> user.

--

Regards,

Bhavik G. shroff