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 Non-CDB In the Source Oracle Home Example
• 2-5 CDB in a Source Oracle Home
• 2-6 Example of Running the Parallel Upgrade Utility using Priority List Emulation
• 3-1 Running Parallel Upgrade Utility with Parameters for CDB and Non-CDB Databases
• 3-2 Running Parallel Upgrades on Multiple Pluggable Databases (PDBs) Using Parallel Upgrade Utility
• 3-3 Selecting a Database for Upgrade with DBUA
• 3-4 Selecting a Database for Upgrade with DBUA Using Noninteractive ("Silent") Option
• 3-5 Upgrading Non-CDB 11.2.0.3 to 12.2.0.1 PDB on a CDB
• 3-6 Resetting the User Environment Variables
• 3-7 Testing the Connection to the Database
• 3-8 Running the Pre-Upgrade Information Tool (preupgrade.jar)
• 3-9 Reviewing the Pre-Upgrade Information Tool Log (preupgrade.log)
• 3-10 Running the Preupgrade Fixup SQL script (preupgrade_fixups.sql)
• 3-11 Manually Removing Oracle Enterprise Manager (em_present)
• 3-12 Manually Removing the OLAP Catalog (amd_exists)
• 3-13 Gathering Current Dictionary Statistics (dictionary_stats)
• 3-14 Granting the ADMINISTER DATABASE TRIGGER privilege (trgowner_no_admndbtrg)
• 3-15 Refreshing Materialized Views (mv_refresh)
• 3-16 Upgrading Oracle Application Express (apex_upgrade_msg)
• 3-17 Stopping the Database Service Using Command-Line Commands
• 3-18 Stopping the Database Service Using Microsoft Windows PowerShell Scripting
• 3-19 Deleting the Database Service from the Earlier Release Oracle Home
• 3-20 Stopping the Listener for the Earlier Release Oracle Home
• 3-21 Setting the environment variables to the new Oracle home
• 3-22 Copying the PFILE to the New Oracle home, and Creating a New Service Using the New Oracle Database binary
• 3-23 Starting the Database Upgrade
• 3-24 Completing the Post-Upgrade Checks
• 3-25 Running the Postupgrade Fixups Script
• 3-26 Manual Fixup Instructions for Oracle-Maintained Types In User Tables (depend_usr_tables)
• 3-27 Manual Fixup Instructions for Time Zone Version (old_time_zones_exist)
• 3-28 Manual Fixup for Refreshing Dictionary Statistics (post_dictionary)
• 3-29 Specifying Complete PDB Upgrade Priority
• 3-30 Specifying a Priority Subset of PDBs, and Upgrading Other PDBs with Default Processing
• 3-31 Specifying a Priority Subset of PDBs, and Upgrading Other PDBs with an Inclusion List
• 3-32 Specifying a Priority Subset of PDBs, and Excluding CDB$ROOT with an Exclusion List
• 3-33 Specifying an Exclusion List using CATCTL_LISTONLY
• 3-34 Specifying a Priority List using CON_ID Values
• 3-35 Upgrade Summary Report for the Post-Upgrade Status Tool
• 3-36 Rerunning Upgrades With the Resume Option
• 3-37 Rerunning Upgrades With an Exclusion List
• 3-38 Rerunning Upgrades on PDBs Using the Resume Option
• 3-39 Rerunning Upgrades on PDBs Using Exclusion Lists
• 3-40 Rerunning Upgrades on PDBs Using an Inclusion List
• 4-1 Running the utlrp.sql Script On All Containers in the CDB With the CATCON Utility
• 4-2 Number of Invalid Objects Remaining
• 4-3 Number of Objects Recompiled
• 4-4 Number of Objects Recompiled with Errors
• 6-1 ORA-20001 Error Due To ORA-06512