Table of Contents

• Title and Copyright Information
• Preface
  • Use Case Scenario for this Document
  • Documentation Accessibility
• 1 Checking Compatibility Before Upgrading Oracle Database
  • Checking the Compatibility Level of Oracle Database
  • Values for the COMPATIBLE Initialization Parameter in Oracle Database
• 2 Preparing to Upgrade Oracle Database
  • Installing Oracle Software in a New Oracle Home
    • Choose a New Location for Oracle Home when Upgrading
    • Installing the New Oracle Database Software for Single Instance
  • About Oracle Database AutoUpgrade
  • Prepare a Backup Strategy Before Upgrading Oracle Database
  • Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
    • Release Updates and Requirements for Upgrading Oracle Database
    • Copying Transparent Encryption Oracle Wallets
    • Recommendations for Oracle Net Services When Upgrading Oracle Database
    • Understanding Password Case Sensitivity and Upgrades
    • Checking for Accounts Using Case-Insensitive Password Version
  • About the AutoUpgrade Analyze Processing Mode
  • AutoUpgrade with Source and Target Database Homes on Same Server (Typical)
  • Enabling Oracle Database Vault After Upgrading Oracle Database
    • Upgrading Oracle Database Without Disabling Oracle Database Vault
    • Common Upgrade Scenarios with Oracle Database Vault
• 3 Upgrading Oracle Database
  • AutoUpgrade Configuration File for Non-CDB Upgrades on the Same System
  • AutoUpgrade with Source and Target Database Homes on Same Server (Typical)
• 4 Post-Upgrade Tasks for Oracle Database
  • How to Show the Current State of the Oracle Data Dictionary
  • Required Tasks to Complete After Upgrading Oracle Database
    • Setting Environment Variables on Linux and Unix Systems After Manual Upgrades
    • Check PL/SQL Packages and Dependent Procedures
    • Upgrading Tables Dependent on Oracle-Maintained Types
    • About Recovery Catalog Upgrade After Upgrading Oracle Database
    • Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database
    • Update Oracle Application Express Configuration After Upgrading Oracle Database
    • Configure Access Control Lists (ACLs) to External Network Services
    • Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
  • Recommended and Best Practices to Complete After Upgrading Oracle Database
    • Back Up the Database
    • Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
    • Regathering Fixed Objects Statistics with DBMS_STATS
    • Dropping and Recreating DBMS_SCHEDULER Jobs
    • Transfer Unified Audit Records After the Upgrade
    • Enabling Disabled Release Update Bug Fixes in the Upgraded Database
    • Reset Passwords to Enforce Case-Sensitivity
      • Finding and Resetting User Passwords That Use the 10G Password Version
    • Configuring the FTP and HTTP Ports and HTTP Authentication for Oracle XML DB
    • Add New Features as Appropriate
    • Develop New Administrative Procedures as Needed
    • Migrate Your Upgraded Oracle Databases to Use Unified Auditing
    • Migrating From Rollback Segments To Automatic Undo Mode
    • Migrating Tables from the LONG Data Type to the LOB Data Type
    • Identify Oracle Text Indexes for Rebuilds
    • About Testing the Upgraded Production Oracle Database
    • Upgrading the Time Zone File Version After Upgrading Oracle Database