Behavior Changes in Oracle Database 12c Release 2 (12.2.0.1)

Review for descriptions of Oracle Database 12c release 1 (12.1) changes.

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.
• Client and Foreground Server Process Memory Changes
  To increase optimization and performance, the Oracle Database Client and server process memory requirements are greater than in previous releases.
• 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 and Maintenance
  Rapid Home Provisioning and Maintenance (RHP) is a software lifecycle management method for provisioning and maintaining Oracle homes. RHP enables mass deployment and maintenance of standard operating environments for databases, clusters, and user-defined software types.
• 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).