1/14

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

Changes in This Release for Oracle Database Upgrade Guide

• New Features
• Deprecated Features
• Desupported Features

1 Introduction to Upgrading Oracle Database

• 1.1 Overview of Oracle Database Upgrade Tools and Processes
  • 1.1.1 Upgrade and Data Migration Methods and Processes
  • 1.1.2 Scripts for Upgrading Oracle Database
  • 1.1.3 About Log File Location and DIAGNOSTIC_DEST
• 1.2 Where to Find the Latest Information About Upgrading Oracle Database
• 1.3 Oracle Database Releases That Support Direct Upgrade
• 1.4 Major Steps in the Upgrade Process for Oracle Database
• 1.5 About Oracle Database Release Numbers
  • 1.5.1 Convention for Referring to Release Numbers in Oracle Database Upgrade Guide
• 1.6 About Running Multiple Oracle Releases
  • 1.6.1 Databases in Multiple Oracle Homes on the Same Computer
  • 1.6.2 Databases in Multiple Oracle Homes on Separate Computers
• 1.7 Compatibility and Interoperability between Oracle Database Releases
  • 1.7.1 What Is Oracle Database Compatibility?
    • 1.7.1.1 The COMPATIBLE Initialization Parameter in Oracle Database
    • 1.7.1.2 Values for the COMPATIBLE Initialization Parameter in Oracle Database
    • 1.7.1.3 Compatibility and Oracle Database File System (DBFS)
    • 1.7.1.4 About Downgrading and Compatibility for Upgrading Oracle Database
    • 1.7.1.5 How the COMPATIBLE Initialization Parameter Operates in Oracle Database
    • 1.7.1.6 Checking the Compatibility Level of Oracle Database
    • 1.7.1.7 When to Set the COMPATIBLE Initialization Parameter in Oracle Database
  • 1.7.2 What Is Interoperability for Oracle Database Upgrades?
• 1.8 Optimal Flexible Architecture (OFA) and Oracle Database Installations
• 1.9 Converting 32-bit Oracle Database to 64-bit Oracle Database
• 1.10 About Rolling Upgrades for Oracle ASM and Oracle RAC Databases
  • 1.10.1 Summary of Methods for Performing Rolling Upgrades for Oracle Database
• 1.11 Moving From Standard Edition to Enterprise Edition of Oracle Database
• 1.12 Moving from Enterprise Edition to Standard Edition of Oracle Database
• 1.13 Moving from Oracle Database Express Edition (Oracle Database XE) to Oracle Database

2 Preparing to Upgrade Oracle Database

• 2.1 Tasks for Preparing to Upgrade Oracle Database
  • 2.1.1 Become Familiar with New Oracle Database Features
  • 2.1.2 Determine the Upgrade Path for Oracle Database
  • 2.1.3 Choose an Upgrade Method for Oracle Database
    • 2.1.3.1 The Automated (DBUA) Method for Upgrading Oracle Database
    • 2.1.3.2 The Manual, Command-line Method for Upgrading Oracle Database
    • 2.1.3.3 The Export/Import Method for Migrating Data When Upgrading Oracle Database
  • 2.1.4 Choose a New Location for Oracle Home when Upgrading
  • 2.1.5 Develop a Test Plan for Upgrading Oracle Database
    • 2.1.5.1 Upgrade Testing
    • 2.1.5.2 Minimal Testing
    • 2.1.5.3 Functional Testing
    • 2.1.5.4 High Availability Testing
    • 2.1.5.5 Integration Testing
    • 2.1.5.6 Performance Testing
    • 2.1.5.7 Volume and Load Stress Testing for Oracle Database Upgrades
  • 2.1.6 Prepare a Backup Strategy before Upgrading Oracle Database
