Deprecated Features in Oracle Database 12c

Deprecated Features in Oracle Database 12c

Several database features have been deprecated in Oracle Database 12c. The following table lists many of the features being deprecated and provides some comment on those features. Though this list was complete when the book was written, it’s possible the list will change. The Oracle Database Upgrade Guide 12c Release provides a complete list of all deprecated and desupported features in Oracle Database 12c.

Feature Deprecated	Comments
ignorecase argument of the orapwd tool	Deprecated in Oracle Database 12c in conjunction with the deprecation of the sec_case_sensitive_logon parameter. By default, all passwords are now case sensitive.
Oracle Restart	Deprecated in Oracle Database 12c.
Svrctl utility single-character commands	Deprecated in Oracle Database 12c.
Catupgrd.sql script for upgrades	Deprecated in favor of the catctl.pl utility.
Oracle Streams	Deprecated in Oracle Database 12c. You should migrate from Oracle Streams to Oracle GoldenGate at some point because Oracle Streams may be desupported and unavailable in a later Oracle Database release.
Oracle Advanced Replication	Deprecated in Oracle Database 12c. You should migrate from Oracle Advanced Replication to Oracle GoldenGate at some point because Oracle Advanced Replication may be desupported and unavailable in a later Oracle Database release.
Stored outlines	Use plan baselines instead.
Various features of Oracle Label Security	See the Oracle Label Security Administrator’s Guide 12c Release for more information on this feature.
Deprecation of Windows NTS Authentication using the NTLM protocol	Windows users can no longer authenticate using the NTS adaptor on Windows clients and servers that require the NT LAN Manager (NTLM) protocol. NTLM is deprecated as of Oracle Database 12c. Windows users can still use Kerberos. NTLM is still used for local user authentication, and in cases in which the database service runs as a local user.
Public Key Infrastructure for TDE	PKI is deprecated for TDE in Oracle Database 12c. To configure TDE in Oracle Database 12c, use the administer key management SQL statement.
XML_CLOBS option in Oracle Data Pump Export	Deprecated in Oracle Database 12c.
Database Vault Configuration Assistant and Database Vault Administrator	Deprecated in Oracle Database 12c. Use Oracle Enterprise Manager Cloud Control for Oracle Database Vault configuration and administration.
Certain Database Vault default rule sets	The Allow Oracle Data Pump Operation rule set and Allow Scheduler Job rule set are deprecated.
Oracle Database Vault default realms	The Oracle Data Dictionary realm and the Oracle Enterprise Manager realm are deprecated in this release. The objects that were protected in the Oracle Data Dictionary realm have been migrated to new realms.
Oracle Database Vault deprecated API	The dvsys.dbms_macadm.sync_rules procedure is deprecated.
CSSCAN and CSALTER	Replaced by the Oracle Database Migration Assistant for Unicode (DMU).

Desupported Features in Oracle Database 12c

Several database features have been desupported in Oracle Database 12c. The following table lists many of these features and provides commentary on the desupport of that feature where applicable. Things change over time and the Oracle Database Upgrade Guide 12c Release provides a complete list of all deprecated and desupported features in Oracle Database 12c.

Feature Desupported	Comments
Oracle Enterprise Manager Database Control	Desupported in Oracle Database 12c. Replaced by Oracle EM Express. Oracle Database Control is no longer available in Oracle Database 12c.
Standalone deinstallation tool	This utility is replaced in Oracle Database 12c with a deinstall option in Oracle Universal Installer. Also, the runInstaller command includes -deinstall and -home options to allow for command-line-based Oracle Home removal and cleanup.
Oracle COM Automation on Windows	Desupported in Oracle Database 12c.
Oracle Objects for OLE	Desupported in Oracle Database 12c. Migrate your code to another supported application architecture (such as Java, .NET, etc.).
Oracle Counters for Windows Performance Monitor	Deprecated in Oracle Database 11g and now not available in Oracle Database 12c.
OCFS for Windows	Desupported in Oracle Database 12c. See the Oracle Database Upgrade Guide 12c Release for information on upgrading your database if you are using OCFS.
Support for raw devices	Desupported in Oracle Database 12c. This includes OCR and voting files for Oracle Clusterware.
Oracle Change Data Capture	Not included in Oracle Database 12c. Has been replaced with Oracle GoldenGate.
Specific cipher suites for SSL	The following cipher suites are desupported for Oracle Advanced Security:    SSL_DH_ANON_WITH_DES_CBC_SHA    SSL_RSA_EXPORT_WITH_DES40_CBC_SHA    SSL_RSA_EXPORT_WITH_RC4_40_MD5    SSL_RSA_WITH_DES_CBC_SHA
Oracle Net connection pooling	Desupported in Oracle Database 12c.
Oracle Names	Desupported in Oracle Database 12c. Migrate to directory naming.
Oracle Net listener password	Desupported in Oracle Database 12c. Security is enforced through local OS system authentication.

Deprecated Parameters in Oracle Database 12c

A few sqlnet.ora and database parameters have either been replaced or deprecated in Oracle Database 12c.

The sqlnet.ora parameter SQLNET.ALLOWED_LOGON_VERSION has been replaced by the parameters SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT.

The following Oracle Database parameters have been deprecated in Oracle Database 12c:

   FILE_MAPPING

   SEC_CASE_SENSITIVE_LOGON

For a list of all deprecated parameters in the database, you can issue this query: