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
- 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
- Enabling Oracle Database Vault After Upgrading Oracle Database
- 3 Upgrading Oracle Database
-
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
- 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