• 2.2 Requirements for Upgrading Oracle Database
  • 2.2.1 Relocating Existing Data Files to the New Oracle Database Environment
  • 2.2.2 About Upgrading PL/SQL Packages That Are Not Installed by Default
  • 2.2.3 Saving Oracle Enterprise Manager Database Control Configuration and Data
  • 2.2.4 Manually Removing DB Control with emremove.sql
  • 2.2.5 About Upgrading an Oracle ASM Instance
    • 2.2.5.1 Determining If Oracle ASM is Included in the Current Database Configuration
  • 2.2.6 About Upgrading Oracle Grid Infrastructure and Oracle Clusterware
    • 2.2.6.1 Oracle Clusterware Must Be Running on Local Node When Upgrading
    • 2.2.6.2 About Upgrading an Oracle Real Application Clusters (Oracle RAC) Database with DBUA
    • 2.2.6.3 About Upgrading and Inaccessible Nodes
    • 2.2.6.4 About Requirements for Time Synchronization on Oracle RAC
    • 2.2.6.5 Recommendations for Upgrading Oracle RAC and Oracle Databases That Use ASM
    • 2.2.6.6 About Upgrading System Authentication for Oracle ASM Instances
  • 2.2.7 About Upgrading with Read-Only and Offline Tablespaces
  • 2.2.8 About Upgrading Using Standby Databases
  • 2.2.9 About Upgrading Your Operating System
  • 2.2.10 Transporting Data to a Different Operating System
  • 2.2.11 About Oracle GoldenGate and Online Database Upgrade
    • 2.2.11.1 Overview of Steps for Upgrading Oracle Database Using Oracle GoldenGate
  • 2.2.12 About Upgrading Oracle OLAP Data Security Policies
  • 2.2.13 Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault
    • 2.2.13.1 Requirement for Upgrading Oracle Databases That Use Oracle Database Vault
    • 2.2.13.2 Running olspreupgrade.sql on Oracle Database Release 11.1.0.7
    • 2.2.13.3 Running olspreupgrade.sql on Oracle Database Release 10.2.0.5 or 11.2
  • 2.2.14 Requirement for Upgrading Databases that Use Oracle Warehouse Builder (OWB)
    • 2.2.14.1 Add Oracle Database 12c Access to Existing standalone OWB 11.2.0.3 Installation
    • 2.2.14.2 Keep Existing OWB 11.2.0.3 Installation In-place with Oracle Database Release 11.2.0.3
    • 2.2.14.3 Use the Standalone OWB 11.2.0.3 Installation Where Available
  • 2.2.15 Removing the Unified Auditing Schema and Roles
• 2.3 Installing the New Oracle Database Software
• 2.4 Patch Set Updates and Requirements for Upgrading Oracle Database
• 2.5 About the Pre-Upgrade Information Tool for Oracle Database
  • 2.5.1 Using the Pre-Upgrade Information Tool (preupgrd.sql)
  • 2.5.2 Pre-Upgrade Information Tool Warnings and Recommendations for Oracle Database
    • 2.5.2.1 Update Access Control Lists and Network Utility Packages
    • 2.5.2.2 Evaluate Dependencies and Add ACLs for Network Utility Packages
    • 2.5.2.3 About Database Links with Passwords from Earlier Oracle Database Releases
    • 2.5.2.4 About Oracle Database Warnings for TIMESTAMP WITH TIME ZONE Data Type
    • 2.5.2.5 Decrease Oracle Database Downtime by Gathering Optimizer Statistics
    • 2.5.2.6 Identify Invalid Objects in Oracle Database with the utluiobj Script
    • 2.5.2.7 Verify That Materialized View Refreshes Have Completed Before Upgrading
    • 2.5.2.8 Ensure That No Files Need Media Recovery Before Upgrading
    • 2.5.2.9 Ensure That No Files Are in Backup Mode Before Upgrading
    • 2.5.2.10 Resolve Outstanding Distributed Transactions Before Upgrading
    • 2.5.2.11 Purge the Database Recycle Bin Before Upgrading
    • 2.5.2.12 Synchronize the Standby Database with the Primary Database When Upgrading
    • 2.5.2.13 About Upgrading Oracle Application Express Databases
  • 2.5.3 Sample Output of the Pre-Upgrade Information Tool
• 2.6 Backing Up Oracle Database for Upgrading
• 2.7 Preparing the New Oracle Home for Upgrading
  • 2.7.1 Prerequisites for Preparing Oracle Home on Windows
