Database & Patch set Upgrade

Database & patch upgrade is one of the most important work for Database Administrator.Before going further first understand what are “upgrade” & “migration” & “patch set” & “CPU patch” word.Upgrade:Usually use for oracle database upgrade.Eg: upgrade from oracle 9i to oracle 10g.Migration:Usually use for migrate non oracle database to oracle database.Eg: From SQL server database to oracle databasePatch set:There are two types of patch upgrade 1. Patch set updateFrom one oracle version to another oracle version Eg: oracle 9i to oracle 10gNOTE: Patch set based on oracle base release Eg: oracle 10gr1 (10.1.0.2.0) and for 10gr2 (10.2.0.1.0)2. CPU patch (Critical Patch update)Patches is apply for fix database bug suppose after apply latest patch set for current release if there is any bug occur then oracle release cpu patches in regular interval to fix those bug.Eg: oracle 10gr1 base rel: 10.1.0.2.0, Latest Patch set: 10.1.0.5.0, Latest CPU patch: Jan-08 CPU patch for 10.1.0.5.0NOTE: CPU patch based on latest patch set.For more info: http://www.oracle.com/technology/deploy/security/alerts.htmHow to upgrade database to oracle 10gr2?Determine the Upgrade Path to the New Oracle Database 10g Releasehttp://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007814Before upgrading process we need to define upgrade methodThere are four methods to upgrade our database1. DBUA (Database upgrade assistant)2. Manually upgrade3. Export/Import4. Data copyinghttp://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i694345Patch set upgrade example:1. From oracle 9ir2 (9.2.0.2 to 9.2.0.8) on Windows http://babudba.blogspot.com/2007/11/patch-installation.html2. From oracle 9ir2 (9.2.0.1 to 9.2.0.7) on Solaris http://sabdarsyed.blogspot.com/2007/02/upgrade-oracle-database-9201-to-9207-on.html3. From oracle 10gr1 (10.1.0.2 to 10.1.0.5) on windowshttp://dbataj.blogspot.com/2007/06/upgrading-database-from-101020-to.html4. From oracle 10gr2 (10.2.0.2 to 10.2.0.3) on windowshttp://babudba.blogspot.com/2007/11/upgrade-oracle-10202-to-10203.html5. From oracle 10gr2 (10.2.0.1 to 10.2.0.3) on Linuxhttp://sabdarsyed.blogspot.com/2007/03/upgrading-oracle-database-server-10g.html