Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Patching on Oracle RAC

Posted on 2010-01-11
7
Medium Priority
?
885 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
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

578 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