1/104

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Changes in This Release for Oracle Database Upgrade Guide

• Changes in Oracle Database 12c Release 2 (12.2)
  • New Features
  • Deprecated Features
  • Desupported Features
• Changes in Oracle Database 12c Release 1 (12.1)
  • New Features
  • Deprecated Features
  • Desupported Features

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

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

• Tasks to Prepare for Oracle Database Upgrades
  • Become Familiar with New Oracle Database Features
  • Choose an Upgrade Method for Oracle Database
    • The Automated (DBUA) 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
• Checklists for Oracle Database Upgrade
  • Source Server Preparation Upgrade Checklist
  • Target Server Post-Upgrade Checklist
• 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
  • Relocate Existing Data Files to the New Oracle Database Environment
  • 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
  • Removing the Unified Auditing Schema and Roles
  • 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
    • 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
  • Pre-Upgrade Information Tool Output Example
• Testing the Upgrade Process for Oracle Database
  • Example of Testing Upgrades Using Priority List Emulation
  • Upgrade Oracle Call Interface (OCI) and Precompiler Applications
• 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
  • Audit Table Preupgrade and Archive Requirements
  • Running olspreupgrade.sql on Oracle Database Release 11.2
• Requirement for Upgrading Databases that Use Oracle Warehouse Builder (OWB)
  • Add Oracle Database 12c Access to Existing standalone OWB 11.2.0.3 Installation
  • Keep Existing OWB 11.2.0.3 Installation In-place with Oracle Database Release 11.2.0.3
  • Use the Standalone OWB 11.2.0.3 Installation Where Available

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 12c 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 from 11.2.0.1 to 12.2
• 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
    • 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)
• 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
  • 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
    • 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 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
  • 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
  • Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
• Required Environment Variable Checks After Oracle Grid Infrastructure Upgrades
  • User Environment Variables for Grid Infrastructure Installations
• Role-Allocated Software Owners and Database Upgrade After Oracle ASM Upgrade
  • About Migrating Operating System Users for Existing Oracle ASM Installation Owners
  • Keeping the Existing User as the Oracle ASM Operating System User
  • Changing the Operating System User for Single-Instance Oracle ASM
  • Changing the Operating System User for an Oracle RAC Database
• Recommended and Best Practices to Complete After Upgrading Oracle Database
  • Back Up the Database
  • Running the postupgrade_fixups.sql Script
  • 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
  • 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
  • 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
• 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
    • 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

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
  • Evaluation of Numeric Literals
• 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)
    • 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 12c Release 2 (12.2)

• 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
• 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
      • Change for Standalone Deinstallation Tool
      • Desupport of CLEANUP_ORACLE_BASE Property
      • Deprecation of -cleanupOBase
    • Identifying 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
  • 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
• 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)

B Oracle Database Upgrade Utilities

• Scripts for Upgrading Oracle Database

Index