I have Dataguard configured with a primary database and a standby database.
I have installed oracle 184.108.40.206 in both servers, and I want to upgrade to 220.127.116.11 by installing the patch.
I know how to install the patch in the primary.
Should I follow the same procedure also on the standby or it is different?
Refer this http://shivanandarao.wordpress.com/2012/09/20/applying-psu-patch-in-a-dataguard-physical-standby-environment/
The link refers for applying PSU patch but the process is same for the upgrade method as well.
I hope you would be doing an out-of-place upgrade.
Make sure you apply the pre-requisite patches to your primary and standby database.
You need to follow the same step of what you do on primary, the only main thing that you need to keep in mind, is to not to run any upgrade scripts (catupgrd.sql or catbundle.sql) on the standby database. These scripts need to be run on the primary database with the MRP being active on the standby database. The archives generated on the primary database would be shipped and applied to the standby database. So, make sure that you do not run the upgrade scripts on the standby database.
Disable log shipping from the Primary
Install 18.104.22.168 on Standby
Startup Standby in recovery mode (do NOT run any Upgrade SQL at the standby)
Install 22.214.171.124 on Primary
Run Upgrade SQL on Primary or use DBUA
Copy the Primary password file to the Standby and rename it in the new Oracle home.
Re-enable log shipping
Monitor the redo apply from Primary to Standby --- this will also upgrade the Standby data dictionary.
Also remember to check your listener.ora and tnsnames and make sure they are in the correct Oracle home after the upgrade
For additional information :
See Oracle support article : How do you apply a Patchset,PSU or CPU in a Data Guard Physical Standby configuration [ID 278641.1]
Here are my notes on upgrading from [url http://www.ora00600.com/articles/10g-to-11g-database-upgrade.html]10g to 11g, a few paragraphs down the page are the step by step instructions which include the parts for data guard. Although it's from 10g to 11g, the process will be the same. You need to consider how to rollback if it fails. We used snap technology at the SAN level but you could replace that with Oracle flashback. Just test it thoroughly first because I had some issues when attempting to use it initially.
The steps in that guide are much exact notes so I know they work but you should most definitely still read the upgrade guide and appropriate docs, too.