• 2.8 Recommendations for Oracle Net Services When Upgrading Oracle Database
• 2.9 Testing the Upgrade Process for Oracle Database
  • 2.9.1 Upgrade Oracle Call Interface (OCI) and Precompiler Applications
• 2.10 Testing an Upgraded Test Copy of Oracle Database

3 Upgrading Oracle Database

• 3.1 Upgrade Strategies for Oracle Database
  • 3.1.1 Upgrading a Non-CDB Oracle Database
  • 3.1.2 Upgrading an Earlier Release and Plugging a PDB into a CDB
  • 3.1.3 Upgrading a Multitenant (CDB) Oracle Database
  • 3.1.4 Upgrading a Pluggable Database (PDB)
• 3.2 Upgrading with Oracle Database Upgrade Assistant (DBUA)
  • 3.2.1 Recommendations for Using DBUA
    • 3.2.1.1 About Stopping DBUA When Upgrading
  • 3.2.2 How DBUA Processes the Upgrade for Oracle Database
    • 3.2.2.1 Upgrade Scripts Invoked by DBUA
  • 3.2.3 Using DBUA to Upgrade the Database on Linux, UNIX, and Windows Systems
  • 3.2.4 About Windows Authentication When Upgrading
  • 3.2.5 Moving a Database from an Existing 12c Oracle Home
  • 3.2.6 Using DBUA in Silent Mode to Upgrade Oracle Database
    • 3.2.6.1 Oracle DBUA Command Line Options for Silent Mode
    • 3.2.6.2 DBUA Command Line Syntax for Silent Mode
• 3.3 About the Parallel Upgrade Utility for Oracle Database
  • 3.3.1 General Steps for Running the New Parallel Upgrade Utility (catctl.pl)
  • 3.3.2 Parallel Upgrade Utility (catctl.pl) Parameters
  • 3.3.3 Example for Using the Parallel Upgrade Utility
• 3.4 Manually Upgrading a Non-CDB Oracle Database
  • 3.4.1 Variables for using ORADIM When Upgrading Oracle Database on Windows
• 3.5 Manually Upgrading a Multitenant Container Oracle Database (CDB)
• 3.6 How the Data Dictionary is Upgraded and Status is Displayed
  • 3.6.1 Parallel Upgrading of Data Dictionary
  • 3.6.2 Change to Upgrade Status Setting
  • 3.6.3 Change to Status After Running the Re-compilation utlrp.sql Script
• 3.7 About the catupgrd.sql Script in Earlier Releases of Oracle Database
• 3.8 About the catuppst.sql Script
• 3.9 About Transporting and Upgrading a Database (Full Transportable Export/Import)
• 3.10 Troubleshooting the Upgrade for Oracle Database
  • 3.10.1 About Starting Oracle Database in Upgrade Mode
  • 3.10.2 Running DBUA with Different ORACLE_HOME Owner
  • 3.10.3 Oracle Database Upgrade Script Termination Errors
  • 3.10.4 Resource Limits for Upgrading Oracle Database
  • 3.10.5 SQL*Plus Edition Session Startup Error for Oracle Database
  • 3.10.6 Manual Workaround for ORA-01408 on Oracle Database Index
  • 3.10.7 Error ORA-00018 for DBCA Processes with Release 11.1.0.7 Databases
  • 3.10.8 Error ORA-00020 Maximum Number of Processes Exceeded When Running utlrp.sql
  • 3.10.9 Running the DBMS_DST Package After Upgrade Can Result in ORA-01822
  • 3.10.10 Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
  • 3.10.11 Understanding Component Status of the Post-Upgrade Status Tool
    • 3.10.11.1 Sample Upgrade Summary Report for the Post-Upgrade Status Tool (utlu121s.sql)
  • 3.10.12 Standard Edition Starter Database and Components with Status OPTION OFF
  • 3.10.13 Adjusting Oracle ASM Password File Location After Upgrade
  • 3.10.14 Error ORA-27248: sys.dra_reevaluate_open_failures is running
  • 3.10.15 Oracle Database Enterprise User Security, OLS-OID, and Provisioning Profile Error
  • 3.10.16 32K Migration Error with utl32k.sql and MAX_STRING_SIZE
  • 3.10.17 ASM Loses Rolling Migration State If CRS Shutdown On All Nodes
  • 3.10.18 Data Type Versioning Could Cause Cross-Version Replication (ORA-26656)
  • 3.10.19 Oracle XML DB Errors ORA-64123 and ORA-14097
