Link to home
Start Free TrialLog in
Avatar of BABU123
BABU123

asked on

Patching on Oracle RAC

Hello

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

thanks
Babu
ASKER CERTIFIED SOLUTION
Avatar of k_murli_krishna
k_murli_krishna
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BABU123
BABU123

ASKER

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BABU123

ASKER

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BABU123

ASKER

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial