Upgrade Oracle Database to 11.2.0.3 with a Physical Standby Database in place

1, On Primary database run preupgrade check:
SQL>@/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/utlu112i.sql;

2, On Standby database, copy following file from 11.2.0.2 home to 11.2.0.3 home on all nodes

$cp /u01/app/oracle/product/11.2.0.2/db_1/dbs/orapwRAC1 /u01/app/oracle/product/11.2.0.2/db_1/dbs/
$cp /u01/app/oracle/product/11.2.0.2/db_1/dbs/initRAC1.ora /u01/app/oracle/product/11.2.0.2/db_1/dbs/ 
$cp /u01/app/oracle/product/11.2.0.2/db_1/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0.2/db_1/ntwork/admin

3, Disable data guard broker:

DGMGRL> disable configuration;

4, Stop broker on both Primary and standby:

SQL> alter system set dg_broker_start=false scope=Both;

5, Stop primary database

6, Stop standby database

7, Mount standby database in new 11.2.0.3 home and start redo apply

SQL> startup mount
SQL> alter database recover managed standby database using current logfile disconnect from session;


8, Edit /etc/oratab to point to new oracle home

9, Run DBUA to upgarde primary database.

10, Start broker on both Primary and standby:

SQL> alter system set dg_broker_start=true scope=Both;

11, Enable data guard broker:

DGMGRL> enable configuration;

12, Enable clusterware configuration for standby database

$ srvctl config database -d RACDR
PRCD-1027 : Failed to retrieve database RACDR
PRCD-1229 : An attempt to access configuration of database WLOANDR was rejected because its version 11.2.0.2.0 differs from the program version 11.2.0.3.0. Instead run the program from /u01/app/oracle/product/11.2.0.2/db_2.

Run the following command
srvctl upgrade database -d RACDR -o /u01/app/oracle/product/11.2.0.3/db_2