• 3.11 Rerunning the Upgrade for Oracle Database
  • 3.11.1 Rerunning the Upgrade with the Upgrade (catctl.pl) Script
  • 3.11.2 Options for Rerunning the Upgrade for a Multitenant Database (CDB)
    • 3.11.2.1 Rerun the Entire Upgrade for the CDB
    • 3.11.2.2 Rerun the Upgrade Only on Specified CDBs
    • 3.11.2.3 Rerun the Upgrade While Other PDBs Are Online Using an Exclusion List
    • 3.11.2.4 Rerun the Upgrade Using an Inclusion List to Specify a CDB or PDBs
    • 3.11.2.5 Restarting the Upgrade from a Specific Phase that Failed Using -p

4 Post-Upgrade Tasks for Oracle Database

• 4.1 How to Show the Current State of the Oracle Data Dictionary
• 4.2 About OPatch Commands After Upgrading Oracle Database
• 4.3 Required Tasks to Complete After Upgrading Oracle Database
  • 4.3.1 Set Environment Variables on Linux and UNIX Systems After Manual Upgrades
  • 4.3.2 Set oratab and Scripts to Point to the New Oracle Location After Upgrading Oracle Database
  • 4.3.3 Enable the New Extended Data Type Capability
  • 4.3.4 Adjust Minimum and Maximum for Parallel Execution Servers
  • 4.3.5 Upgrade the Recovery Catalog After Upgrading Oracle Database
  • 4.3.6 Upgrade the Time Zone File Version After Upgrading Oracle Database
  • 4.3.7 Upgrade Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database
  • 4.3.8 Upgrade Externally Authenticated SSL Users After Upgrading Oracle Database
  • 4.3.9 Configure the FTP and HTTP Ports and HTTP Authentication for Oracle XML DB
  • 4.3.10 Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database
  • 4.3.11 Update Your Oracle Application Express Configuration After Upgrading Oracle Database
  • 4.3.12 Configure Access Control Lists (ACLs) to External Network Services
  • 4.3.13 Enable Oracle Database Vault After Upgrading Oracle Database
  • 4.3.14 Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior
• 4.4 Required Task After Oracle Grid Infrastructure Upgrades
  • 4.4.1 Using Environment Variables for Grid Infrastructure Installations
• 4.5 Requirement for Role-Allocated Software Owners and Database Upgrade After Oracle ASM Upgrade
  • 4.5.1 Keeping the Existing User as the Oracle ASM Operating System User
  • 4.5.2 Changing the Operating System User for Single-Instance Oracle ASM
  • 4.5.3 Changing the Operating System User for an Oracle RAC Database
• 4.6 Recommended and Best Practices to Complete After Upgrading Oracle Database
  • 4.6.1 Back Up the Database
  • 4.6.2 Run the postupgrade_fixups.sql Script
  • 4.6.3 Gather Fixed Objects Statistics with DBMS_STATS
  • 4.6.4 Reset Passwords to Enforce Case-Sensitivity
  • 4.6.5 Understand Changes with Oracle Grid Infrastructure
  • 4.6.6 Understand Oracle ASM and Oracle Grid Infrastructure Installation and Upgrade
  • 4.6.7 Add New Features as Appropriate
  • 4.6.8 Develop New Administrative Procedures as Needed
  • 4.6.9 Set Threshold Values for Tablespace Alerts
  • 4.6.10 Migrate From Rollback Segments to Automatic Undo Mode
  • 4.6.11 Configure Oracle Data Guard Broker
  • 4.6.12 Migrate Tables from the LONG Data Type to the LOB Data Type
  • 4.6.13 Migrate Your Upgraded Oracle Databases to Use Unified Auditing
    • 4.6.13.1 About the Unified Auditing Migration Process for Oracle Database
    • 4.6.13.2 Migrating to Unified Auditing for Oracle Database
    • 4.6.13.3 Managing Earlier Audit Records After You Migrate to Unified Auditing
    • 4.6.13.4 Removing the Unified Auditing Functionality
    • 4.6.13.5 Documentation References if You Choose Not to Use Unified Auditing
  • 4.6.14 Test the Upgraded Production Oracle Database
