Sunday, November 3, 2013

Deprecated Features in 12c DB

For deprecated parameters,

SQL> SELECT name from v$parameter
         WHERE isdeprecated = 'TRUE' ORDER BY name;

 Some deprecated parameters
 ==========================

background_dump_dest
buffer_pool_keep
sec_case_sensitive_logon
sql_trace
standby_archive_dest
user_dump_dest
FILE_MAPPING

Views deprecated
==================
ALL_SCHEDULER_CREDENTIALS
DBA_NETWORK_ACL_PRIVILEGES
DBA_NETWORK_ACLS
DBA_SCHEDULER_CREDENTIALS
USER_NETWORK_ACL_PRIVILEGES
USER_SCHEDULER_CREDENTIALS
V$OBJECT_USAGE

Deprecated DBMS_NETWORK_ACL_ADMIN PL/SQL package Procedures
===========================================================

The following procedures from the DBMS_NETWORK_ACL_ADMIN PL/SQL package are deprecated:

    CREATE_ACL
    ADD_PRIVILEGE
    DELETE_PRIVILEGE
    ASSIGN_ACL
    UNASSIGN_ACL
    DROP_ACL
    ASSIGN_WALLET_ACL
    UNASSIGN_WALLET_ACL
    CHECK_PRIVILEGE
    CHECK_PRIVILEGE_ACLID


Oracle Streams and Advanced replication are deprecated too.
Raw storage devices desupported -- Any datafiles have to be moved to ASM,CFS or NFS.
Oracle restart NOT available even for single-instance systems, though ASM comes as part of Grid Infra for stand alone and cluster systems.

If upgrading 10.2.0.5 or 11.1.0.7 to 12c with OCFS/RAW devices, then first upgrade to 11.2 and migrate OCFS to ASM and then upgrade to 12c.

No comments:

Post a Comment