Feature Deprecation
There are several features that Oracle had indicated are
deprecated which gives insight into features that Oracle intends to remove or
de-support in future releases giving you time to plan and determine the
alternatives that you will utilize going forward to replace the deprecated
functionality.
Oracle Enterprise Manager Database Control
Oracle OEM Database
Control is de-supported and is no longer going to be a component that can be
utilized and is being replaced with Oracle Enterprise Manager Express.
Streams
Oracle Streams is being deprecated
in Oracle 12c and is subject to full desupport and likely to be unavailable future releases.
It is recommended to utilize GoldenGate to replace the capability Streams
provided.
Advanced Replication
Oracle Advanced Replication is being deprecated in Oracle
12c. It is recommended that all Advanced Replication usage be moved to GoldenGate. Golden Gate will replace Advanced Replication
including multimaster replication, updatable materialized views, hierarchical
materialized views, and deployment templates.
OCFS on Windows
In Oracle Database 12c, Oracle Cluster File System (OCFS) is desupported for
Windows. The support of OCFS (OCFS2) for
Linux will continue and is not affected. http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm
Raw Devices
In Oracle Database 12c, raw devices will not be supported therefore you must move
database data files on raw devices to ASM, a supported cluster file system, or NFS. This
also affects and applies to OCR and VOTE
for clusterware and must be moved before upgrade.
Change Data Capture
Oracle Change Data Capture
(CDC) is not included in Oracle 12c therefore prior to
upgrade all Change Data Capture usage must be removed and replaced. It is recommended all CDC functionality be
moved to GoldenGate.
Stored Outlines
Stored Outlines
are deprecated, you should look at moved to SQL Profiles and Plan Baselines.
SQLNET.ALLOWED_LOGON_VERSION
This sqlnet.ora
parameter is deprecated and is being replace by 2 new parameters:
SQLNET.ALLOWED_LOGON_VERSION_SERVER
SQLNET.ALLOWED_LOGON_VERSION_CLIENT
For environments
that do not set this parameter means the environment was operating with the
default setting of 8. In upgrading to
Oracle Database 12c you may need to set the SQLNET.ALLOWED_LOGIN_VERSION_SERVER
to 8 to maintain compatibility of existing application clients.
CSSCAN and CSALTER
The csscan and
csalter are deprecated in Oracle Database 12c and are replaced with the Database
Migration Assistant for Unicode. http://docs.oracle.com/cd/E16655_01/doc.121/e36716/ch1overview.htm#DUMAG101\
Oracle Net Listener Password
The Oracle
listener password is deprecated, Oracle ensures there is no loss of security as
security is enforce through local OS authentication.
XML DB is Mandatory and Cannot Be Uninstalled
The XML DB is a
part of the Oracle database that is no longer optional. It can no longer be excluded from install on
database creation and can no longer be removed from a database.
Deprecated Views
ALL_SCHEDULER_CREDENTIALS
DBA_NETWORK_ACL_PRIVILEGES
DBA_NETWORK_ACLS
DBA_SCHEDULER_CREDENTIALS
USER_NETWORK_ACL_PRIVILEGES
USER_SCHEDULER_CREDENTIALS
V$OBJECT_USAGE
Initialization Parameters
With database 12c pluggable databases there are some
database initialization parameters changes that you need to be aware of.
New Parameters
This is not intended to be a complete list of new
parameter, but a mention of the ones seen as most notable.
To enable the use of pluggable databases the enable_pluggable_database
initialization parameter is there to control that.
enable_pluggable_database TRUE
For a default file name convert used when creating a new
pluggable database for file location.
pdb_file_name_convert
You will also notice that the v$parameter as a new column
con_id that will indicate the database which the parameter is set for. The parameters for each pluggable database
are the same as a normal database.
Deprecated Parameters
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
Upgrade Path
Direct Upgrade Path
Source Database
|
Target Database
|
10.2.0.5 (or higher)
|
12.1.0.1.0
|
11.1.0.7 (or higher)
|
12.1.0.1.0
|
11.2.0.2 (or higher)
|
12.1.0.1.0
|
Indirect Upgrade Path
Source Database
|
Upgrade Path for Target Database
|
Target Database
|
7.3.3.0.0 (or lower)
|
7.3.4.x --> 9.2.0.8
|
11.2.x
|
8.0.5.0.0 (or lower)
|
8.0.6.x --> 9.2.0.8
|
11.2.x
|
8.1.7.0.0 (or lower)
|
8.1.7.4 --> 9.2.0.8
|
11.2.x
|
9.0.1.3.0 (or lower)
|
9.0.1.4 --> 9.2.0.8
|
11.2.x
|