• 4.7 Recommended Tasks After Upgrading an Oracle RAC Database
• 4.8 Recommended Tasks After Upgrading Oracle ASM
  • 4.8.1 Create A Shared Password File in the ASM Diskgroup
  • 4.8.2 Reset Oracle ASM Passwords to Enforce Case-Sensitivity
  • 4.8.3 Advance the Oracle ASM and Oracle Database Disk Group Compatibility
  • 4.8.4 Set Up Oracle ASM Preferred Read Failure Groups
• 4.9 Recommended Tasks After Upgrading Oracle Database Express Edition
• 4.10 Optionally Update Oracle Application Express Packaged Applications
• 4.11 Tasks to Complete Only After Manually Upgrading Oracle Database
  • 4.11.1 Change Passwords for Oracle Supplied Accounts
  • 4.11.2 Create or Migrate Your Password File with ORAPWD
  • 4.11.3 Migrate Your Initialization Parameter File to a Server Parameter File
  • 4.11.4 Upgrade Oracle Text
  • 4.11.5 Upgrade the Oracle Clusterware Configuration
  • 4.11.6 Adjust the Initialization Parameter File for the New Release
    • 4.11.6.1 Setting the COMPATIBLE Initialization Parameter
    • 4.11.6.2 Configuring tnsnames.ora and Listener Parameters
  • 4.11.7 Set CLUSTER_DATABASE Initialization Parameter For Oracle RAC

5 Upgrading Applications After Upgrading Oracle Database

• 5.1 Overview of Upgrading Applications on a New Oracle Database Release
• 5.2 Compatibility Issues for Applications on Different Releases of Oracle Database
• 5.3 Upgrading Precompiler and OCI Applications in Oracle Database
• 5.4 Software Upgrades and Client and Server Configurations for Oracle Database
  • 5.4.1 Types of Software Upgrades for Oracle Database Client and Server Software
    • 5.4.1.1 Oracle Database Major Release Upgrade
    • 5.4.1.2 Oracle Database Maintenance Release Upgrade
  • 5.4.2 Possible Client and Server Configurations for Oracle Database
    • 5.4.2.1 Oracle Database Client and Server on Different Computers
    • 5.4.2.2 Oracle Database Client and Server in Different Oracle Locations on the Same Computer
    • 5.4.2.3 Oracle Database Client and Server in the Same Oracle Location
• 5.5 Compatibility Rules for Applications When Upgrading Oracle Database Client or Server Software
  • 5.5.1 Rules for Upgrading Oracle Database Server Software
    • 5.5.1.1 If You Do Not Change the Client Environment, Then You Are Not Required to Relink.
    • 5.5.1.2 Applications Can Run Against Newer or Older Oracle Database Server Releases
  • 5.5.2 Upgrading the Oracle Database Client Software
    • 5.5.2.1 Applications Can Be Linked with Newer Libraries
    • 5.5.2.2 Statically Linked Applications Must Always Be Relinked
    • 5.5.2.3 Relinking Dynamically Linked Applications
• 5.6 Upgrading Options for Oracle Precompiler and OCI Applications
  • 5.6.1 Option 1: Leave the Application Unchanged
  • 5.6.2 Option 2: Precompile or Compile the Application Using the New Software
  • 5.6.3 Option 3: Change the Application Code to Use New Oracle Database Features
    • 5.6.3.1 Changing Precompiler Applications
    • 5.6.3.2 Changing OCI Applications
• 5.7 Upgrading SQL*Plus Scripts and PL/SQL after Upgrading Oracle Database
  • 5.7.1 Evaluation of Numeric Literals
• 5.8 About Upgrading Oracle Forms or Oracle Developer Applications

6 Downgrading Oracle Database to an Earlier Release

