Oracle 12c Rdbms: Desupported & Deprecated Features

Below is a list of some features desupported and deprecated since release Oracle Rdbms 12C
 Single character SRVCTL command
The Server Control Utility (SRVCTL) command line interface (CLI), used in earlier releases, starting
with Oracle Database 12c is deprecated and may be desupported in a later release.
 Catalog view
The following views are deprecated in Oracle Database 12c:
o ALL_SCHEDULER_CREDENTIALS view.
o DBA_NETWORK_ACL_PRIVILEGES view.
o DBA_NETWORK_ACLS view.
o DBA_SCHEDULER_CREDENTIALS view.
o USER_NETWORK_ACL_PRIVILEGES view.
o USER_SCHEDULER_CREDENTIALS view.
o V$OBJECT_USAGE view.
 Stored Outlines
They are still supported for backward compatibility. 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.
 Managed standby recovery clauses
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.
 Catupgrd.sql
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.
 Init.ora 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;
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
 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.
 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.
 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.
 Change Data Capture
Oracle Change Data Capture is not included in Oracle Database 12c and has been replaced
with Oracle GoldenGate.
 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.
 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.
 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.
 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.