Table of Contents

• List of Examples
• List of Figures
• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documentation
  • Conventions
• Changes in This Release for Oracle Database Upgrade Guide
  • Changes in Oracle Database 18c
    • New Features
    • Deprecated Features
    • Desupported Features
• 1 Introduction to Upgrading Oracle Database
  • Overview of Oracle Database Upgrade Tools and Processes
    • Definition of Terms Upgrading and Migrating
    • Upgrade and Data Migration Methods and Processes
    • Oracle Database Releases That Support Direct Upgrade
    • Where to Find the Latest Information About Upgrading Oracle Database
  • 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
    • Databases in Multiple Oracle Homes on Separate Computers
    • Databases in Multiple Oracle Homes on the Same Computer
    • About the Optimal Flexible Architecture Standard
    • About Multiple Oracle Homes Support
  • 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
      • About Oracle GoldenGate and Online Database Upgrade
      • Overview of Steps for Upgrading Oracle Database Using Oracle GoldenGate
    • 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
    • About Upgrading Your Operating System
    • Options for Transporting Data to a Different Operating System
• 2 Preparing to Upgrade Oracle Database
  • About Read-Only Oracle Homes
  • About Image-Based Oracle Database Installation
  • Tasks to Prepare for Oracle Database Upgrades
    • Become Familiar with New Oracle Database Features
    • Choose an Upgrade Method for Oracle Database
      • The Graphical User Interface Method for Upgrading Oracle Database
      • The Manual, Command-Line Method for Upgrading Oracle Database
      • The Export/Import Method for Migrating Data When Upgrading Oracle Database
        • The Effects of Export/Import on Upgraded Oracle Databases
        • Export/Import Benefits for Migrating Data for Oracle Database
        • Time Requirements for Migrating Data and Upgrading with Export/Import
    • 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
        • Database Replay and Performance Testing
        • SQL Performance Analyzer
        • SQL Plan Management
      • 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
  • Pre-Upgrade Information Check with AutoUpgrade
  • Installing the New Oracle Database Software for Single Instance
  • Installing the New Oracle Database Software for Oracle RAC
  • Database Preparation Tasks to Complete Before Starting Oracle Database Upgrades
    • Patch Set Updates and Requirements for Upgrading Oracle Database
    • 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 Tablespaces
  • Preparing for Database Rolling Upgrades Using Oracle Data Guard
  • 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
    • Preupgrade Scripts Generated By the Pre-Upgrade Information Tool
    • Postupgrade Scripts Generated By 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 Output Example
    • Pre-Upgrade Information Tool Warnings and Recommendations for Oracle Database
      • Updating Access Control Lists and Network Utility Packages
      • Evaluate Dependencies and Add ACLs for Network Utility Packages
      • About Database Links with Passwords from Earlier Oracle Database Releases
      • About Oracle Database Warnings for TIMESTAMP WITH TIME ZONE Data Type
  • Testing the Upgrade Process for Oracle Database
    • Example of Testing Upgrades Using Priority List Emulation
    • Upgrade Oracle Call Interface (OCI) and Precompiler Applications
  • Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault
    • Audit Table Preupgrade and Archive Requirements
    • Oracle Database Vault and Upgrades of Oracle Database Release 11.2
    • Granting the DV_PATCH_ADMIN Role to SYS for Oracle Database Vault