• 6.1 Supported Releases for Downgrading Oracle Database
• 6.2 Checking for Incompatibilities When Downgrading Oracle Database
• 6.3 Performing a Full Backup Before Downgrading Oracle Database
• 6.4 Performing Required Pre-Downgrade Steps for Oracle Database
• 6.5 Downgrading a CDB or Non-CDB Oracle Database
• 6.6 Downgrading a Single Pluggable Oracle Database (PDB)
• 6.7 Post-Downgrade Tasks for Oracle Database Downgrades
  • 6.7.1 Oracle XML DB Authentication Recommendations for an Oracle Database Downgrade
  • 6.7.2 Re-creating the Network Listener When Downgrading to Release 11.1.0.7
  • 6.7.3 Re-enabling Oracle Database Vault after Downgrading Oracle Database
  • 6.7.4 Restoration of the Configuration for Oracle Clusterware
  • 6.7.5 Restoring Oracle Enterprise Manager after Downgrading Oracle Database
    • 6.7.5.1 Running the emdwgrd utility to restore Enterprise Manager Database Control
  • 6.7.6 Restoring Oracle Application Express to the Earlier Version
• 6.8 Troubleshooting the Downgrade of Oracle Database
  • 6.8.1 Oracle Multimedia Downgrade and imrelod.sql Script Error
  • 6.8.2 Oracle Database Vault and dvrelod.sql Script Error
  • 6.8.3 Downgrading Grid Infrastructure Standalone (Oracle Restart) After Successful or Failed Upgrade
  • 6.8.4 Issue with Downgrading Oracle ACFS and Oracle Grid Infrastructure
  • 6.8.5 Issue with Password for Database Links After Downgrading
    • 6.8.5.1 Using Oracle Data Pump Export to Create a Dump File Containing All Existing Database Links

7 Migrating Data Using Oracle Data Pump

• 7.1 Overview of Data Pump and Export/Import For Migrating Data
• 7.2 Migrating Data With Data Pump When Upgrading Oracle Database
  • 7.2.1 Importing a Full Oracle Database Using a Network Link
• 7.3 Data Pump Requirements When Downgrading Oracle Database

8 Deprecated and Desupported Features for Oracle Database 12c

• 8.1 Oracle Database Changes
  • 8.1.1 Deprecation of Non-CDB Architecture
  • 8.1.2 Deprecation of catupgrd.sql Script and Introduction of New catctl.pl Utility
  • 8.1.3 Desupport of Oracle Enterprise Manager Database Control
  • 8.1.4 Changes for Deinstallation and Cleanup of Oracle Base
    • 8.1.4.1 Change for Standalone Deinstallation Tool
    • 8.1.4.2 Desupport of CLEANUP_ORACLE_BASE Property
    • 8.1.4.3 Deprecation of -cleanupOBase
  • 8.1.5 Deprecated and Desupported Parameters
    • 8.1.5.1 LOG_ARCHIVE_LOCAL_FIRST
    • 8.1.5.2 SEC_CASE_SENSITIVE_LOGON
    • 8.1.5.3 FILE_MAPPING
    • 8.1.5.4 DELETE_CATALOG_ROLE of the O7_DICTIONARY_ACCESSIBILITY Parameter
    • 8.1.5.5 RDBMS_SERVER_DN
  • 8.1.6 Deprecated Views
  • 8.1.7 Deprecation of Oracle Streams
  • 8.1.8 Deprecation of Advanced Replication
  • 8.1.9 Deprecation of Single-Character SRVCTL CLI Options
  • 8.1.10 Desupported Features on Microsoft Windows Platforms
    • 8.1.10.1 Desupport of Oracle COM Automation on Windows
    • 8.1.10.2 Desupport of Oracle Objects for OLE
    • 8.1.10.3 Desupport of Oracle Counters for Windows Performance Monitor
    • 8.1.10.4 Changes for Oracle Data Provider for .NET
  • 8.1.11 Desupport of Oracle Cluster File System (OCFS) on Windows
    • 8.1.11.1 About Upgrading Oracle Database Release 10.2 or 11.1 and OCFS and RAW Devices
    • 8.1.11.2 Desupport of cluvfy comp cfs for OCFS
  • 8.1.12 Deprecation of Stored List of Administrative Users for Cluster Administration
  • 8.1.13 Desupport for Raw Storage Devices
  • 8.1.14 Deprecation of -checkpasswd for QOSCTL Quality of Service (QoS) Command
  • 8.1.15 Change to VARCHAR2, NVARCHAR2, and RAW Datatypes
  • 8.1.16 Deprecation of JPublisher
  • 8.1.17 Changes for Oracle JDBC and SQLJ
    • 8.1.17.1 Deprecation of SQLJ Inside the Server
    • 8.1.17.2 Deprecated Oracle Update Batching
    • 8.1.17.3 Deprecated EndToEndMetrics related APIs
    • 8.1.17.4 Deprecated Stored Outlines
    • 8.1.17.5 Deprecated Concrete Classes in oracle.sql Package
    • 8.1.17.6 Deprecated defineColumnType Method
    • 8.1.17.7 Deprecated CONNECTION_PROPERTY_STREAM_CHUNK_SIZE Property
    • 8.1.17.8 Desupported Implicit Connection Caching
  • 8.1.18 Changes for Oracle Call Interface
  • 8.1.19 Deprecation of Oracle Restart
  • 8.1.20 Changed Default for resource_limit Parameter
