Wednesday, August 21, 2013

Oracle Database 12c Important Facts


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

No comments: