BABU123
asked on
Patching on Oracle RAC
Hello
Could you please provide how to perform a patching on Oracle RAC enviroment
thanks
Babu
Could you please provide how to perform a patching on Oracle RAC enviroment
thanks
Babu
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
"+ 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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_reco mpile
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
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>.
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_reco
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> 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER