Useful MOS notes on 12c

Useful MOS notes on 12c

Here is the list of useful MOS notes on 12c:

1. Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
2. NOTE:1493645.1 - Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA 
3. RMAN RECOVER TABLE Feature New to Oracle Database 12c [ID 1521524.1]
4. How to Merge Multiple Partitions in Oracle 12C [ID 1482263.1]
5. How to Drop/Truncate Multiple Partitions in Oracle 12C [ID 1482264.1]
6. How to Create Interval-Reference Partitioned Tables in Oracle 12c [ID 1519042.1]
7. RMAN Enhancements in Oracle 12c [ID 1534487.1] 
8. Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) [ID 1520299.1] 
9. Oracle Database 12.1 : FAQ on Queryable Patch Inventory [ID 1530108.1] 
10. Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) [ID 1503653.1] 
11. Changes For Oracle Database 12.1 Standalone Installation [ID 1483380.1] 
12. Requirements for Installing Oracle Database 12.1 on Solaris 10 SPARC [ID 1517948.1] 
13. Requirements for Installing Oracle Database 12.1 on RHEL6 or OL6 64-bit (x86-64) [ID 1529864.1] 
14. Requirements for Installing Oracle Database 12.1 64-bit (AMD64/EM64T) on SLES 11 [ID 1519770.1]
15. How To Downgrade Oracle Database 12c Release 1 (12.1) To Previous Versions [ID 1516622.1].
16. Mount Options for Oracle files when used with NFS on NAS devices (Doc ID 359515.1)
    
    

    Oracle 12c Articles from the Community
    
    http://www.oraclealchemist.com/news/install-oracle-12c-12-1/
    
    ============

    http://oracle12c.info/
    
     Oracle Database 12c Videos

    Architectural Information

    • Oracle Database 12c Architecture Diagram Overview
    • Oracle Database 12c Multitenant Architecture Diagram Overview

    New Features and Enhancements

    • Creating a Role Using Enterprise Manager Database Express
    • Moving Online Data Files
    • Data Redaction Using SQL*Plus
    • Recovering a Pluggable Database
    • Creating a User Using Enterprise Manager Database Express

    Database Options, Products, and Pack Data Sheets

    Advanced Compression (PDF) Advanced Security (PDF) Audit Vault and Database Firewall (PDF) Data Masking Pack (PDF) Data Mining (PDF) Diagnostic Pack (PDF) Multitenant (Pluggable Databases)(PDF)

    Partitioning (PDF) R Enterprise(PDF) Real Application Clusters (PDF) Real Application Clusters One Node (PDF) Real Application Testing (PDF) Tuning Pack (PDF)

    ==============================================
    
    Certification

    For the latest Database Certification always refer to My Oracle Support (MOS) Certify section.

    Installation/Upgrade Guides

    Oracle Database 12c Release 1 (12.1) Documentation

    General Information For 12c Release 1 (12.1)

    Document 1483380.1 Changes For Oracle Database 12.1 Standalone Installation

    Installation General Information For 12c Release 1 (12.1)

    Document 1517948.1 Requirements for Installing Oracle Database 12.1 on Solaris 10 SPARC
    Document 1525614.1 Requirements for Installing Oracle Database 12.1 on Solaris 11 SPARC
    Document 1529433.1 Requirements for Installing Oracle Database 12.1 on RHEL5 or OL5 64-bit (x86-64)
    Document 1529864.1 Requirements for Installing Oracle Database 12.1 on RHEL6 or OL6 64-bit (x86-64)
    Document 1519770.1Requirements for Installing Oracle Database 12.1 64-bit (AMD64/EM64T) on SLES 11

    Installation Knowns Issues For 12c Release 1 (12.1)

    Document 1496746.1 Linking Of Oracle 12c Binaries on Solaris Failed with ” ld: fatal: library -ldtrace: not found” Error
    Document 1518334.1 INFO: ld: warning: symbol ‘_init’ not found

    Silent Installation General Information For 12c Release 1 (12.1)

    Document 885643.1 How To Install 11.2/12.1 Database/Client Software In Silent Mode Without Using Response File

    Silent Installation Knowns Issues For 12c Release 1 (12.1)

    Document 1550832.1 Oracle Database 12.1 Silent Install Report Error With Null,null,null

    Upgrade General information For 12c Release 1 (12.1)

    Document 1515747.1 Oracle Database 12c Release 1 (12.1) Upgrade New Features
    Document 1493645.1 Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
    Document 1516557.1 Complete Checklist for Upgrading to Oracle Database 12c Release 1 (12.1) using DBUA
    Document 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
    Document 1516616.1 Oracle Database 12c Release 1 (12.1) DBUA in Silent mode

    Downgrade General Information For 12c Release 1 (12.1)

    Document 1516622.1 How To Downgrade Oracle Database 12c Release 1 (12.1) To Previous Versions

    Downgrade Known Issues For 12c Release 1 (12.1)

    Document 1520209.1 QT_*BUFFER Views Invalid after downgrade from Oracle Database 12.1 (12c)

    Patching General Information For 12c Release 1 (12.1) (includes SQLPATCH and QOPATCH)

    Document 1530108.1 Oracle Database 12.1 : FAQ on Queryable Patch Inventory

    Cloning General Information For 12c Release 1 (12.1)

    Document 1493677.1 Cloning An Existing Oracle Database 12c Release 1 (12.1.0.x) RDBMS Installation Using OUI
    
    ===============================================================================
    
    Oracle Database 12c OBEs

    2-Day DBA

    • 1 – Installing Oracle Database Software and Creating a Database
    • 2 – Getting Started with Oracle Enterprise Manager Express
    • 3 – Using the Listener Control Utility to Manage the Listener
    • 4 – Managing the Oracle Instance
    • 5 – Managing Database Storage Structure
    • 6 – Administering User Accounts and Security
    • 7 – Managing Schema Objects
    • 8 – Performing Backup and Recovery
    • 9 – Monitoring and Tuning the Database
    • 10 – Managing Oracle Database Software

    Oracle Multitenant Architecture

    • Performing Basic Tasks in Oracle Multitenant
    • Unplugging and Plugging Pluggable Databases
    • Adopting a Non-CDB as a Pluggable Database in a Multitenant Container Database
    • Performing Point-In-Time Recovery for a Pluggable Database
    • Cloning Pluggable Databases
    • Managing Pluggable Databases (PDBs) Using SQ

    Information Lifecycle Management

    • Setting Up Compression Tiering for Automatic Data Optimization
    • Setting Up Storage Tiering for Automatic Data Optimization
    • Using In-Database Row Archiving
    • Implementing Temporal Validity

    Security

    • Protecting Data with Data Redaction
    • Redaction Management in Oracle SQL Developer
    • Determining Least Privilege Access Using Privilege Analysis
    • Implementing Unified Auditing

    Performance Tuning

    • Monitoring Performance Using EM Express
    • Monitoring Real-Time Database Operations

    SQL & PL/SQL

    • Using SQL Pattern Matching
    • Setting Up SQL Translation Framework
      
      
      ===========================================
    •