• 3 Upgrading Oracle Database
  • Backing Up Oracle Database for Upgrading
  • Upgrading with Parallel Upgrade Utility (catctl.pl and dbupgrade Shell Command)
    • About the Parallel Upgrade Utility for Oracle Database (CATCTL.PL and DBUPGRADE)
    • General Steps for Running the Parallel Upgrade Utility
    • Parallel Upgrade Utility (catctl.pl) Parameters
    • Example of Using the Parallel Upgrade Utility
  • 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 Oracle Home
    • Using DBUA in Silent Mode to Upgrade Oracle Database
      • Running DBUA in Silent Mode
      • DBUA Command-Line Syntax for Silent Mode
  • Upgrade Scenarios for Non-CDB Oracle Databases
    • About Upgrading Non-CDB Oracle Databases
    • Manually Upgrading Non-CDB Architecture Oracle Databases
    • Upgrading a Non-CDB Oracle Database To a PDB on a CDB
    • Upgrading a Non-CDB Oracle Database Using Rapid Home Provisioning
    • Variables for Using ORADIM When Upgrading Oracle Database on Windows
  • Example of Manual Upgrade of Windows Non-CDB Oracle Database 11.2.0.3
    • Preparing to Upgrade Windows Non-CDB Using Command-Line Utilities
    • Manually Upgrading Windows Non-CDB Using Command-Line Utilities
    • Running Postupgrade Fixup Scripts After Upgrading a Non-CDB Database
  • Manual Upgrade Scenarios for Multitenant Architecture Oracle Databases
    • About Oracle Multitenant Oracle Database Upgrades
    • Coordinate Upgrades of Proxy PDBs with Multitenant 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
      • About Upgrading Pluggable Databases (PDBs) In Parallel
      • Upgrading Multitenant Container Databases In Parallel
    • Upgrading Multitenant Architecture Sequentially Using Unplug-Plug
      • About Upgrading Pluggable Databases (PDBs) Sequentially
      • Unplugging the Earlier Release PDB from the Earlier Release CDB
      • Plugging in the Earlier Release PDB to the Later Release CDB
      • Upgrading the Earlier Release PDB to the Later Release
      • Use Inclusion or Exclusion Lists for PDB Upgrades
  • Improvements to Data Dictionary Upgrade and Upgrade Status Displays
    • Upgrading the Data Dictionary in Parallel with Parallel Upgrade Utility
    • Change to Upgrade Status Setting
    • Change to Status After Running the Re-compilation utlrp.sql Script
  • About Dbupgrade Scripts and catupgrd.sql in Earlier Releases of Oracle Database
  • About Transporting and Upgrading a Database (Full Transportable Export/Import)
  • 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
    • Resolving issues with view CDB_JAVA_POLICY
    • Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
    • Component Status and Upgrades
      • Understanding Component Status With the Post-Upgrade Status Tool
      • Component OPTION OFF Status and Upgrades
      • Example of an Upgrade Summary Report
    • 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 Can 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
    • Error "Timezone Datafiles May Not Be Downgraded To a Lower Version"
    • Fixing Failures to Complete Registration of Listeners with DBUA
  • Rerunning Upgrades for Oracle Database
    • About Rerunning Upgrades for Oracle Database
    • Rerunning Upgrades with the Upgrade (catctl.pl) Script
    • Options for Rerunning the Upgrade for Multitenant Databases (CDBs)
      • Rerun the Entire Upgrade for the CDB
      • Rerun the Upgrade Only on Specified CDBs
      • Rerun the Upgrade While Other PDBs Are Online
      • Rerun the Upgrade Using an Inclusion List to Specify a CDB or PDBs
  • Restarting the Upgrade from a Specific Phase that Failed Using -p
    • Reviewing CDB Log Files for Failed Phases
    • Reviewing Non-CDB Log Files for Failed Phases
    • Procedure for Finding and Restarting Multitenant Upgrades from a Failed Phase
