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
- Prepare a Backup Strategy Before Upgrading Oracle Database
- Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
- Enabling Oracle Database Vault After Upgrading Oracle Database
- Preparations for Running AutoUpgrade Processing Modes
- Pre-Upgrade Information Check with AutoUpgrade
- Create Configuration File for AutoUpgrade
- Local Parameters for the AutoUpgrade Configuration File
- Global Parameters for the AutoUpgrade User Configuration File
- Locally Modifiable Global Parameters for AutoUpgrade Configuration File
- Understanding Non-CDB to PDB Upgrades with AutoUpgrade
- Non-CDB to PDB Upgrade Guidelines and Examples
- Understanding Unplug-Plug Upgrades with AutoUpgrade
- Examples of Non-CDB to PDB Configuration Files for AutoUpgrade
- 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
-
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 Statistics Tables Created by the DBMS_STATS Package 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
- Replace the DEMO Directory in Read-Only Oracle Homes
- Configure Access Control Lists (ACLs) to External Network Services
- Enabling Oracle Database Vault After Upgrading Oracle Database
- Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
-
Recommended and Best Practices to Complete After Upgrading Oracle Database
- Back Up the Database
- Run AutoUpgrade Postupgrade Checks
- Regathering Fixed Objects Statistics with DBMS_STATS
- Reset Passwords to Enforce Case-Sensitivity
- Finding and Resetting User Passwords That Use the 10G Password Version
- Understand Oracle Grid Infrastructure, Oracle ASM, and Oracle Clusterware
- Oracle Grid Infrastructure Installation and Upgrade and Oracle ASM
- Add New Features as Appropriate
- Develop New Administrative Procedures as Needed
- Migrating Tables from the LONG Data Type to the LOB Data Type
-
Migrate Your Upgraded Oracle Databases to Use Unified Auditing
- Understanding Unified Auditing Migration Process for Oracle Database
- Migrating to Unified Auditing for Oracle Database
- About Managing Earlier Audit Records After You Migrate to Unified Auditing
- Removing the Unified Auditing Functionality
- Obtaining Documentation References if You Choose Not to Use Unified Auditing
- Identify Oracle Text Indexes for Rebuilds
- Dropping and Recreating DBMS_SCHEDULER Jobs
- Transfer Unified Audit Records After the Upgrade
- About Recovery Catalog Upgrade After Upgrading Oracle Database
- About Testing the Upgraded Production Oracle Database
- Upgrading the Time Zone File Version After Upgrading Oracle Database