Contents

Introduction

Why Upgrade?

Improvements in Oracle 11g

Improvements in Oracle 10g

Challenges with Upgrades

Streamlining the Upgrade Process

The Methodology

1. Create a Target Instance (v10g or 11g)

2. Set up Replication from Source (v8i or 9i) to Target (v10g or 11g)

3. Upgrade the Target Instance

4. Resume Replication from Source to Target

5. Thoroughly Test the Target Instance

a. Perform Preliminary Checks

b. Implement Desired Oracle 10g or 11g Features

c. Test Updating Applications on Oracle 10g or 11g

6. Set up Replication from Target to Source

7. Switch Users to the Target Instance (v10g or 11g)

Use the Source Instance as a Fallback

8. Upgrade the Source 9i or 8i System in Minutes

Conclusion

About the Author

About Quest Software, Inc.

Contacting Quest Software

Contacting Quest Support

Oracle Whitepapers - Upgrading to Oracle 10g or 11g with Minimal Downtime Index