Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upgrade from 10g to 11g

VIKHARAHMEDJan 2 2013 — edited Jan 3 2013

Upgrade scenario: 10.2.0.5 to 11.2.0.3 patch 10 on Windows 2003 32 bit

1. Install Oracle 11g software
2. Perform patching steps "opatch apply" as well as run the script utlrp.sql (do not run catwinbundle.sql here) ( patchset 14 latest , is it rite? )
3. Update Oracle Instant Client Software
4. Copy the SQL*Net files from the Oracle 10g home to the Oracle 11g home
5. Prepare system for DBUA upgrade (remove ORACLE_HOME and TNS_ADMIN variables)
6. Perform upgrade using Database Upgrade Assistant
7. Run post-upgrade scripts (post_upgrade_tasks.sql, upgrade_tstz.sql, set_compatible.sql, post_upgrade_status.sql) -- mention any other scripts to perform
8. Run catwinbundle.sql from patch directory
9. Any other remaining post-upgrade steps, if so, kindly provide me?

Is this correct? Kindly help me

Thanks,
Vikhar

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2013

Added on Jan 2 2013

#database-upgrade

8 comments

3,528 views