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