Move to Oracle Database 11g – The whole Story



Move to Oracle Database 11g ? The whole Story

Mike Dietrich. Carol Tagliaferri, Roy Swonger

Database Upgrade & Utilities

ORACLE Corporation

Agenda

Preparation Upgrade News and Task List Diagnostics & Tuning Performance Testing Best Practices

Agenda

Preparation

Upgrade

News and Task List Diagnostics & Tuning Performance Testing Best Practices

Parameters Processes Miscellaneous

Tools Automation LOB & SecureFiles Flashback

ADR Compression

Parameter COMPATIBLE

? COMPATIBLE has to be at least 10.1.0 for an 11g database ? No way back once 11.1.0 has been enabled

? Supported release downgrade only down to 10.1.0 ? Supported patch downgrade only down to 11.1.0 ? No ALTER DATABASE RESET COMPATIBILITY command anymore

COMPATIBLE = 10.0/1/2.0

COMPATIBLE = 11.0.0

Parameter COMPATIBLE

? Upgrade 9i 11g precautions:

? Make 100% sure that you've applied DST patches before starting the 9i database in an 11g environment ? 9i 11g requires COMPATIBLE 10.1 ? No possibility to have COMPATIBLE=9.2.0 ? No way back as soon as the database has be opened with a raised COMPATIBLE setting

COMPATIBLE 10.1/2.0

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download