• 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
      • Upgrading Oracle Database Without Disabling Oracle Database Vault
      • Common Upgrade Scenarios with Oracle Database Vault
    • Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
  • 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
    • Finding and Resetting User Passwords That Use the 10G Password Version
    • 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
    • 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
    • Identify Oracle Text Indexes for Rebuilds
    • Dropping and Recreating DBMS_SCHEDULER Jobs
    • Transfer Unified Audit Records After the Upgrade
      • About Transferring Unified Audit Records After an Upgrade
      • Transferring Unified Audit Records After an Upgrade
    • About Testing the Upgraded Production Oracle Database
  • Recommended Tasks After Upgrading an Oracle RAC Database
  • Recommended Tasks After Upgrading Oracle ASM
    • Create a Shared Password File In the ASM Diskgroup
    • Reset Oracle ASM Passwords to Enforce Case-Sensitivity
    • Advancing the Oracle ASM and Oracle Database Disk Group Compatibility
    • Set Up Oracle ASM Preferred Read Failure Groups
  • Recommended Tasks After Upgrading Oracle Database Express Edition
  • 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
      • Setting the COMPATIBLE Initialization Parameter After Upgrade
      • Adjust TNSNAMES.ORA and LISTENER Parameters After Upgrade
    • Set CLUSTER_DATABASE Initialization Parameter For Oracle RAC After Upgrade
  • Patch Set Updates and Requirements for Upgrading Oracle Database
• 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
    • Possible Client and Server Configurations for Oracle Database
    • Types of Software Upgrades for Oracle Database Client and Server Software
  • Compatibility Rules for Applications When Upgrading Oracle Database Client or Server Software
    • Rules for Upgrading Oracle Database Server Software
      • If You Do Not Change the Client Environment, Then You Are Not Required to Relink
      • Applications Can Run Against Newer or Older Oracle Database Server Releases
    • Upgrading the Oracle Database Client Software
      • About Linking Applications with Newer Libraries
      • Statically Linked Applications Must Always Be Relinked
      • About Relinking Dynamically Linked Applications
  • About Upgrading Precompiler and OCI Applications in Oracle Database
  • About Upgrading Options for Oracle Precompiler and OCI Applications
    • Option 1: Leave the Application Unchanged
    • Option 2: Precompile or Compile the Application Using the New Software
    • Option 3: Change the Application Code to Use New Oracle Database Features
    • Changing Oracle Precompiler and OCI Application Development Environments
      • Changing Precompiler Applications
      • Changing 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
  • About Downgrades and Invalid Objects with Component Status OPTION OFF
  • 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
    • Reapply Release Update and Other Patches After 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)
      • ORA-00600 Errors with Database Links Passwords After Downgrading to Oracle Database 11.1 Release 1
      • Using Oracle Data Pump Export to Create a Dump File Containing All Existing Database Links
• 7 Migrating Data Using Oracle Data Pump
  • Overview of Data Pump and Export/Import For Migrating Data
  • Migrating Data With Oracle Data Pump Before Upgrades
  • Importing a Full Oracle Database Using a Network Link
  • Data Pump Requirements When Downgrading Oracle Database
• 8 Behavior Changes, Deprecated and Desupported Features for Oracle Database 18c
  • About Deprecated and Desupported Status
  • Simplified Image-Based Oracle Database Installation
  • Initialization Parameter Changes in Oracle Database 18c
    • STANDBY_ARCHIVE_DEST is Desupported
    • UNIFORM_LOG_TIMESTAMP_FORMAT Changes in INIT.ORA
    • Desupport of UTL_FILE_DIR Initialization Parameter
  • Deprecated Features in Oracle Database 18c
    • Data Guard MAX_CONNECTIONS Attribute is Deprecated
    • Extended Datatype Support (EDS) is Deprecated
    • GET_* Functions Deprecated in the DBMS_DATA_MINING Package
    • Package DBMS_XMLQUERY is deprecated
    • Package DBMS_XMLSAVE is Deprecated
    • Deprecated Columns in Oracle Label Security Views
    • Returning JSON True or False Values using NUMBER is Deprecated
    • Deprecation of MAIL_FILTER in Oracle Text
    • Deprecation of asmcmd showversion Option
    • Deprecation of NEWS_SECTION_GROUP in Oracle Text
    • Oracle Net Services Support for SDP is Deprecated
    • Deprecation of Oracle Multimedia
    • Deprecation of Flex Cluster (Hub/Leaf) Architecture
    • Deprecation of PRODUCT_USER_PROFILE Table
  • Desupported Features in Oracle Database 18c
    • Oracle Administration Assistant for Windows is Desupported
    • Oracle Multimedia DICOM Desupported Features
    • Oracle Multimedia Java Client Classes Desupported
    • Oracle XML DB Desupported Features
    • ODP.NET, Managed Driver - Distributed Transaction DLL Desupported
    • Data Guard Broker DGMGRL ALTER Syntax is Desupported
    • Desupport of CRSUSER on Microsoft Windows Systems
  • Terminal Release of Oracle Streams
  • Feature Changes for Oracle Database 18c Upgrade Planning
    • Support Indexing of JSON Key Names Longer Than 64 Characters
    • Upgrading Existing Databases is Replaced With Image Installations
    • RPM-Based Oracle Database Installation
    • Token Limitations for Oracle Text Indexes
    • Changes to /ALL/USER/DBA User View and PL/SQL External Libraries
    • Symbolic Links and UTL_FILE
    • Deprecation of Direct Registration of Listeners with DBCA
