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 Using AutoUpgrade
- Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
- Preparing for Upgrades of Databases with Oracle Database Vault
- Preparations for Running AutoUpgrade Processing Modes
- Pre-Upgrade Information Check with AutoUpgrade
- Create Configuration File for AutoUpgrade
- Locally Modifiable Global Parameters for AutoUpgrade Configuration File
-
Local Parameters for the AutoUpgrade Configuration File
- add_after_upgrade_pfile
- add_during_upgrade_pfile
- after_action
- before_action
- catctl_options
- checklist
- close_source
- del_after_upgrade_pfile
- del_during_upgrade_pfile
- drop_win_src_service
- env
- exclusion_list
- ignore_errors
- keep_source_pdb
- log_dir
- manage_standbys_clause
- pdbs
- raise_compatible
- remove_rac_config
- remove_underscore_parameters
- replay
- restoration
- revert_after_action
- revert_before_action
- run_hcheck
- run_utlrp
- sid
- skip_tde_key_import
- source_base
- source_dblink
- source_home
- source_ldap_admin_dir
- source_tns_admin_dir
- start_time
- target_base
- target_cdb
- target_pdb_copy_option=file_name_convert
- target_pdb_name
- target_ldap_admin_dir
- target_tns_admin_dir
- timezone_upg
- tune_setting
- upgrade_node
- Global Parameters for the AutoUpgrade User 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
- Recompile Invalid Objects in the Database
- Check PL/SQL Packages and Dependent Procedures
- 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
- Gathering Dictionary Statistics After Upgrading
- Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
- 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
-
Turn Off Traditional Auditing in Upgraded
Oracle Databases
- Understanding Auditing for Oracle Database
- Turning Off Traditional Auditing and Using Unified Auditing for Oracle Database
- About Managing Earlier Audit Records After You Move to Unified Auditing
- Moving From Pure Unified Auditing to Mixed-Mode Auditing
- 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
- Upgrading the Time Zone File Version After Upgrading Oracle Database
- Enabling Disabled Release Update Bug Fixes in the Upgraded Database
- About Testing the Upgraded Production Oracle Database