8 Behavior Changes, Deprecated and Desupported Features for Oracle Database 12c Release 2 (12.2)

Oracle Database 12c introduces upgrade behavior changes for your database in addition to new features. Changes in behavior include deprecated and desupported initialization parameters, options, syntax, and the deprecation and desupport of features and components.

These topics do not describe new features introduced in Oracle Database 12c, nor do they describe changes in earlier releases of Oracle Database.

Be aware of the implications of deprecated and desupported:

• Deprecated features are features that are no longer being enhanced but are still supported for the full life of the 12.2.0.1.

• Desupported features are features that are no longer supported by fixing bugs related to that feature, and features for which Oracle may remove the code required to use the feature. Where indicated, a deprecated feature can be desupported in a future major release.

Topics:

• Initialization Parameter Changes in Oracle Database 12c Release 2 (12.2)
  Review to see the list of new, deprecated, and desupported initialization parameters in this release.
• Deprecated Features in Oracle Database 12c Release 2 (12.2)
  Review the deprecated features listed in this section to prepare to use alternatives after you upgrade.
• Desupported Features in Oracle Database 12c Release 2 (12.2)
  Review this list of desupported features as part of your upgrade planning.
• Database Upgrade Assistant (DBUA) Enhancements and Changes
  Oracle Database 12c release 2 (12.2) includes several enhancements to DBUA, and some features have been removed or modified.
• Enhancements to Oracle Data Guard Broker and Rolling Upgrades
  Starting with Oracle Database 12c release 2 (12.2), Oracle Data Guard Broker has more features to assist rolling upgrades.
• About Changes in Default SGA Permissions for Oracle Database
  Starting with Oracle Database 12c Release 2 (12.2.0.1), by default, permissions to read and write to the System Global Area (SGA) are limited to the Oracle software installation owner.
• Network Access Control Lists and Upgrade to Oracle Database 12c
  Network access control lists (ACLs) are implemented as Real Application Security ACLs in 12c, and existing ACLs are migrated from XML DB ACLs and renamed during upgrade.
• Parallel Upgrade Utility Batch Scripts
  In Oracle Database 12c release 2, you can run the Parallel Upgrade Utility using command-line batch scripts.catupgrd.sql is no longer distributed.
• Unified Auditing AUDIT_ADMIN and AUDIT_VIEWER Roles Changes
  You may need to rename or drop AUDIT_ADMIN and AUDIT_VIEWER roles before upgrading.
• Oracle Update Batching Batch Size Settings Disabled
  Oracle update batching settings are disabled in Oracle Database 12c release 2 (12.2). Use JDBC batching instead.
• About Upgrading Tables Dependent on Oracle-Maintained Types
  Starting with Oracle Database 12c release 2 (12.2), you can run the Parallel Upgrade Utility with the -T option to set tables to READ ONLY.
• Case-Insensitive Passwords and ORA-1017 Invalid Username or Password
  The Oracle Database 12c release 2 (12.2) default authentication protocol is 12 (Exclusive Mode). This protocol requires case-sensitive passwords for authentication. Review your options if you have earlier release password versions.
• About Deploying Oracle Grid Infrastructure Using Rapid Home Provisioning
  Rapid Home Provisioning is a software lifecycle management method for provisioning and patching Oracle homes. Rapid Home Provisioning enables mass deployment of standard operating environments for databases and clusters.
• Restrictions Using Zero Data Loss Recovery Appliance Release 12.1 Backups
  Zero Data Loss Recovery Appliance release 12.1 does not support backups from protected database clients using Oracle Database 12c release 2 (12.2).