• 8.2 Oracle Business Intelligence and Data Warehousing Changes
  • 8.2.1 Oracle Warehouse Builder (OWB) Not Installed with Oracle Database
  • 8.2.2 Desupport of Change Data Capture
  • 8.2.3 Desupported Features in Oracle Data Mining
  • 8.2.4 Changes to Upgrading Oracle Data Mining Models
  • 8.2.5 Desupport of OLAP Catalog (AMD)
• 8.3 Oracle Database Security Changes
  • 8.3.1 Changes to Security Auditing Features
  • 8.3.2 Deprecations for Oracle Label Security
  • 8.3.3 Deprecated DBMS_NETWORK_ACL_ADMIN PL/SQL package Procedures
  • 8.3.4 Deprecation of IGNORECASE and SEC_CASE_SENSITIVE_LOGON
  • 8.3.5 Deprecation of SQLNET.ALLOWED_LOGON_VERSION Parameter
    • 8.3.5.1 Upgrading a System that Did Not Have SQLNET.ALLOWED_LOGON_VERSION Parameter Setting
  • 8.3.6 AUDIT_ADMIN and AUDIT_VIEWER Roles Note
  • 8.3.7 Deprecation of Windows NTS Authentication Using the NTLM Protocol
  • 8.3.8 Deprecation of Public Key Infrastructure for Transparent Data Encryption
  • 8.3.9 Desupported Cipher Suites for Secure Sockets Layer (SSL)
  • 8.3.10 Desupport of Database Rules Manager (RUL) and Expression Filter (EXF)
  • 8.3.11 Changes for Oracle Data Guard Broker
  • 8.3.12 Changes for Oracle Data Pump Export Utility
  • 8.3.13 Changes for Oracle Database Vault
    • 8.3.13.1 Deprecated Default Rule Sets
    • 8.3.13.2 Deprecated Default Realms
    • 8.3.13.3 Deprecated API
  • 8.3.14 Changes for Oracle Database Semantic Technologies
    • 8.3.14.1 VPD Support in Oracle Database Semantic Technologies
    • 8.3.14.2 Version-Enabled Models Support In Oracle Database Semantic Technologies
• 8.4 Oracle Globalization Support Changes
  • 8.4.1 Desupport of CSSCAN and CSALTER
• 8.5 Oracle Multimedia Changes
• 8.6 Oracle Net Services Changes
  • 8.6.1 Desupport of Oracle Net Connection Pooling
  • 8.6.2 Desupport of Oracle Names
  • 8.6.3 Desupport of Oracle Net Listener Password
  • 8.6.4 Desupport of SQLNET.KERBEROS5_CONF_MIT Parameter for Oracle Net Services
  • 8.6.5 Desupport of Oracle Names Control Utility for Oracle Net Services
  • 8.6.6 Deprecated NT LAN Manager (NTLM) Protocol for Oracle Net Services
• 8.7 Oracle XML Database Changes
  • 8.7.1 Oracle XML DB is Mandatory and Cannot Be Uninstalled
  • 8.7.2 Deprecated Features for Oracle XML Database
