Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Changes in This Release for Oracle Database Upgrade Guide
- Preface
-
1
Introduction to Upgrading Oracle Database
- Overview of Oracle Database Upgrade Tools and Processes
- Major Steps in the Upgrade Process for Oracle Database
-
Compatibility and Interoperability between Oracle Database Releases
- About Oracle Database Release Numbers
- Convention for Referring to Release Numbers in Oracle Database Upgrade Guide
-
What Is Oracle Database Compatibility?
- The COMPATIBLE Initialization Parameter in Oracle Database
- Values for the COMPATIBLE Initialization Parameter in Oracle Database
- About Downgrading and Compatibility for Upgrading Oracle Database
- How the COMPATIBLE Initialization Parameter Operates in Oracle Database
- Checking the Compatibility Level of Oracle Database
- When to Set the COMPATIBLE Initialization Parameter in Oracle Database
- What Is Interoperability for Oracle Database Upgrades?
- About Invalid Schema Objects and Database Upgrades
- About Upgrading Oracle OLAP Data Security Policies
- About Running Multiple Oracle Releases
-
About Converting Databases During Upgrades
- Overview of Converting Databases During Upgrades
- About 32-bit Oracle Databases to 64-bit Oracle Database Conversions
- About Upgrading Using Standby Databases
- Using Oracle GoldenGate for Online Database Upgrades
- Migrating From Standard Edition to Enterprise Edition of Oracle Database
- Migrating from Enterprise Edition to Standard Edition of Oracle Database
- Migrating from Oracle Database Express Edition (Oracle Database XE) to Oracle Database
- About Upgrading Platforms for a New Oracle Database Release
-
2
Preparing to Upgrade Oracle Database
-
Tasks to Prepare for Oracle Database Upgrades
- Become Familiar with New Oracle Database Features
- Choose an Upgrade Method for Oracle Database
- Choose a New Location for Oracle Home when Upgrading
-
Develop a Test Plan for Upgrading Oracle Database
- Upgrade Testing
- Minimal Testing
- Functional Testing After Upgrades
- High Availability Testing
- Integration Testing to Ensure Applications are Compatible
- Performance Testing an Upgraded Oracle Database
- Volume and Load Stress Testing for Oracle Database Upgrades
- Test Plan Guidelines for Oracle Database Upgrade Planning
- Prepare a Backup Strategy before Upgrading Oracle Database
- Checklists for Oracle Database Upgrade
- Installing the New Oracle Database Software
-
Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
- Patch Set Updates and Requirements for Upgrading Oracle Database
- Gathering Optimizer Statistics to Decrease Oracle Database Downtime
- Verifying Materialized View Refreshes are Complete Before Upgrade
- Ensuring That No Files Are in Backup Mode Before Upgrading
- Ensuring That No Files Need Media Recovery Before Upgrading
- Resolving Outstanding Distributed Transactions Before Upgrading
- Synchronizing the Standby Database with the Primary Database When Upgrading
- Purging the Database Recycle Bin Before Upgrading
- Saving Oracle Enterprise Manager Database Control Configuration and Data
- Manually Removing DB Control with emremove.sql
- Dropping JSON-Enabled Context Search Indexes
- Copying Transparent Encryption Oracle Wallets
- Recommendations for Oracle Net Services When Upgrading Oracle Database
- Understanding Password Case Sensitivity and Upgrades
- Checking for Accounts Using Case-Insensitive Password Version
- Running Upgrades with Read-Only and Offline Tablespaces
- Preparing the New Oracle Home for Upgrading
- Prerequisites for Preparing Oracle Home on Windows
-
Using the Pre-Upgrade Information Tool for Oracle Database
- About the Pre-Upgrade Information Tool
- Setting Up Environment Variables for the Pre-Upgrade Information Tool
- Pre-Upgrade Information Tool (preupgrade.jar) Command
- Output of the Pre-Upgrade Information Tool
- Pre-Upgrade Information Tool Warnings and Recommendations for Oracle Database
- Pre-Upgrade Information Tool Output Example
- Testing the Upgrade Process for Oracle Database
-
About Upgrading Oracle Grid Infrastructure
- Oracle Grid Infrastructure and Oracle Clusterware Upgrade Recommendations
- Oracle Clusterware Must Be Running on Local Node When Upgrading
- About Upgrading an Oracle Real Application Clusters (Oracle RAC) Database with DBUA
- Upgrading Inaccessible Nodes
- About Requirements for Time Synchronization on Oracle RAC
- Recommendations for Upgrading Oracle RAC and Oracle Databases That Use ASM
- About Upgrading System Authentication for Oracle ASM Instances
- Required Task to Preserve Downgrade Capability
- Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault
-
Tasks to Prepare for Oracle Database Upgrades
-
3
Upgrading Oracle Database
- Backing Up Oracle Database for Upgrading
- Upgrading with Parallel Upgrade Utility (catctl.pl and dbupgrade Shell Command)
-
Upgrading with Oracle Database Upgrade Assistant (DBUA)
- Recommendations for Using DBUA
- About Stopping DBUA When Upgrading
- How DBUA Processes the Upgrade for Oracle Database
- Upgrade Scripts Started by DBUA
- Using DBUA to Upgrade the Database on Linux, UNIX, and Windows Systems
- Moving a Database from an Existing 12c Oracle Home
- Using DBUA in Silent Mode to Upgrade Oracle Database
- Upgrade Scenarios for Non-CDB Oracle Databases
- Example of Manual Upgrade of Windows Non-CDB Oracle Database 11.2.0.3
-
Manual Upgrade Scenarios for Multitenant Architecture Oracle Databases
- About Oracle Multitenant Oracle Database Upgrades
- Manually Upgrading a Multitenant Container Oracle Database (CDB)
- About Upgrading PDBs Using the Parallel Upgrade Utility with Priority Lists
- About PDB Upgrades Using Priority Lists, Inclusion Lists, and Exclusion Lists
- Upgrading Multitenant Architecture In Parallel
- Upgrading Multitenant Architecture Sequentially Using Unplug-Plug
- Improvements to Data Dictionary Upgrade and Upgrade Status Displays
- About Dbupgrade Scripts and catupgrd.sql in Earlier Releases of Oracle Database
- About Transporting and Upgrading a Database (Full Transportable Export/Import)
- About Log File Location and DIAGNOSTIC_DEST
-
Troubleshooting the Upgrade for Oracle Database
- About Starting Oracle Database in Upgrade Mode
- Running DBUA with Different ORACLE_HOME Owner
- Invalid Object Warnings and DBA Registry Errors
- Invalid Objects and Premature Use of Postupgrade Tool
- Resolving Oracle Database Upgrade Script Termination Errors
- Troubleshooting Causes of Resource Limits Errors while Upgrading Oracle Database
- Resolving SQL*Plus Edition Session Startup Error for Oracle Database
- Error ORA-00020 Maximum Number of Processes Exceeded When Running utlrp.sql
- Fixing ORA-01822 with DBMS_DST Package After Upgrades
- Fixing ORA-28365: Wallet Is Not Open Error
- ORA-44787 Errors During Multitenant Upgrades
- Resolving issues with view CDB_JAVA_POLICY
- Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
- Understanding Component Status With the Post-Upgrade Status Tool
- Standard Edition Starter Database and Components with Status OPTION OFF
- Adjusting Oracle ASM Password File Location After Upgrade
- Fixing "Warning XDB Now Invalid" Errors with Pluggable Database Upgrades
- Fixing ORA-27248: sys.dra_reevaluate_open_failures is running
- Fixing ORA-22288: File or LOB Operation FILEOPEN Failed Soft Link in Path
- Fixing Oracle Database Enterprise User Security, OLS-OID, and Provisioning Profile Error
- Fixing 32K Migration Error with utl32k.sql and MAX_STRING_SIZE
- Recovering from a CRS Shutdown and Oracle ASM Losing Rolling Migration
- Data Type Versioning Could Cause Cross-Version Replication (ORA-26656)
- Referenced Symbol Count is Undefined Error libclntsh.so.11.1
- Resolving Timestamp Errors Due to ISO 8601 Timestamps
- Fixing Failed Upgrades Where Only Datapatch Fails
- Rerunning Upgrades for Oracle Database
- Restarting the Upgrade from a Specific Phase that Failed Using -p
-
4
Post-Upgrade Tasks for Oracle Database
- Check the Upgrade With Post-Upgrade Status Tool
- How to Show the Current State of the Oracle Data Dictionary
-
Required Tasks to Complete After Upgrading Oracle Database
- Setting Environment Variables on Linux and UNIX Systems After Manual Upgrades
- Recompiling All Invalid Objects
- Recompiling All Invalid Objects on Multitenant Architecture Databases
- Track Invalid Object Recompilation Progress
- Running OPatch Commands After Upgrading Oracle Database
- Setting oratab and Scripts to Point to the New Oracle Location After Upgrading Oracle Database
- Check PL/SQL Packages and Dependent Procedures
- Upgrading Tables Dependent on Oracle-Maintained Types
- Enabling the New Extended Data Type Capability
- Adjusting Minimum and Maximum for Parallel Execution Servers
- About Recovery Catalog Upgrade After Upgrading Oracle Database
- Upgrading the Time Zone File Version After Upgrading Oracle Database
- Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
- Upgrading Externally Authenticated SSL Users After Upgrading Oracle Database
- Configuring the FTP and HTTP Ports and HTTP Authentication for Oracle XML DB
- Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database
- Rebuild Oracle Text Indexes Using AUTO_LEXER
- Update Oracle Application Express Configuration After Upgrading Oracle Database
- Configure Access Control Lists (ACLs) to External Network Services
- Enabling Oracle Database Vault After Upgrading Oracle Database
- Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
- Required Environment Variable Checks After Oracle Grid Infrastructure Upgrades
- Role-Allocated Software Owners and Database Upgrade After Oracle ASM Upgrade
-
Recommended and Best Practices to Complete After Upgrading Oracle Database
- Back Up the Database
- Running Postupgrade Fixup Scripts
- Gathering Dictionary Statistics After Upgrading
- Regathering Fixed Objects Statistics with DBMS_STATS
- Reset Passwords to Enforce Case-Sensitivity
- Understand Oracle Grid Infrastructure, Oracle ASM, and Oracle Clusterware
- Oracle Grid Infrastructure Installation and Upgrade and Oracle ASM
- Add New Features as Appropriate
- Develop New Administrative Procedures as Needed
- Set Threshold Values for Tablespace Alerts
- Migrating From Rollback Segments To Automatic Undo Mode
- Configure Oracle Data Guard Broker
- Migrating Tables from the LONG Data Type to the LOB Data Type
-
Migrate Your Upgraded Oracle Databases to Use Unified Auditing
- Understanding Unified Auditing Migration Process for Oracle Database
- Migrating to Unified Auditing for Oracle Database
- About Managing Earlier Audit Records After You Migrate to Unified Auditing
- Removing the Unified Auditing Functionality
- Obtaining Documentation References if You Choose Not to Use Unified Auditing
- Dropping and Recreating DBMS_SCHEDULER Jobs
- Transfer Unified Audit Records After the Upgrade
- About Testing the Upgraded Production Oracle Database
- Recommended Tasks After Upgrading an Oracle RAC Database
- Recommended Tasks After Upgrading Oracle ASM
- Recommended Tasks After Upgrading Oracle Database Express Edition
- Oracle Application Express PDB Plugin Considerations
-
Tasks to Complete Only After Manually Upgrading Oracle Database
- Changing Passwords for Oracle Supplied Accounts
- Create or Migrate Your Password File with ORAPWD
- Migrating Your Initialization Parameter File to a Server Parameter File
- Identifying and Copying Oracle Text Files To a New Oracle Home
- Upgrading the Oracle Clusterware Configuration
- Adjust the Initialization Parameter File for the New Release
- Set CLUSTER_DATABASE Initialization Parameter For Oracle RAC After Upgrade
-
5
Upgrading Applications After Upgrading Oracle Database
- Overview of Upgrading Applications on a New Oracle Database Release
- Compatibility Issues for Applications on Different Releases of Oracle Database
- Software Upgrades and Client and Server Configurations for Oracle Database
- Compatibility Rules for Applications When Upgrading Oracle Database Client or Server Software
- About Upgrading Precompiler and OCI Applications in Oracle Database
- About Upgrading Options for Oracle Precompiler and OCI Applications
- Upgrading SQL*Plus Scripts and PL/SQL after Upgrading Oracle Database
- About Upgrading Oracle Forms or Oracle Developer Applications
-
6
Downgrading Oracle Database to an Earlier Release
- Supported Releases for Downgrading Oracle Database
- Check for Incompatibilities When Downgrading Oracle Database
- Perform a Full Backup Before Downgrading Oracle Database
- Performing Required Predowngrade Steps for Oracle Database
- Downgrading a CDB or Non-CDB Oracle Database
- Downgrading a Single Pluggable Oracle Database (PDB)
- Downgrading PDBs That Contain Oracle Application Express
-
Post-Downgrade Tasks for Oracle Database Downgrades
- Oracle XML DB Authentication Recommendations for an Oracle Database Downgrade
- Re-enabling Oracle Database Vault after Downgrading Oracle Database
- Restoring the Configuration for Oracle Clusterware
-
Restoring Oracle Enterprise Manager after Downgrading Oracle Database
- Requirements for Restoring Oracle Enterprise Manager After Downgrading
-
Running EMCA to Restore Oracle Enterprise Manager After Downgrading
- Running emca on a Single-Instance Oracle Database Without Oracle ASM
- Running EMCA on an Oracle RAC Database Without Oracle ASM
- Running EMCA on a Single-Instance Oracle ASM Instance
- Running emca on an Oracle ASM on Oracle RAC Instance
- Running emca on a Single-Instance Oracle Database With Oracle ASM
- Running emca on an Oracle RAC Database and Oracle ASM Instance
- Running the emdwgrd utility to restore Enterprise Manager Database Control
- Restoring Oracle Application Express to the Earlier Release
- Gathering Dictionary Statistics After Downgrading
- Regathering Fixed Object Statistics After Downgrading
- Regathering Stale CBO Statistics After Downgrade
-
Troubleshooting the Downgrade of Oracle Database
- Errors Downgrading Oracle Database Components with catdwgrd.sql Script
- Oracle Multimedia Downgrade and imrelod.sql Script Error
- Oracle Database Vault and dvrelod.sql Script Error
- Downgrading Oracle Grid Infrastructure (Oracle Restart) After Successful or Failed Upgrade
- Oracle ACFS and Oracle Grid Infrastructure Downgrades to 11g Release 2 (11.2)
- Database Links Passwords After Downgrading Oracle Database 11g Release 1 (11.1)
- 7 Migrating Data Using Oracle Data Pump
-
8
Behavior Changes, Deprecated and Desupported Features for Oracle Database 12c Release 2 (12.2)
- Initialization Parameter Changes in Oracle Database 12c Release 2 (12.2)
-
Deprecated Features in Oracle Database 12c Release 2 (12.2)
- Deprecation of ALTER TYPE REPLACE
- Deprecation of configToolAllCommands Script
- Deprecation of DBMS_DEBUG Package
- Deprecation of DBMS_JOB Package
- Deprecation of Intelligent Data Placement (IDC)
- Deprecation of CONTINUOUS_MINE Option
- Deprecation of Non-CDB Architecture
- Deprecation of Oracle Administration Assistant for Windows
- Deprecation of Oracle Data Provider for .NET PromotableTransaction Setting
- Deprecation of oracle.jdbc.OracleConnection.unwrap()
- Deprecation of oracle.jdbc.rowset Package
- Deprecation of oracle.sql.DatumWithConnection Classes
- Deprecation of Oracle Multimedia Java APIs
- Deprecation of Oracle Multimedia Support for DICOM
- Deprecation of Multimedia SQL/MM Still Image Standard Support
- Deprecation of Unicode Collation Algorithm (UCA) 6.1 Collations
- Deprecation of UNIFIED_AUDIT_SGA_QUEUE_SIZE
- Deprecation of VERIFY_FUNCTION and VERIFY_FUNCTION_11G
- Deprecation of V$MANAGED_STANDBY
- Deprecation of Some XML DB Functions
-
Desupported Features in Oracle Database 12c Release 2 (12.2)
- Desupport of Advanced Replication
- Desupport of Direct File System Placement for OCR and Voting Files
- Desupport of JPublisher
- Desupport of preupgrd.sql and utluppkg.sql
- Desupported Oracle Data Provider for .NET APIs for Transaction Guard
- Desupported Views in Oracle Database 12c Release 2 (12.2)
- SQLJ Support Inside Oracle Database
- Desupport of Some XML DB Features
- Database Upgrade Assistant (DBUA) Enhancements and Changes
- Enhancements to Oracle Data Guard Broker and Rolling Upgrades
- About Changes in Default SGA Permissions for Oracle Database
- Network Access Control Lists and Upgrade to Oracle Database 12c
- Parallel Upgrade Utility Batch Scripts
- Unified Auditing AUDIT_ADMIN and AUDIT_VIEWER Roles Changes
- Oracle Update Batching Batch Size Settings Disabled
- About Upgrading Tables Dependent on Oracle-Maintained Types
- Case-Insensitive Passwords and ORA-1017 Invalid Username or Password
- About Deploying Oracle Grid Infrastructure Using Rapid Home Provisioning
- Restrictions Using Zero Data Loss Recovery Appliance Release 12.1 Backups
-
A
Changes for Earlier Releases of Oracle Database
-
Behavior Changes in Oracle Database 12c Release 1 (12.1)
-
Oracle Database Changes
- Deprecation of Non-CDB Architecture
- Deprecation of catupgrd.sql Script and Introduction of Parallel Upgrade Utility
- Error Associated with catupgrd.sql Run Without PARALLEL=NO
- Desupport of Oracle Enterprise Manager Database Control
- Changes for Deinstallation and Cleanup of Oracle Base
- Identifying Deprecated and Desupported Parameters
- Deprecated Oracle Database Roles
- Deprecated Views
- Deprecation of Oracle Streams
- Deprecation of Advanced Replication
- Deprecation of Single-Character SRVCTL CLI Options
- Desupported Features on Microsoft Windows Platforms
- Desupport of Oracle Cluster File System (OCFS) on Windows
- Desupport for Raw Storage Devices
- About Upgrading Oracle Database Release 10.2 or 11.1 and OCFS and RAW Devices
- Desupport of cluvfy comp cfs for OCFS
- Deprecation of Stored List of Administrative Users for Cluster Administration
- Deprecation of -checkpasswd for QOSCTL Quality of Service (QoS) Command
- Change to VARCHAR2, NVARCHAR2, and RAW Datatypes
-
Oracle JDBC and SQLJ Deprecated and Desupported Features
- Deprecation of SQLJ Inside the Server
- Deprecated Oracle Update Batching
- Deprecated EndToEndMetrics-related APIs
- Deprecated Stored Outlines
- Deprecated Concrete Classes in oracle.sql Package
- Deprecated defineColumnType Method
- Deprecated CONNECTION_PROPERTY_STREAM_CHUNK_SIZE Property
- Desupported Implicit Connection Caching
- Deprecated Features for Oracle Call Interface
- Changed Default for RESOURCE_LIMIT Parameter
-
Oracle Database Security Changes
- Oracle Business Intelligence and Data Warehousing Changes
- Changes to Security Auditing Features
- Deprecated Functions and Parameters in Oracle Label Security
- Deprecated DBMS_NETWORK_ACL_ADMIN PL/SQL package Procedures
- Deprecation of IGNORECASE and SEC_CASE_SENSITIVE_LOGON
- Deprecation of SQLNET.ALLOWED_LOGON_VERSION Parameter
- Upgrading a System that Did Not Have SQLNET.ALLOWED_LOGON_VERSION Parameter Setting
- Deprecation of Windows NTS Authentication Using the NTLM Protocol
- Deprecation of Public Key Infrastructure for Transparent Data Encryption
- Desupported Cipher Suites for Secure Sockets Layer (SSL)
- Desupport of Database Rules Manager (RUL) and Expression Filter (EXF)
- Oracle Data Guard Broker Deprecated or Desupported Features
- Oracle Data Pump Export Utility Deprecated or Desupported Features
- Oracle Database Vault Deprecated or Desupported Features
- Oracle Database Semantic Technologies Deprecated or Desupported Features
- Oracle Globalization Support Deprecated or Desupported Features
- Oracle Multimedia Deprecated or Desupported Features
-
Oracle Net Services Deprecated or Desupported Features
- Desupport of Oracle Net Connection Pooling
- Desupport of Oracle Names
- Desupport of Oracle Net Listener Password
- Desupport of SQLNET.KERBEROS5_CONF_MIT Parameter for Oracle Net Services
- Desupport of Oracle Names Control Utility for Oracle Net Services
- Deprecated NT LAN Manager (NTLM) Protocol for Oracle Net Services
- Oracle Text Deprecated and Desupported Features
- Oracle XML Database Changes
-
Oracle Database Changes
-
Behavior Changes in Oracle Database 11g Release 2 (11.2)
- Deprecation of Oracle Net Listener SNMP Support in Oracle Database 11g Release 2 (11.2)
- Changes to PL/SQL Procedures in Oracle Database 11g Release 2 (11.2)
- JOB_QUEUE_PROCESSES Parameter and Scheduling Jobs in Oracle Database 11g Release 2 (11.2)
- Deprecated XML DB Constructs in Oracle Database 11g Release 2 (11.2)
- CURSOR_SHARING=SIMILAR Deprecated in Oracle Database 11g Release 2 (11.2)
- Planned Desupport of Change Data Capture in Oracle Database 11g Release 2 (11.2)
- Deprecation of Data Mining Java API in Oracle Database 11g Release 2 (11.2)
- Identifying Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)
- Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)
- Initialization Parameters Desupported in Oracle Database 11g Release 2 (11.2)
- Static Data Dictionary Views Deprecated in Oracle Database 11g Release 2 (11.2)
- Dynamic Performance Views Deprecated in Oracle Database 11g Release 2 (11.2)
- Deprecated Features in Oracle Database 11g Release 2 (11.2)
- Changes to LOG_ARCHIVE_DEST_n Parameters in Oracle Database 11g Release 2 (11.2)
-
Behavior Changes in Oracle Database 12c Release 1 (12.1)
- B Oracle Database Upgrade Utilities
- Index