Oracle 12C De-Supported & Deprecated Features

While it is important to be familiar with new features of Oracle 12c, it is imporatant to be aware of features which are either being de-supported or deprecated with this database version.

Single letter SRVCTL commands

SRVCTL has been enhanced to accept more meaningful and user-friendly keyword-style options instead of the single letter options. All new SRVCTL command line interface options added in this release support keyword-style options only and do not have single-letter equivalents. The previous style of using single-letter keyword options as existed in previous releases remain fully supported. In a future release, the singe-letter options may no longer be supported and customers may want to change their scripts to adapt the keyword-style command options.

http://docs.oracle.com/cd/E16655_01/server.121/e17636/release_changes.htm

#ADMIN14157
Single-character options with Server Control (SRVCTL) utility commands
All SRVCTL commands have been enhanced to accept full-word options instead of the single-letter options. All new SRVCTL command options added in this release support full-word options only and do not have single-letter equivalents. The use of single-character options with SRVCTL commands might be desupported in a future release.

See “SRVCTL Command Reference for Oracle Restart” for further information.
—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17615/refrn30162.htm#i1409871
The V$OBJECT_USAGE view is deprecated in Oracle Database 12c Release 1 (12.1) and maintained for backward compatibility. Support for this view may be removed in a future release. Oracle recommends that you use the USER_OBJECT_USAGE view instead of the V$OBJECT_USAGE view.

—————————————————————————————-

Stored outlines

are deprecated.

They are still supported for backward compatibility. However, Oracle recommends that you use SQL plan management instead. SQL plan management creates SQL plan baselines, which offer superior SQL performance stability compared with stored outlines.

See Oracle Database SQL Tuning Guide for more information about SQL plan management.

—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_1006.htm#SQLRF52467

Deprecated Managed Standby Recovery Clauses

USING CURRENT LOGFILE Clause The USING CURRENT LOGFILE clause is deprecated. It invokes real-time apply during Redo Apply. However, this is now the default behavior and this clause is no longer useful.
—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm#BABJCDEG

Deprecation of catupgrd.sql Script

Introduction of New catctl.pl Utility

Oracle Database 12c introduces the new Parallel Upgrade Utility, catctl.pl. This utility replaces the catupgrd.sql script that was used in earlier releases. Although you can still use the catupgrd.sql script, it is deprecated starting with Oracle Database 12c and will be removed in future releases. Oracle recommends database upgrades be performed with the new Parallel Upgrade Utility, catctl.pl.
—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm#BABBDICH

Deprecated Parameters

In Oracle Database 12c, some database parameters are deprecated.

To obtain a current list of deprecated parameters, run the following query in SQL*Plus:

SQL> SELECT name from v$parameter
WHERE isdeprecated = ‘TRUE’ ORDER BY name;
The query returns a list of the deprecated parameters as of the date and time that you run it. The following example shows the query results that appear:

active_instance_count
background_dump_dest
buffer_pool_keep
buffer_pool_recycle
commit_write
cursor_space_for_time
fast_start_io_target
global_context_pool_size
instance_groups
lock_name_space
log_archive_local_first
log_archive_start
max_enabled_roles
parallel_automatic_tuning
parallel_io_cap_enabled
parallel_server
parallel_server_instances
plsql_v2_compatibility
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest

—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm#BABBDICH

Oracle Streams

Oracle Streams is deprecated in Oracle Database 12c and may be desupported and unavailable in a later Oracle Database release. Use Oracle GoldenGate to replace all replication features of Oracle Streams.

—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm#BABBDICH

Advanced Replication

Oracle Database Advanced Replication is deprecated in Oracle Database 12c. Use Oracle GoldenGate to replace all features of Advanced Replication, including multimaster replication, updatable materialized views, hierarchical materialized views, and deployment templates.
—————————————————————————————-
http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm#BABBDICH

Change to VARCHAR2, NVARCHAR2, and RAW Datatypes

Starting with Oracle Database 12c, the maximum size of the VARCHAR2, NVARCHAR2, and RAW datatypes has been increased to 32767 bytes when the COMPATIBLE initialization parameter is set to 12.0 and the MAX_STRING_SIZE initialization parameter is set to EXTENDED.
—————————————————————————————-

Desupport of Change Data Capture

Oracle Change Data Capture is not included in Oracle Database 12c and has been replaced with Oracle GoldenGate.

—————————————————————————————-
8.3.4 Deprecation of IGNORECASE and SEC_CASE_SENSITIVE_LOGON
The IGNORECASE argument of ORAPWD and the SEC_CASE_SENSITIVE_LOGON system parameter are deprecated in Oracle Database 12c. By default, passwords in Oracle Database 12c are case sensitive.

—————————————————————————————-
8.4.1 Desupport of CSSCAN and CSALTER

With the introduction of Oracle Database Migration Assistant for Unicode (DMU), Oracle is proceeding with the desupport of the legacy database tools, CSSCAN and CSALTER. DMU provides a complete end-to-end Unicode migration solution for database administrators. Starting with Oracle Database 12c, DMU is included with Oracle Database, and the CSSCAN and CSALTER tools are no longer included nor supported.
—————————————————————————————-
8.6.3 Desupport of Oracle Net Listener Password
In Oracle Database 12c, the Oracle Net Listener password feature is no longer supported. This does not cause a loss of security because authentication is enforced through local operating system authentication.
—————————————————————————————-
8.6.1 Desupport of Oracle Net Connection Pooling
In Oracle Database 12c, Oracle Net connection pooling is no longer supported. Oracle Net connection pooling was deprecated in Oracle Database 11g. This includes the DISPATCHERS attributes TICKS, SESSIONS, and CONNECTIONS.