• A Changes for Earlier Releases of Oracle Database
  • Behavior Changes in Oracle Database 12c Release 2 (12.2.0.1)
    • Initialization Parameter Changes in Oracle Database 12c Release 2 (12.2)
      • Deprecated Initialization Parameters in Oracle Database 12c Release 2 (12.2)
      • Desupported Initialization Parameters in Oracle Database 12c Release 2 (12.2)
      • Initialization Parameter Default 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
      • Desupport of MAX_SHARED_TEMP_SIZE
    • Client and Foreground Server Process Memory Changes
    • 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 and Maintenance
    • Restrictions Using Zero Data Loss Recovery Appliance Release 12.1 Backups
  • 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
        • Change for Standalone Deinstallation Tool
        • Desupport of CLEANUP_ORACLE_BASE Property
        • Deprecation of -cleanupOBase
      • Identifying and Dropping Deprecated and Desupported Parameters
        • SEC_CASE_SENSITIVE_LOGON Initialization Parameter Deprecated
        • FILE_MAPPING Initialization Parameter Deprecated
        • RDBMS_SERVER_DN Initialization Parameter Deprecated
      • Deprecated Oracle Database Roles
        • DELETE_CATALOG_ROLE Deprecated
      • 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 COM Automation on Windows
        • Desupport of Oracle Objects for OLE
        • Desupport of Oracle Counters for Windows Performance Monitor
        • Programming Interface Deprecations for Oracle Data Provider for .NET
      • 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
      • Direct NFS Enabled By Default for Oracle RAC
    • Oracle Database Security Changes
      • Oracle Business Intelligence and Data Warehousing Changes
        • Oracle Warehouse Builder (OWB) Not Installed with Oracle Database
        • Desupport of Change Data Capture
        • Desupported Features in Oracle Data Mining
        • Desupport of ABN Models for Oracle Data Mining Upgrades
        • Desupport of OLAP Catalog (AMD)
      • 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
        • Deprecated Default Rule Sets for Oracle Database Vault
        • Deprecated Default Realms for Oracle Database Vault
        • Deprecated API for Oracle Database Vault
      • Oracle Database Semantic Technologies Deprecated or Desupported Features
        • VPD Support in Oracle Database Semantic Technologies
        • Version-Enabled Models Support In Oracle Database Semantic Technologies
    • Oracle Globalization Support Deprecated or Desupported Features
      • Desupport of CSSCAN and CSALTER for Oracle Globalization
    • 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
      • Desupport of CTXXPATH in Oracle Text and Oracle XML DB
      • Desupport of ALTER INDEX OPTIMIZE for Text Indexes
      • Desupport of SYNC [MEMORY memsize] for Text Indexes
    • Oracle XML Database Changes
      • Oracle XML DB is Mandatory and Cannot Be Uninstalled
      • Deprecated Features for Oracle XML Database
• B Oracle Database Upgrade Utilities
  • Scripts for Upgrading Oracle Database
• Index