Oracle Upgrade Workshop

Had the pleasure of attending the Oracle Upgrade Workshop in Melbourne run by Mike Deitrech and Roy Swonger.

Here some useful links from the workship and slides presented:

Oracle Upgrade Workshop Presentation Slides

OTN Database Upgrade Site
Data Pump OTN Site

MOS Notes (more notes in pdf) :

Oracle Database (RDBMS) Releases Support Status Summary (Doc ID 161818.1)
Oracle Recommended Patches — Oracle Database (Doc ID 756671.1)
Patch Set Updates for Oracle Products (Doc ID 854428.1)
Patch Set Updates Known Issues Notes (Doc ID 1227443.1)
Oracle Database (RDBMS) 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) (Doc ID 169706.1) Base Release – Availability and Known Issues (Doc ID 1565082.1)

How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema (Doc ID 1030426.6)
Information On Installed Database Components and Schemas (Doc ID 472937.1)
How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade (Doc ID 753041.1)
“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g (Doc ID 136697.1)
Script to Install the “hOut” Helper Package (“hout.sql”) (Doc ID 101468.1)
Identify the corruption extension using RMAN/DBV/ANALYZE etc (Doc ID 836658.1)
How To Install 11.2 / 12.1 Database/Client Software In Silent Mode Without Using Response File (Doc ID 885643.1)
Master Note For Oracle Database Server Installation (Doc ID 1156586.1)

Oracle Patch Assurance – Data Guard Standby-First Patch Apply (Doc ID 1265700.1)
RDBMS Online Patching Aka Hot Patching (Doc ID 761111.1)
Init.ora Parameter “DEFERRED_SEGMENT_CREATION” Reference Note (Doc ID 1216282.1)
Optimizer Cost Based Query Transformation (Doc ID 1082127.1)
How to Download and Run Oracle’s Database Pre-Upgrade Utility (Doc ID 884522.1)
How to Pre-Process SYS.AUD$ Records Pre-Upgrade From 10.1 or later to 11gR1 or later. (Doc ID 1329590.1)
Updated DST transitions and new Time Zones in Oracle Time Zone File patches (Doc ID 412160.1)
Updating the RDBMS DST version in 12c Release 1 ( and up) using DBMS_DST (Doc ID 1509653.1)

Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration (Doc ID 413484.1)
Data Guard Support for Mixed HP PA-RISC 64-bit and HP Itanium Environments (Doc ID 395982.1)
RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1)
RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) (Doc ID 810394.1)
Oracle Clusterware (CRS/GI) – ASM – Database Version Compatibility (Doc ID 337737.1)
Oracle Clusterware (CRS or GI) Rolling Upgrades (Doc ID 338706.1)
How to Prepare Storage for ASM (Doc ID 452924.1)
RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1)
Master Note for Transportable Tablespaces (TTS) — Common Questions and Issues (Doc ID 1166564.1)
Transportable Tablespace (TTS) Restrictions and Limitations: Details, Reference, and Version Where Applicable (Doc ID 1454872.1)
Oracle11g Data Guard: Database Rolling Upgrade Shell Script (Doc ID 949322.1)

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA * Time limit is exhausted. Please reload CAPTCHA.