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 AutoUpgrade Configuration Files for Different Patching Scenarios
- 3-10 A Summary Log File for AutoUpgrade Patching
- 3-11 Configuration files for AutoUpgrade Patching
- 3-12 AutoUpgrade Patching Download Option
- 3-13 AutoUpgrade Patching Deploy Option
- 3-14 Running a script using
noconsolemode - 3-15 Configuration File for Unplug-Plug Relocate of Non-CDB and PDB with No Refresh Rate for Data Files
- 3-16 Configuration File for Unplug-Plug Relocate of Non-CDB and PDB with Deployment Delay and Refresh Rate for Data Files
- 3-17 Simple Configuration File for Unplug-Plug Relocate of a PDB
- 3-18 Using
before_actionandafter_actionin the Configuration File - 3-19 Using
revert_before_actionandrevert_after_actionin the Configuration File - 3-20 Setting up Archive Logging and Fast Recovery Area (FRA) Before Using AutoUpgrade
- 3-21 Password Files and Security Password File Updates
- 3-22 Transparent Data Encryption and AutoUpgrade
- 3-23 Example of How to Enable and Disable the AutoUpgrade Console
- 3-24 Disk Space Errors While Upgrade is Running
- 3-25 Disk Space Errors After Upgrade has Completed
- 3-26 Starting Up the AutoUpgrade Utility in Analyze Mode
- 3-27 Creating a New Checklist for a Configuration File
- 3-28 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.sqlScript - 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
nameParameter - 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