List of Examples

• 2-1        Finding User Accounts That Use Case-Insensitive (10G) Version
• 2-2        Fixing Accounts with Case-Insensitive Passwords
• 2-3        Checking for the Presence of SEC_CASE_SENSITIVE_LOGON Set to FALSE
• 2-4        Using AutoUpgrade in Analyze Mode to Check an Oracle Database 12c Non-CDB System
• 2-5        AutoUpgrade Configuration File for a CDB and PDBs
• 2-6        Example of Running the Parallel Upgrade Utility using Priority List Emulation
• 2-7        Overview of Upgrade Procedure for Databases Using Oracle Data Vault
• 3-1        AutoUpgrade Configuration File for Non-CDB to PDB Conversion
• 3-2        Upgrading and Converting a Non-CDB to Oracle Database 19c Using Multitenant Architecture
• 3-3        Checking Redo Transport Service Status
• 3-4        Checking Apply Lag and Transport Lag
• 3-5        AutoUpgrade Configuration File With Two Database Entries
• 3-6        Standardizing Upgrades With AutoUpgrade Configuration File Entries
• 3-7        Setting up Archive Logging and Fast Recovery Area (FRA) Before Using AutoUpgrade
• 3-8        Password Files and Security Password File Updates
• 3-9        Transparent Data Encryption and AutoUpgrade
• 3-10      Example of How to Enable and Disable the AutoUpgrade Console
• 3-11      Starting Up the AutoUpgrade Utility in Analyze Mode
• 3-12      Creating a New Checklist for a Configuration File
• 3-13      Find and Edit checklist.cfg
• 4-1        Rerunning Upgrades With the Resume Option
• 4-2        Rerunning Upgrades With an Exclusion List
• 4-3        Rerunning Upgrades on PDBs Using the Resume Option
• 4-4        Rerunning Upgrades on PDBs Using Exclusion Lists
• 4-5        Rerunning Upgrades on PDBs Using an Inclusion List
• 4-6        Running Parallel Upgrade Utility with Parameters for CDB and Non-CDB Databases
• 4-7        Running Parallel Upgrades on Multiple Pluggable Databases (PDBs) Using Parallel Upgrade Utility
• 4-8        Specifying Complete PDB Upgrade Priority
• 4-9        Specifying a Priority Subset of PDBs, and Upgrading Other PDBs with Default Processing
• 4-10      Specifying a Priority Subset of PDBs, and Upgrading Other PDBs with an Inclusion List
• 4-11      Specifying a Priority Subset of PDBs, and Excluding CDB$ROOT with an Exclusion List
• 4-12      Specifying an Exclusion List using CATCTL_LISTONLY
• 4-13      Specifying a Priority List using CON_ID Values
• 4-14      Example of Multitenant Architecture Upgrade Using Defaults (No Parameters Set)
• 4-15      Example of Multitenant Architecture Upgrade Using 64 In Parallel PDB Upgrade Processors and 4 Parallel SQL Processes
• 4-16      Example of Multitenant Architecture Upgrade Using 20 In Parallel PDB Upgrade Processors and 2 Parallel SQL Processes
• 4-17      Example of Multitenant Architecture Upgrade Using 10 In Parallel PDB Upgrade Processors and 4 Parallel SQL Processes
• 4-18      Resetting the User Environment Variables
• 4-19      Testing the Connection to the Database
• 4-20      Running the Pre-Upgrade Information Tool (preupgrade.jar)
• 4-21      Reviewing the Pre-Upgrade Information Tool Log (preupgrade.log)
• 4-22      Running the Preupgrade Fixup SQL script (preupgrade_fixups.sql)
• 4-23      Manually Removing Oracle Enterprise Manager (em_present)
• 4-24      Manually Removing the OLAP Catalog (amd_exists)
• 4-25      Gathering Current Dictionary Statistics (dictionary_stats)
• 4-26      Granting the ADMINISTER DATABASE TRIGGER privilege (trgowner_no_admndbtrg)
• 4-27      Refreshing Materialized Views (mv_refresh)
• 4-28      Upgrading Oracle Application Express (apex_upgrade_msg)
• 4-29      Stopping the Database Service Using Command-Line Commands
• 4-30      Stopping the Database Service Using Microsoft Windows PowerShell Scripting
• 4-31      Deleting the Database Service from the Earlier Release Oracle Home
• 4-32      Stopping the Listener for the Earlier Release Oracle Home
• 4-33      Setting the environment variables to the new Oracle home
• 4-34      Copying the PFILE to the New Oracle home, and Creating a New Service Using the New Oracle Database binary
• 4-35      Starting the Database Upgrade
• 4-36      Completing the Post-Upgrade Checks
• 4-37      Running the Postupgrade Fixups Script
• 4-38      Manual Fixup Instructions for Oracle-Maintained Types In User Tables (depend_usr_tables)
• 4-39      Manual Fixup Instructions for Time Zone Version (old_time_zones_exist)
• 4-40      Manual Fixup for Refreshing Dictionary Statistics (post_dictionary)
• 5-1        Upgrade Summary Report for the Post-Upgrade Status Tool
• 6-1        Running the utlrp.sql Script On All Containers in the CDB With the CATCON Utility
• 6-2        Number of Invalid Objects Remaining
• 6-3        Number of Objects Recompiled
• 6-4        Number of Objects Recompiled with Errors
• 6-5        Copying the Earlier Release Demo Directory and Refreshing the Demonstrations in the Read-Only Oracle Home
• 6-6        Example of Spooling Postupgrade Fixup Results for a Non-CDB Oracle Database
• 6-7        Examples of Running Postupgrade Fixups Using catcon.pl On Linux, UNIX and Windows Systems
• 8-1        ORA-20001 Error Due To ORA-06512
• 10-1      Example of Error Messages with UTL_FILE And Symbolic Links
• A-1        Non-CDB In the Source Oracle Home Example
• A-2        CDB in a Source Oracle Home
• B-1        Selecting a Database for Upgrade with DBUA
• B-2        Selecting a Database for Upgrade with DBUA Using Noninteractive ("Silent") Option
• B-3        Use Cases for Running DBUA in Noninteractive (”Silent") Mode