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
  • The Graphical User Interface Method for Upgrading Oracle Database
  • The Manual, Command-Line Method for Upgrading Oracle Database
  • Prepare a Backup Strategy Before Upgrading Oracle Database
  • Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
    • Patch Set 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
    • Running Upgrades with Read-Only Tablespaces
  • Using the Pre-Upgrade Information Tool for Oracle Database
    • Setting Up Environment Variables for the Pre-Upgrade Information Tool
    • Running the Pre-Upgrade Information Tool
    • Pre-Upgrade Information Tool Warnings and Recommendations for Oracle Database
      • Updating Access Control Lists and Network Utility Packages
      • Evaluate Dependencies and Add ACLs for Network Utility Packages
    • Pre-Upgrade Information Tool Output Example
  • 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
  • Using DBUA to Upgrade the Database on Linux, Unix, and Windows Systems
  • Manually Upgrading Non-CDB Architecture Oracle Databases
• 4 Post-Upgrade Tasks for Oracle Database
  • Check the Upgrade With Post-Upgrade Status Tool
  • 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
    • Recompiling All Invalid Objects
    • Track Invalid Object Recompilation Progress
    • Running OPatch Commands After Upgrading Oracle Database
    • Setting oratab and Scripts to Point to the New Oracle Location After Upgrading Oracle Database
    • Check PL/SQL Packages and Dependent Procedures
    • Upgrading Tables Dependent on Oracle-Maintained Types
    • Enabling the New Extended Data Type Capability
    • Adjusting Minimum and Maximum for Parallel Execution Servers
    • About Recovery Catalog Upgrade After Upgrading Oracle Database
    • Upgrading the Time Zone File Version After Upgrading Oracle Database
    • Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
    • Upgrading Externally Authenticated SSL Users After Upgrading Oracle Database
    • Configuring the FTP and HTTP Ports and HTTP Authentication for Oracle XML DB
    • 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
    • Scenario Non-CDB Running the postupgrade_fixups.sql Script
    • Gathering Dictionary Statistics After Upgrading
    • Regathering Fixed Objects Statistics with DBMS_STATS
    • Reset Passwords to Enforce Case-Sensitivity
      • Finding and Resetting User Passwords That Use the 10G Password Version
    • Add New Features as Appropriate
    • Develop New Administrative Procedures as Needed
    • Set Threshold Values for Tablespace Alerts
    • Migrating From Rollback Segments To Automatic Undo Mode
    • Configure Oracle Data Guard Broker
    • 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
• 5 Creating a PDB Using a Non-CDB
  • Adopting a Non-CDB as a PDB