10.2.0.1.0 to 10.2.0.4.0 Upgrade
su - oracle
unzip p6810189_10204_Linux-x86 on node 1.
Note: First need to upgrade Cluster .
Stop all RAC Services
Upgrade CRS from 10.2.0.1.0 to 10.2.0.4.0
Database Name: devdb
Instances: devdb1 Node name: rac1
Instances: devdb2 Node name: rac2
Oracle Database Home and ASM Home: /u01/app/oracle/product/10.2.0/db1
Oracle CRS Home: /u01/app/oracle/product/10.2.0/crs
./crsctl query crs activeversion
./crsctl query crs softwareversion
Will Upgrade firt Node 1 and Next Node 2.
Node 1
stop Services instance,asm,nodeapps
./crsctl check crs
./crs_stat -t
[oracle@rac1 bin]$ ./crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.1.0]
[oracle@rac1 bin]$ ./crsctl query crs softwareversion
CRS software version on node [rac1] is [10.2.0.1.0]
[oracle@rac1 bin]$ srvctl status asm -n rac1
ASM instance +ASM1 is running on node rac1.
[oracle@rac1 bin]$ srvctl status asm -n rac2
ASM instance +ASM2 is running on node rac2.
[oracle@rac1 bin]$ srvctl stop instance -d devdb -i devdb1
[oracle@rac1 bin]$ srvctl stop asm -n rac1
[oracle@rac1 bin]$ srvctl stop nodeapps -n rac1
[oracle@rac1 bin]$ ./crs_stat -t
Unzip the patch 6810189 and run the runInstaller from the unzipped directory.
Select the 10g CRS HOME path that needs to be upgraded
Script 1: Shutdown the CRS daemons :
root@rac1 ~]# /u01/app/oracle/product/10.2.0/crs/bin/crsctlstop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Script 2 : Run the shell script located at :
/u01/app/oracle/product/10.2.0/crs/install/root102.sh
login to Node 2
Follow same steps as for Node 2
/u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
/u01/app/oracle/product/10.2.0/crs/install/root102.sh
[oracle@rac1 ~]$ srvctl stop database -d devdb
[oracle@rac1 ~]$ srvctl stop asm -n rac1
[oracle@rac2 ~]$ srvctl stop asm -n rac2
[oracle@rac1 ~]$ srvctl stop nodeapps -n rac1
[oracle@rac2 ~]$ srvctl stop nodeapps -n rac2
Run the runInstaller - Select db_1 home path
[root@rac1 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
[root@rac2 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Now start
[oracle@rac1 ~]$ srvctl start nodeapps -n rac1
[oracle@rac2 ~]$ srvctl start nodeapps -n rac2
[oracle@rac1 ~]$ srvctl start asm -n rac1
[oracle@rac2 ~]$ srvctl start asm -n rac2
Database Upgrade.
Node 1
export ORACLE_SID=devdb1
sqlplus / as sysdba
SQL> startup nomount
SQL> create pfile from spfile;
SQL> shut immediate
vi /u01/initdevdb1.ora
#REMOVE THESE PARAMETERS#
#*.cluster_database_instances=2
#*.cluster_database=true
#srprim2.instance_number=2
#srprim1.instance_number=1
:wq!
sqlplus / as sysdba
SQL> startup upgrade pfile='$ORACLE_HOME/dbs/initdevdb1.ora';
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
SQL> select status,instance_name from v$instance;
SQL> shut immediate
sqlplus / as sysdba
SQL> startup pfile='$ORACLE_HOME/dbs/initdevdb1.ora';
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql
SQL> shut immediate
SQL> startup
SQL> select status,instance_name from v$instance;
SQL> select * from v$version;
srvctl status database -d devdb
srvctl start instance -d devdb -i devdb2