Go to main content
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 12
c
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 12
c
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
Invalid Object Warnings and DBA Registry Errors
3.10.5
Invalid Objects and Premature Use of Postupgrade Tool
3.10.6
Resource Limits for Upgrading Oracle Database
3.10.7
SQL*Plus Edition Session Startup Error for Oracle Database
3.10.8
Manual Workaround for ORA-01408 on Oracle Database Index
3.10.9
Error ORA-00018 for DBCA Processes with Release 11.1.0.7 Databases
3.10.10
Error ORA-00020 Maximum Number of Processes Exceeded When Running utlrp.sql
3.10.11
Running the DBMS_DST Package After Upgrade Can Result in ORA-01822
3.10.12
Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
3.10.13
Understanding Component Status of the Post-Upgrade Status Tool
3.10.13.1
Sample Upgrade Summary Report for the Post-Upgrade Status Tool (utlu121s.sql)
3.10.14
Standard Edition Starter Database and Components with Status OPTION OFF
3.10.15
Adjusting Oracle ASM Password File Location After Upgrade
3.10.16
Error ORA-27248: sys.dra_reevaluate_open_failures is running
3.10.17
Oracle Database Enterprise User Security, OLS-OID, and Provisioning Profile Error
3.10.18
32K Migration Error with utl32k.sql and MAX_STRING_SIZE
3.10.19
ASM Loses Rolling Migration State If CRS Shutdown On All Nodes
3.10.20
Data Type Versioning Could Cause Cross-Version Replication (ORA-26656)
3.10.21
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
Rebuild Oracle Text Indexes Using AUTO_LEXER
4.3.12
Update Your Oracle Application Express Configuration After Upgrading Oracle Database
4.3.13
Configure Access Control Lists (ACLs) to External Network Services
4.3.14
Enable Oracle Database Vault After Upgrading Oracle Database
4.3.15
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 12
c
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
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
Deprecated Functions and Parameters in 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 11
g
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 11
g
Release 2 (11.2)
A.1.9
Initialization Parameters Desupported in Oracle Database 11
g
Release 2 (11.2)
A.1.10
Static Data Dictionary Views Deprecated in Oracle Database 11
g
Release 2 (11.2)
A.1.11
Dynamic Performance Views Deprecated in Oracle Database 11
g
Release 2 (11.2)
A.1.12
Deprecated Features in Oracle Database 11
g
Release 2 (11.2)
A.1.13
Changes to LOG_ARCHIVE_DEST_
n
Parameters
A.2
Behavior Changes in Oracle Database 11
g
Release 1 (11.1)
A.2.1
Initialization Parameters Deprecated in Oracle Database 11
g
Release 1 (11.1)
A.2.2
Initialization Parameters Desupported in Oracle Database 11
g
Release 1 (11.1)
A.2.3
Static Data Dictionary Views with Dropped Columns in Oracle Database 11
g
Release 1 (11.1)
A.2.4
Deprecated Features in Oracle Database 11
g
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 11
g
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 10
g
Release 2 (10.2)
A.3.1
Initialization Parameters Deprecated in Oracle Database 10
g
Release 2 (10.2)
A.3.2
Initialization Parameters Desupported in Oracle Database 10
g
Release 2 (10.2)
A.3.3
Static Data Dictionary Views with Dropped Columns in Oracle Database 10
g
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
Scripting on this page enhances content navigation, but does not change the content in any way.