Rolling upgrade to 10.2.0.4.3 on Oracle Solaris is not possible ?
- From: "Pankaj Jain" <pjain@xxxxxxxxxx>
- To: "Pankaj Jain" <pjain@xxxxxxxxxx>, <kjped1313@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>, <niall.litchfield@xxxxxxxxx>
- Date: Tue, 13 Apr 2010 16:51:43 -0400
I have tried many iterations to upgrade my RAC environment 10.2.0.4 to
10.2.0.4.3, it seems that the upgrade is not possible with a downtime.
Now oracle also has bugs in there documents :)
Patch 9119284 - 10.2.0.4.3 Patch Set Update
This step 3 in the above document is not possible without bringing all
the nodes down. Does anybody knows any work-around for this.
Readme of Patch 9119284
"
If the database is in a RAC environment, run the view recompilation
script as follows. Note that this script is run with the database in
upgrade mode, which restricts connections as SYSDBA. Stop all instances
except the one where the view recompilation is being executed.
3
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>
"
Thanks & regards,
Pankaj Jain
10 Second Avenue, Burlington, MA 01803
Work (781) 505-7925 Cell (978) 987-0004 Fax (781) 505-7382,
Email: pjain@xxxxxxxxxx <blocked::mailto:pjain@xxxxxxxxxx> ;
9789870004@xxxxxxxxx <mailto:9789870004@xxxxxxxxx>
Simplicity is approaching life's complications with a clear and balanced
mind, that is free from desires.
Other related posts:
