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        AutoUpgrade Procedure for Databases Using Oracle Database Vault
• 3-1        Running AutoUpgrade in the Target Home After Moving the Database to a New Location
• 3-2        AutoUpgrade Configuration File for Non-CDB to PDB Conversion
• 3-3        AutoUpgrade Configuration File for Unplug-Plug Upgrades
• 3-4        Upgrading and Converting a Non-CDB to Oracle Database 19c Using Multitenant Architecture
• 3-5        Checking Redo Transport Service Status
• 3-6        Checking Apply Lag and Transport Lag
• 3-7        Upgrading an Encrypted PDB with an Unplug Plug Upgrade Using AutoUpgrade
• 3-8        Upgrading a Database Using TDE and Converting from Non-CDB to PDB
• 3-9        
• 3-10      AutoUpgrade Configuration Files for Different Patching Scenarios
• 3-11      A Summary Log File for AutoUpgrade Patching
• 3-12      Configuration files for AutoUpgrade Patching
• 3-13       AutoUpgrade Patching Download Option
• 3-14      AutoUpgrade Patching Deploy Option
• 3-15      Running a script using noconsole mode
• 3-16      Configuration File for Unplug-Plug Relocate of Non-CDB and PDB with No Refresh Rate for Data Files
• 3-17      Configuration File for Unplug-Plug Relocate of Non-CDB and PDB with Deployment Delay and Refresh Rate for Data Files
• 3-18      Simple Configuration File for Unplug-Plug Relocate of a PDB
• 3-19       Using before_action and after_action in the Configuration File
• 3-20       Using revert_before_action and revert_after_action in the Configuration File
• 3-21      Setting up Archive Logging and Fast Recovery Area (FRA) Before Using AutoUpgrade
• 3-22      Password Files and Security Password File Updates
• 3-23      Transparent Data Encryption and AutoUpgrade
• 3-24      Example of How to Enable and Disable the AutoUpgrade Console
• 3-25      Disk Space Errors While Upgrade is Running
• 3-26      Disk Space Errors After Upgrade has Completed
• 3-27      Starting Up the AutoUpgrade Utility in Analyze Mode
• 3-28      Creating a New Checklist for a Configuration File
• 3-29      Find and Edit checklist.cfg
• 4-1        Running Parallel Upgrade Utility with Parameters for CDB and Non-CDB Databases
• 4-2        Running Parallel Upgrades on Multiple Pluggable Databases (PDBs) Using Parallel Upgrade Utility
• 4-3        Specifying Complete PDB Upgrade Priority
• 4-4        Specifying a Priority Subset of PDBs, and Upgrading Other PDBs with Default Processing
• 4-5        Specifying a Priority Subset of PDBs, and Upgrading Other PDBs with an Inclusion List
• 4-6        Specifying a Priority Subset of PDBs, and Excluding CDB$ROOT with an Exclusion List
• 4-7        Specifying an Exclusion List using CATCTL_LISTONLY
• 4-8        Specifying a Priority List using CON_ID Values
• 4-9        Example of Multitenant Architecture Upgrade Using Defaults (No Parameters Set)
• 4-10      Example of Multitenant Architecture Upgrade Using 64 In Parallel PDB Upgrade Processors and 4 Parallel SQL Processes
• 4-11      Example of Multitenant Architecture Upgrade Using 20 In Parallel PDB Upgrade Processors and 2 Parallel SQL Processes
• 4-12      Example of Multitenant Architecture Upgrade Using 10 In Parallel PDB Upgrade Processors and 4 Parallel SQL Processes
• 4-13      Resetting the User Environment Variables
• 4-14      Testing the Connection to the Database
• 4-15      Manually Removing Oracle Enterprise Manager (em_present)
• 4-16      Manually Removing the OLAP Catalog (amd_exists)
• 4-17      Granting the ADMINISTER DATABASE TRIGGER privilege (trgowner_no_admndbtrg)
• 4-18      Refreshing Materialized Views (mv_refresh)
• 4-19      Upgrading Oracle Application Express (apex_upgrade_msg)
• 4-20      Stopping the Database Service Using Command-Line Commands
• 4-21      Stopping the Database Service Using Microsoft Windows PowerShell Scripting
• 4-22      Deleting the Database Service from the Earlier Release Oracle Home
• 4-23      Stopping the Listener for the Earlier Release Oracle Home
• 4-24      Setting the environment variables to the new Oracle home
• 4-25      Copying the PFILE to the New Oracle home, and Creating a New Service Using the New Oracle Database binary
• 4-26      Starting the Database Upgrade
• 4-27      Completing the Post-Upgrade Checks
• 4-28      Rerunning Upgrades With the Resume Option
• 4-29      Rerunning Upgrades With an Exclusion List
• 4-30      Rerunning Upgrades on PDBs Using the Resume Option
• 4-31      Rerunning Upgrades on PDBs Using Exclusion Lists
• 4-32      Rerunning Upgrades on PDBs Using an Inclusion List
• 5-1        Upgrade Summary Report for the Post-Upgrade Status Tool
• 6-1        Run the dbupgdiag.sql Script
• 6-2        Run a SQL Query on DBA_REGISTRY
• 6-3        Run SQL Queries to Check for Invalid Objects
• 6-4        Number of Invalid Objects Remaining
• 6-5        Number of Objects Recompiled
• 6-6        Number of Objects Recompiled with Errors
• 6-7        Copy TNSNAMES.ORA and SQLNET.ORA to New Default Network Administration Directory
• 6-8        Set the TNS_ADMIN Environment Variable
• 6-9        Copying the Earlier Release Demo Directory and Refreshing the Demonstrations in the Read-Only Oracle Home
• 6-10      Example of Spooling Postupgrade Fixup Results for a Non-CDB Oracle Database
• 6-11      Examples of Running Postupgrade Fixups Using catcon.pl On Linux, UNIX and Windows Systems
• 8-1        Check Registry on a CDB with CDB_REGISTRY View
• 8-2        Check Registry on a Non-CDB or PDB with DBA_REGISTRY View
• 8-3        ORA-20001 Error Due To ORA-06512
• 10-1      Example of Error Messages with UTL_FILE And Symbolic Links
• A-1        Submit an AutoUpgrade Task Request
• A-2        Response for an AutoUpgrade Job After a Faulty Request
• A-3        Rerunning an AutoUpgrade Job Using a taskid
• A-4        Submit Task Progress Report GET Request
• A-5        Task Progress Report Request With an Invalid Task ID
• A-6        Submit Task Console GET Request
• A-7        Response Header for a Console Request With an Invalid Task ID
• A-8        Submit Task Details GET Request
• A-9        Task Details Request with an Invalid taskid
• A-10      Submit Task List GET Request
• A-11      Submit Task Log GET Request
• A-12      Response Header for a Log Request With an Invalid Task ID
• A-13      Response Body for a Task ID Log List
• A-14      Request a Specific Log with name Parameter
• A-15      Submit Task Status GET Request
• A-16      Submit Task Status GET Request with an invalid taskid
• B-1        Non-CDB In the Source Oracle Home Example
• B-2        CDB in a Source Oracle Home
• C-1        Selecting a Database for Upgrade with DBUA
• C-2        Selecting a Database for Upgrade with DBUA Using Noninteractive ("Silent") Option
• C-3        Use Cases for Running DBUA in Noninteractive (”Silent") Mode