Oracle 18.104.22.168 & 22.214.171.124
Want to upgrade two databases :
1) from 126.96.36.199 to 188.8.131.52
2) from 184.108.40.206 to 220.127.116.11
which is the best and reliable method for the above two upgrade ?
To upgrade to Oracle Database release 18.104.22.168, you must have to install Oracle Grid Infrastructure and Oracle Database software into a new Oracle home .
and before upgrade run Pre-Upgrade Script .
complete guide is available
1)Download the 22.214.171.124 patchset and install oracle software into separate home
2)Take a backup of existing databases.
3) Run dbua
export ORACLE_HOME=<new 126.96.36.199 path>
dbua -silent -sid <sidname>
Assuming there is no GI installed
Your question is already documented. Please review:
Minimizing Downtime During Production Upgrade [ID 478308.1]
Master Note For Oracle Database Upgrades and Migrations [ID 1152016.1]
Different Upgrade Methods For Upgrading Your Database [ID 419550.1]
I strongly suggest toe check my blog http://heliosguneserol.wordpress.com/2010/06/17/move-to-oracle-database-11g-release-2-wiht-mike-dietrich/
In this pdf you can see patch of to upgrade db from x to n wiht many senerios wiht all related metalinks notes which is created by Oracle worker Mike Dietrich