Move to Oracle Database 11g – The whole Story



Move to Oracle Database 11g ¨C 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