?
Solved

Patching on Oracle RAC

Posted on 2010-01-11
7
Medium Priority
?
875 Views
Last Modified: 2013-12-18
Hello

Could you please provide how to perform a patching on Oracle RAC enviroment

thanks
Babu
0
Comment
Question by:BABU123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 17

Accepted Solution

by:
k_murli_krishna earned 2000 total points
ID: 26284601
Delete duplicate question http://www.experts-exchange.com/Database/Oracle/10.x/Q_25044503.html.

An Oracle Real Application Clusters (RAC) environment is one in which active instances can concurrently execute transactions on a shared database. Patching in an Oracle (RAC) environment is slightly different compared to patching a single node.
Real Application Clusters can be patched in three different ways:
All Node Patching
Rolling Patching
Minimum Downtime Patching

For complete details, refer:
Managing Oracle Software and Applying Patches
http://download.oracle.com/docs/cd/B28359_01/rac.111/b28252/softpatch.htm
Patching Oracle RAC
http://download.oracle.com/docs/cd/B16240_01/doc/doc.102/e14500/pat_rac.htm
Oracle Real Application Clusters Patching
http://download.oracle.com/docs/cd/B16240_01/doc/doc.102/e15294/rac.htm
0
 

Author Comment

by:BABU123
ID: 26590972
Thanks...I am new DBA and I'd really appreciate if you can provide the DETAILED steps  for appying the January Patch on Oracle RAC 10G on AIX environment.
0
 
LVL 17

Assisted Solution

by:k_murli_krishna
k_murli_krishna earned 2000 total points
ID: 26593693
This link will tell you all apart from steps. Just go through carefully.
http://home.fnal.gov/~dbox/minos/oracle_patch_README.html

This one is even better. Just download word doc.
http://shaiksameer.googlepages.com/Oracle10203RAC.doc

Refer this also by searching for keyword patch in case you get stuck in above 2.
http://www.stanford.edu/dept/itss/docs/oracle/10gR2/relnotes.102/b19074.pdf
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:BABU123
ID: 26852984
I was going throught the README for the January 2010 CPU.. I see the following

"+ If you are patching an ASM instance, shut down all Oracle Database instances that use this ASM instance. (To see which Oracle Database instances are connected to this ASM instance, query the V$ASM_CLIENT view.)"

What does it mean. Does it mean that we need to apply the path for ASM home also?

I thought we apply the patch only to $ORACLE_HOME..

Any expalanation is greatly appreciated.

Thanks
0
 
LVL 17

Assisted Solution

by:k_murli_krishna
k_murli_krishna earned 2000 total points
ID: 26853344
It means that if you are using ASM then whether single instance in a standalone database in normal Oracle server OR multiple instances in a cluster (RAC), they all need to be shutdown to apply the patch.

There is a choice on what the DBA decides i.e. which instances in RAC will be ASM ones, hence, query the V$ASM_CLIENT view to find out ASM managed instances which need to be shutdown.

After shutting down all such ASM instances, you can apply the patch to $ORACLE_HOME.
0
 

Author Comment

by:BABU123
ID: 26856458
Thanks Murali..I didn't find any JAN2010 CPU for ASM..So I don't need to worry about ASM   apart from shutting down patch application to the Instance.

I am trying to apply PS 9119284 on AIX 64 bit power systems

Since JAN2010 CPU is rolling patch I don't need to shutdown the database.. right..So for as Patch apply is concerned
Installation:
1. srvctl stop nodeapps -n nodename - Which will shutdown all serivces including listeners etc..
2. srvctl stop instance on this node

su - oracle
mkdir cpujan2010
download the 9119284 patch here
unzip p9119284_10204_<platform>.zip
cd 9119284
opatch apply

Post Installation:
srvctl start instance

cd $ORACLE_HOME/rdbms/admin

 sqlplus '/ as sysdba';

SQL> @catbundle.sql psu apply

cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP NOMOUNT
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
SQL> @view_recompile_jan2008cpu.sql
SQL> SHUTDOWN;
SQL> STARTUP NOMOUNT;

Set the CLUSTER_DATABASE initialization parameter to TRUE:

SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;

Restart the database:

SQL> QUIT
cd $CRS_HOME/bin
srvctl start database -d <database-name>


Please review the README and correct me if I am wrong....I greatly appreciate your diligence in going through it
0
 
LVL 17

Assisted Solution

by:k_murli_krishna
k_murli_krishna earned 2000 total points
ID: 26857218
Looks fine. make sure you do not miss a single step from README. Even if you are stuck, do not try to jump to next step. Finish the current one or UNDO what all you have done and REDO again. Please do not miss any step/instruction.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question