Applies to:
Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 – Release: 8.1.7 to 11.2
Oracle Server – Standard Edition – Version: 8.1.7.4 to 11.2.0.2 [Release: 8.1.7 to 11.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2
Purpose
The purpose of this document is to provide a consolidated list of references that can be used in the management and resolution of Upgrade / Migration issues.
This document is not intended to be a static document. As additional references are identified, this document will be updated.
Scope and Application
Central location for migratrion / upgrade related references.
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests
The following is a list of available relevant references By topic:
OS Pre-Requisites
NOTE.169706.1 – Oracle� Database on AIX�,HP-UX�,Linux�,Mac OS� X,Solaris�,Tru64 Unix� Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)
Upgrade Process Notes
Note.732897.1 – How to Log Good Service Requests for Database Upgrade/Migration Issues
Note.466181.1 – 10g Upgrade Companion Gen
Note.601807.1 – Oracle 11g Upgrade Companion the customer.
Note 159657.1 – Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
Note 263809.1 – Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
Note 316889.1 – Complete Checklist for Manual Upgrades to 10gR2
Note 429825.1 – Complete Checklist for Manual Upgrades to 11gR1
Note 785351.1 – Oracle 11gR2 Upgrade Companion”
Note 837570.1 – Complete Checklist for Manual Upgrades to 11gR2
Note 870814.1 – Complete checklist to upgrade the database to 11gR2 using DBUA
Note 788273.1 – ASM Upgrade On Linux/Unix From Release 10g To 11g
Note 605251.1 – Where To Locate The Oracle RDBMS Installation Guides,
Upgrade Guides and Release Notes
Note 556477.1 Complete Checklist for Upgrades to 11gR1 using DBUA
Cross Platform Migrations:
Note.733205.1 – Migration of Oracle Instances Across OS Platforms
Wordsize Changes
Note.757245.1 – Can you Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows Intel Platforms Using the Database Upgrade Assistant (DBUA)
Note 341880.1 – How to convert a 32-bit database to 64-bit database on Linux?
Note 548978.1 – How To Change Oracle 11g Wordsize from 32-bit to 64-bit.
Note 62290.1 – Changing between 32-bit and 64-bit Word Size
Upgrade Process Performance Notes
Note.739485.1 – How to estimate the time required to upgrade a database ?
Note.556610.1 – Script to Collect DB Upgrade/Migrate Diagnostic Information
Note.780318.1 – Migration using offline Tablespaces or read only Tablespaces
Note 455744.1 – Best Practices to Minimize Downtime during Upgrade
Note.567037.1 – DBUA hangs at 82% for More than an Hour When Upgrading APPS DB to 10GR2
General Upgrade Problems
Note.456845.1 – UTLU102S.SQL May Show Different Results Than Select From DBA_REGISTRY
Note 1030426.6 – How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema
Note 412271.1 – ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While Upgrading Or Patching Databases To 10.2.0.3
Note 565600.1 – ERROR IN CATUPGRD: ORA-00904 IN DBMS_SQLPA
Note 579523.1 – ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6
Note 283053.1 – How To Use RMAN To Check For Logical & Physical Database
Corruption
Note 753041.1 – How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade
Note 578841.1 – How To Find What Objects Are Keeping Catalog And Catproc In Dba_Registry Invalid
Post-Upgrade Performance Issues
Note.394937.1 – Statistics Package (STATSPACK) Guide
Note.560977.1 – Real Application Testing Now Available for Earlier Releases
Note 562899.1 – Testing Sql Performance Impact of an Oracle 9i to Oracle Database 10g Release 2 Upgrade With Sql Performance Analyzer
Note 465787.1 – Managing CBO Stats during an upgrade to 10g or 11g
Downgrade Issues
Note.338199.1 – Downgrading A 10.1.0 Database
Note.398372.1 – How to Downgrade from Oracle RDBMS 10gR2?
Note.391656.1 – Downgrade Not Supported With ORA-20000 And ORA-06512 At “SYS.VERSION_SCRIPT”
Note.3685392.8 – Bug 3685392 – xmlrelod.sql missing which can cause downgrade errors
Other Competencies Issues
Note.472937.1 – Information On Installed Database Components and Schemas
Note.243304.1 – 10g Transportable Tablespaces Across Different Platforms
Note.337415.1 – Where to Find the Information to Install, Upgrade, Downgrade and Deinstall interMedia/Oracle Multimedia?
Note.552849.1 – Invalid objects under ORDSYS after downgrade to 9.2
Note 742113.1 – 10g: How to Determine if XDB is Being Used in the Database?
Note 243554.1 – How to Deinstall and Reinstall XML Database (XDB)
Note 456949.1 – Script to Check the Status of the JVM within the Database
Note 397770.1 – How to Check if the Oracle JVM is Installed Correctly in the Database
Note 457279.1 – How to Reload the JVM in 11.1.0.x
Note 276554.1 – How to Reload the JVM in 10.1.0.X and 10.2.0.X
Note 209870.1 – How to Reload the JVM in 9.2.0.X
Note 202914.1 – How to Reload the JVM in 9.0.1
Note 175472.1 – How to Reload the JVM in 8.1.7
White Papers
Documentation on Database Manageability and Real Application Testing
http://www.oracle.com/technology/products/manageability/database/index.html
Relevant Bugs
Unpublished Bug.4429533 FUNCTION USER_XML_PARTITIONED_TABLE_OK HAS ERRORS AFTER DOWNGRADE TO 9.2
Bug.4341945 DOWNGRADE FROM 10103 TO 9206 LEAVES INVALID SYS AQ AND STREAM OBJECTS
Unpublished Bug.5720723 CATUPGRD.SQL TOOK LONG TIME TO COMPLETE WHEN UPGRADING TO 10.2.0.2
Unpublished Bug.7114717 APPSST SRV 11G:CATUPGRD.SQL RUNS EXECSVR.SQL FOR VERY LONG TIME DURING 11G UPG
References
NOTE:1030426.6 – How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema
NOTE:159657.1 – Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)
NOTE:169706.1 – Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
NOTE:175472.1 – How to Reload the JVM in 8.1.7.X
NOTE:202914.1 – How to Reload the JVM in 9.0.1.X
NOTE:209870.1 – How to Reload the JVM in 9.2.0.X
NOTE:243304.1 – 10g : Transportable Tablespaces Across Different Platforms
NOTE:243554.1 – How to Deinstall and Reinstall XML Database (XDB)
NOTE:263809.1 – Complete checklist for manual upgrades to 10gR1 (10.1.0.x)
NOTE:276554.1 – How to Reload the JVM in 10.1.0.X and 10.2.0.X [Video]
NOTE:316889.1 – Complete Checklist for Manual Upgrades to 10gR2
NOTE:337415.1 – Where to Find the Information to Install, Upgrade, Downgrade and Deinstall interMedia/Oracle Multimedia?
NOTE:338199.1 – Downgrading A 10.1.0 Database
NOTE:341880.1 – How to convert a 32-bit database to 64-bit database on Linux?
NOTE:3685392.8 – Bug 3685392 – xmlrelod.sql missing which can cause downgrade errors
NOTE:391656.1 – Downgrade Not Supported With ORA-20000 And ORA-06512 At “SYS.VERSION_SCRIPT”
NOTE:394937.1 – Statistics Package (STATSPACK) Guide
NOTE:397770.1 – How to Check if the Oracle JVM is Installed Correctly in the Database
NOTE:398372.1 – How to Downgrade from Oracle RDBMS 10gR2?
NOTE:412271.1 – ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While Upgrading Or Patching Databases To 10.2.0.3
NOTE:429825.1 – Complete Checklist for Manual Upgrades to 11gR1
NOTE:455744.1 – Best Practices to Minimize Downtime During Upgrade
NOTE:456845.1 – UTLU102S.SQL, UTLU111S.SQL and UTLU112S.SQL May Show Different Results Than Select From DBA_REGISTRY
NOTE:456949.1 – Script to Check the Status of the JVM within the Database
NOTE:457279.1 – How to Reload the JVM in 11.1.0.x
NOTE:465787.1 – Managing CBO Stats during an upgrade to 10g or 11g
NOTE:466181.1 – 10g Upgrade Companion
NOTE:472937.1 – Information On Installed Database Components and Schemas
NOTE:548978.1 – How To Change Oracle 11g Wordsize from 32-bit to 64-bit.
NOTE:552849.1 – Invalid objects under ORDSYS after downgrade to 9.2
NOTE:556477.1 – Complete Checklist for Upgrades to 11gR1 using DBUA
NOTE:556610.1 – Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
NOTE:560977.1 – Real Application Testing Now Available for Earlier Releases
NOTE:562899.1 – TESTING SQL PERFORMANCE IMPACT OF AN ORACLE 9i TO ORACLE DATABASE 10g RELEASE 2 UPGRADE WITH SQL PERFORMANCE ANALYZER
NOTE:565600.1 – ERROR IN CATUPGRD: ORA-00904 IN DBMS_SQLPA
NOTE:567037.1 – DBUA hangs at 82% for More than an Hour When Upgrading APPS DB to 10GR2
NOTE:578841.1 – How To Find What Objects Are Keeping Catalog And Catproc In Dba_Registry Invalid
NOTE:579523.1 – ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6 Or 11.1.0.7
NOTE:601807.1 – Oracle 11gR1 Upgrade Companion
NOTE:605251.1 – Where To Locate The Oracle RDBMS Installation Guides, Upgrade Guides and Release Notes
NOTE:62290.1 – Changing between 32-bit and 64-bit Word Sizes
NOTE:732897.1 – How to Log Good Service Requests for Database Upgrade/Migration Issues
NOTE:733205.1 – Migration of Oracle Database Instances Across OS Platforms
NOTE:739485.1 – How to estimate the time required to upgrade a database ?
NOTE:742113.1 – 10g: How to Determine if XDB is Being Used in the Database?
NOTE:753041.1 – How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade
NOTE:757245.1 – Can you / How to Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA)
NOTE:780318.1 – Increasing Migration Performance and Recovery time using offline Tablespaces
NOTE:785351.1 – Oracle 11gR2 Upgrade Companion
NOTE:788273.1 – ASM Upgrade On Linux/Unix From Release 10g To 11g.
NOTE:837570.1 – Complete Checklist for Manual Upgrades to 11gR2
NOTE:870814.1 – Complete checklist to upgrade the database to 11g R2 using DBUA