I have an Oracle instance running 11.2.0.2.0:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
I am going to upgrade to 11.2.0.3.11.
My question is which order should I perform the upgrade?
Option 1
- Install 11.2.0.3
- Upgrade Database
- Patch to 11.2.0.3.11
- Patch Database
Option 2
- Install 11.2.0.3
- Patch to 11.2.0.3.11
- Upgrade Database