Table of Contents
- Title and Copyright Information
- Preface
- 1 Checking Compatibility Before Upgrading Oracle Database
-
2
Preparing to Upgrade Oracle Database
- Installing Oracle Software in a New Oracle Home
- About Oracle Database AutoUpgrade
- Prepare a Backup Strategy Before Upgrading Oracle Database
- Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
- About the AutoUpgrade Analyze Processing Mode
- AutoUpgrade with Source and Target Database Homes on Same Server (Typical)
- Preparing for Upgrades of Databases with Oracle Database Vault
- 3 Using AutoUpgrade to Upgrade and convert Non-CDBs to PDBs
-
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
- 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
- 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