• 8.8 Oracle Text Changes
  • 8.8.1 Desupport of CTXXPATH in Oracle Text and Oracle XML DB
  • 8.8.2 Desupport of ALTER INDEX OPTIMIZE for Text Indexes
  • 8.8.3 Desupport of SYNC [MEMORY memsize] for Text Indexes

A Changes for Earlier Releases of Oracle Database

• A.1 Behavior Changes in Oracle Database 11g Release 2 (11.2)
  • A.1.1 Deprecation of SNMP Support in Oracle Net Listener
  • A.1.2 Changes to PL/SQL Procedures
  • A.1.3 JOB_QUEUE_PROCESSES Parameter and Scheduling Jobs
  • A.1.4 Deprecated XML DB Constructs
  • A.1.5 Cursor_sharing=similar Deprecated in Oracle Database
  • A.1.6 Planned Desupport of Change Data Capture
  • A.1.7 Deprecation of the Data Mining Java API
  • A.1.8 Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)
  • A.1.9 Initialization Parameters Desupported in Oracle Database 11g Release 2 (11.2)
  • A.1.10 Static Data Dictionary Views Deprecated in Oracle Database 11g Release 2 (11.2)
  • A.1.11 Dynamic Performance Views Deprecated in Oracle Database 11g Release 2 (11.2)
  • A.1.12 Deprecated Features in Oracle Database 11g Release 2 (11.2)
  • A.1.13 Changes to LOG_ARCHIVE_DEST_n Parameters
• A.2 Behavior Changes in Oracle Database 11g Release 1 (11.1)
  • A.2.1 Initialization Parameters Deprecated in Oracle Database 11g Release 1 (11.1)
  • A.2.2 Initialization Parameters Desupported in Oracle Database 11g Release 1 (11.1)
  • A.2.3 Static Data Dictionary Views with Dropped Columns in Oracle Database 11g Release 1 (11.1)
  • A.2.4 Deprecated Features in Oracle Database 11g Release 1 (11.1)
  • A.2.5 Automatic Maintenance Tasks Management
  • A.2.6 New SYSASM Privilege and OSASM Group for Oracle ASM Administration
  • A.2.7 ASM Disk Group Compatibility
  • A.2.8 COMPUTE STATISTICS and ESTIMATE STATISTICS Clauses
  • A.2.9 Oracle Data Mining Models and the DMSYS Schema Objects
  • A.2.10 Oracle Data Mining Scoring Engine
  • A.2.11 SQL Plan Management and Control of SQL Plan Baselines
  • A.2.12 Binary XML Support for Oracle XML Database
    • A.2.12.1 When Upgrading to Oracle Database 11g Release 1 (11.1)
  • A.2.13 PL/SQL Native Compilation and Access Control for Network Utility Packages
    • A.2.13.1 PL/SQL Native Compilation
    • A.2.13.2 Access Control for Network Utility Packages
  • A.2.14 PL/SQL Control Parameters
  • A.2.15 Change in WebDAV ACL Evaluation Rules in Oracle XML DB
  • A.2.16 Summary Management and SQL Access Advisor
  • A.2.17 SQL Access Advisor Tasks
  • A.2.18 Standard Edition Starter Database
  • A.2.19 Core Dump Location
  • A.2.20 New Default Value for UNDO_MANAGEMENT
  • A.2.21 LOG_ARCHIVE_DEST_n Parameters
  • A.2.22 SHARED_POOL_SIZE Parameter
  • A.2.23 JOB_QUEUE_PROCESSES Parameter New Default Setting
  • A.2.24 Automatic Diagnostic Repository
• A.3 Behavior Changes in Oracle Database 10g Release 2 (10.2)
  • A.3.1 Initialization Parameters Deprecated in Oracle Database 10g Release 2 (10.2)
  • A.3.2 Initialization Parameters Desupported in Oracle Database 10g Release 2 (10.2)
  • A.3.3 Static Data Dictionary Views with Dropped Columns in Oracle Database 10g Release 2 (10.2)
  • A.3.4 SQL
  • A.3.5 CONNECT Role
  • A.3.6 Time Zone Files
  • A.3.7 New Limit for FAILED_LOGIN_ATTEMPTS

Index