O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

OCP 12c Upgrade 1Z0-060 Exam Guide

Book Description

Your ultimate guide to passing the OCP 12c Upgrade 1Z0-060 Exam

About This Book

  • This is your one-stop solution to understanding what’s new in Oracle 12c and how to bring these features to your systems in a hassle-free manner
  • A complete guide to clearing the OCP Upgrade 1Z0-060 Exam
  • Dive deep into Oracle administration and get up to date

Who This Book Is For

This book is for Oracle Admins who have a working knowledge of Oracle administration and now want to upgrade their knowledge to the latest version (Oracle 12c). This book is perfect for those who wish to pass the OCP Upgrade 1Z0-060 Exam.

What You Will Learn

  • All of the new features of the Oracle 12c database that you are required to know for the OCP Upgrade Exam 1Z0-060
  • New multitenant architecture introduced in Oracle 12c and how it works
  • Monitor complex database operations and use the new enhanced SQL tuning features to tune bad SQLs
  • Manage data over time using information life cycle management
  • Make your data more secure by implementing new enhanced auditing
  • Learn new security features and how to implement encryption to secure your data
  • Explore how backup and flashback works with new multitenant architecture
  • Performance management techniques that will analyze and tune your database

In Detail

This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems.

All of the information in this book has been handpicked to help you study for the Oracle 12c upgrade exam. Each chapter has been written with the objective of helping you pass this exam with ease. Content in this book is aligned with the objectives of the exam, making it really easy to follow the course content. Every example mentioned in this book has been tried and tested in actual environment. Real-world examples will help you learn about new features such as multitenant containers database architecture, managing containers, pluggable databases, database administration enhancements, database auditing, tuning, backup, and flashback enhancements.

You will also learn about storage enhancements, security updates, tuning, troubleshooting, and backup enhancements. This book also covers section 2 of the exam course making this book a complete guide for passing OCP 12c upgrade exam 1Z0-060.

Style and approach

This book systematically covers various aspects of Oracle administration and provides the information necessary to pass the OCP Upgrade 1Z0-060 Exam Set 1 and Set 2.

Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

Table of Contents

  1. OCP 12c Upgrade 1Z0-060 Exam Guide
    1. OCP 12c Upgrade 1Z0-060 Exam Guide
    2. Credits
    3. About the Authors
    4. About the Reviewer
    5. www.PacktPub.com
      1. Why subscribe?
    6. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Downloading the color images of this book
        3. Errata
        4. Piracy
        5. Questions
    7. 1. Getting Started with Oracle 12c
      1. Installation and configuration using OUI and DBCA
        1. Managing PDB databases using DBCA
      2. Using EM Database Express
        1. Configuring EM Express
        2. Access control for EM Express
        3. Exploring Oracle database EM Express
      3. Emergency monitoring and Real-Time ADDM
        1. Slow system
        2. Emergency monitoring
      4. Real-Time ADDM
        1. Working of Real-Time ADDM
        2. Automatic triggering of Real-Time ADDM
        3. Generating Real-Time ADDM report
        4. Emergency monitoring versus Real-Time ADDM
      5. Generating ADDM compare period
        1. How does the ADDM compare report help?
        2. Workload commonality
        3. Generating ADDM compare period
          1. Using EM Cloud Control 12c
          2. Using DBMS_ADDM package
      6. Diagnosing performance issues using ASH enhancements
        1. Limitations on top activity page in previous release
        2. New ASH analysis page
      7. Summary
    8. 2. Multitenant Container Database Architecture
      1. Challenges with non-container databases
      2. Benefits of multitenant architecture
      3. Root and multitenant architecture
        1. Separation of metadata
        2. Shared and non-shared objects
        3. Managing a CDB
      4. Organization of CDBs and PDBs
        1. Common entities
        2. Exclusive entities
        3. Data dictionary views
      5. Local users and common users
        1. Local users
        2. Common users
      6. Local and common roles and privileges
        1. Local roles
        2. Common roles
          1. Example of granting a common role commonly
          2. Example of granting a common role locally
        3. Local privileges and common privileges
      7. Creating and configuring a CDB
      8. Post-CDB creation
        1. What's in your CDB?
      9. Creating PDBs
        1. Creating a PDB from seed
        2. Cloning a PDB from an existing PDB
        3. Plugging an unplugged PDB into a CDB
        4. Unplugging PDB2 from ORCL
        5. Plugging PDB2 into a CDB
        6. Migrating a non-CDB to a PDB
          1. Plugging a non-CDB into a CDB using datapump TTS
          2. Using the Golden Gate replication to plug a non-CDB into a PDB
          3. Migrating a non-CDB to a PDB using the DBMS_PDB package
      10. Summary
    9. 3. Managing CDBs and PDBs
      1. Establishing connection to CDB/PDBs
        1. Services
      2. Creating services
      3. Connecting to CDBs
        1. Locally using user ID and password but without specifying a service name
          1. Locally using OS authentication
          2. Using a net service name/connect string/alias configured in tnsnames.ora
          3. Remotely using EasyConnect
        2. Connecting to PDBs
        3. Switching connections
          1. Using reconnect
          2. Using alter session
      4. Starting up and shutting down a CDB/PDB
        1. Starting up CDB
        2. Opening PDBs
        3. Shutting down of CDBs and PDBs
          1. Closing PDBs
          2. Shutting down CDBs
        4. Changing instance parameters for a CDB/PDB
        5. Modifying PDB settings
      5. Object link and metadata link
        1. The metadata link
        2. Object links
      6. Container data objects
      7. Enabling a common user to access data in a specific PDB
      8. Managing tablespaces in a CDB/PDB
        1. Default tablespaces for containers
        2. Permanent tablespaces in CDB and PDB
        3. Temporary tablespaces in a CDB and PDB
      9. Managing users and privileges in CDB/PDB
        1. Local users and common users
          1. Local users
          2. Common users
          3. Viewing local and common users
        2. Local privileges and common privileges
          1. Managing privileges
          2. Granting privileges
          3. Revoking privileges
        3. Local roles and common roles
          1. How common roles work
          2. Rules for creating common roles
          3. Rules for creating local roles
          4. Creating roles
          5. Granting roles
          6. Revoking roles
      10. Summary
    10. 4. Information Lifecycle Management and Storage Enhancements
      1. Information lifecycle management
      2. Typical lifecycle of data
      3. How automatic data optimization works
      4. Enabling heat maps
        1. Enabling and disabling heat maps
        2. Checking heat map details
          1. V$HEAT_MAP_SEGMENT view
          2. SYS.HEAT_MAP_STAT$ and DBA_HEAT_MAP_SEG_HISTOGRAM
          3. DBA_HEATMAP_TOP_TABLESPACES
          4. DBMS_HEAT_MAP package
      5. Enabling ADO policies
        1. ADO policies for compression action
          1. Tablespace level compression policy
          2. Group-level compression policy
          3. Segment level compression policy
          4. Row level compression policy
        2. ADO policies for data movement action
        3. CUSTOM_ILM_RULES
        4. Implementing multiple policies on a segment
        5. Policy priority and policy inheritance
        6. Checking ILM policy details
          1. DBA_ILMPOLICIES
          2. DBA_ILMDATAMOVEMENTPOLICIES
      6. Evaluating and executing ADO policies
        1. Scheduled in maintenance window
        2. Manually executing ADO policies
      7. Checking execution details of ADO policies
        1. DBA_ILMTASKS
        2. DBA_ILMEVALUATIONDETAILS
        3. DBA_ILMRESULTS
        4. DBMS_ILM_ADMIN package
      8. Enabling and disabling ADO policies
        1. Enabling/disabling ADO policies
        2. Deleting ADO policies
        3. Enabling/disabling ILM
      9. Moving data files online
      10. Moving partitions online
      11. In-database archiving and temporal validity
        1. Oracle Hybrid Columnar Compression
          1. How does HCC compression work?
      12. In-database archiving
      13. Temporal validity and temporal history
        1. Temporal history
        2. Defining temporal validity
          1. PERIOD FOR clause
          2. DBMS_FLASHBACK_ARCHIVE
      14. Summary
    11. 5. Auditing, Privilege Analysis and Data Redaction
      1. Unified auditing
        1. Advantages of unified auditing
        2. Mixed auditing mode and unified auditing mode
      2. Enabling unified auditing mode
        1. Extended audit information
        2. Enabling extended auditing
      3. Creating and enabling unified audit policy
        1. Audit policies in a multitenant database
          1. Common audit policy
          2. Local audit policy
        2. Creating audit policies
          1. Creating a system-wide audit policy
          2. Creating an object-specific audit policy
          3. Using conditions and evaluation
        3. Modifying audit policies
          1. Enabling audit policies
          2. Altering audit policies
          3. Disabling audit policies
          4. Dropping audit policies
          5. Viewing audit policies
        4. Using predefined audit policies
        5. Capturing application context
        6. Cleaning up audit data
      4. Using administrative privileges
        1. New operating system group
        2. New password file
      5. Privilege analysis
        1. Creating a privilege analysis policy
        2. Enabling privilege analysis
        3. Disabling the privilege analysis
        4. Generating a privilege analysis report
        5. Viewing the report
        6. Dropping the privilege analysis policy
        7. New privilege checking during PL/SQL calls
        8. New inherit privilege
        9. New privilege checking with bequeath views
      6. Oracle Data Redaction
        1. Activities exempt from data redaction
      7. Types of data redaction
        1. Full data redaction
        2. Partial data redaction
        3. Random data redaction
        4. Regular expression redaction
      8. Creating a redaction policy
        1. Adding a redaction
        2. Adding a redaction policy to a table or view
        3. Modifying a redaction policy
      9. How Oracle data redaction affects tables and views
      10. Altering the default full data redaction value
      11. Restrictions on data redaction
      12. Enabling and disabling data redaction policies
      13. Exempting users from data redaction
      14. Viewing data redaction policies details
        1. REDACTION_POLICIES
        2. REDACTION_COLUMNS
      15. Summary
    12. 6. Database Tuning and Troubleshooting
      1. Real-time database operation monitoring
      2. Database operation
        1. Identifying database operations
        2. Enabling monitoring of database operations
        3. Monitoring progress of database operations
          1. Monitoring operations using Oracle EM Database Express
          2. Monitoring operations using views
          3. Monitoring operations using reports
      3. SQL tuning
        1. Adaptive execution plans - dynamic plans
          1. What happens in adaptive plan execution?
          2. Enabling adaptive execution plans
          3. Adaptive execution plans and join methods
          4. Adaptive plans and parallel distribution methods
        2. Automatic re-optimization
          1. Statistics feedback
          2. Performance feedback
        3. Adaptive statistics
          1. Dynamic statistics
          2. SQL plan directives
          3. DBMS_SPD
      4. Enhanced features of statistics gathering
        1. Online statistics gathering for bulk-load
        2. Concurrent statistics gathering
          1. Enabling concurrent statistics collection
        3. Parallel execution of stats gathering
        4. Statistics gathering for a global temporary table
        5. Histogram enhancements
          1. Top frequency histogram
          2. Hybrid histogram
        6. Extended statistics enhancements
      5. Adaptive SQL plan management
        1. Challenges in previous releases
          1. SQL plan management - previous releases
          2. Limitations of outlines and profiles
          3. Finally, how are baselines different than outline and profile, then?
          4. SQL plan baseline parameters
        2. Adaptive SPM - Oracle 12c
          1. New task-based function
          2. Configuring the SPM evolve advisor task
      6. Summary
    13. 7. Backup and Flashback Enhancements
      1. Performing a backup of CDB and PDB
        1. Performing complete CDB backup
        2. Performing partial CDB backup
        3. Performing complete PDB backup
        4. Performing partial PDB backup
        5. Performing PDB hot backup
        6. Archive log backup
      2. Performing recovery of CDB and PDB
        1. Performing instance recovery
        2. Media failure - CDB temporary file recovery
        3. Media failure - PDB temporary file recovery
        4. Media failure - control file loss
        5. Media failure - Redo log file loss
        6. Media failure - root SYSTEM or UNDO data file loss
        7. Media failure - root SYSAUX data file loss
        8. Media failure - PDB SYSTEM data file loss
        9. Media failure - PDB non-SYSTEM data file loss
        10. Performing PDB PITR (Point-in-Time Recovery)
        11. PDB tablespace PITR
      3. Performing a flashback of CDB
        1. Performing a flashback of a database
        2. Flashing back CDB after a PDB PITR
      4. Using RMAN enhancements
        1. Separation of DBA duty - New SYSBACKUP privileges
        2. Using SQL in RMAN
        3. Multi-section image copies and Multi-section incremental backup
        4. RMAN Active duplication enhancements
          1. Default use of a backup set in active database duplication
          2. Introducing choice of compression, encryption, and section size
          3. Option to complete duplication with the target database in mounted mode
        5. Duplicating container databases with PDBs
          1. Duplicating CDB
          2. Duplicating PDBs
        6. Recovering a database with a third party snapshot
        7. Transporting data across a platform using backup sets
          1. Transporting databases
          2. Transporting tablespaces
      5. Automatic table recovery using RMAN
        1. Recovering a table
        2. Recovery point-in-time options
        3. Steps for performing table recovery
      6. Implementing new features of Flashback Data Archive
        1. Database Hardening - enabling Flashback Data Archive for Security-Related Application Tables
        2. Flashback Data Archive improvements
        3. Optimization for Flashback Data Archive History Tables
      7. Summary
    14. 8. Database Administration Enhancements
      1. Resource manager
      2. Managing resources between PDBs
        1. Creating and enabling a CDB resource plan
      3. Viewing CDB resource plan directives
      4. Managing CDB resource plans
      5. PDB resource plans
      6. Enhancements in creating resource manager plan directives
      7. Multi-process, multi-threaded Oracle architecture
        1. Enabling multi-threaded architecture
        2. Connecting to a database with multi-threaded architecture
      8. Smart flash cache enhancements
        1. Using multiple flash cache devices
      9. Index and table enhancements
        1. Invisible columns
          1. Usage and limitations of invisible columns
        2. Multiple indexes on the same columns
      10. Online redefinition - tables with VPD
      11. Online redefinition - dml_lock_timeout
      12. Advanced row compression and compression advisor
        1. LOB compression
        2. Using compression advisor
      13. Enhanced online DDL capabilities
        1. Drop index/constraints
        2. Index unusable
        3. Setting unused columns
      14. ADR and network enhancements
        1. ADR enhancements
          1. DDL logging
          2. Debug log
        2. Network-related enhancements
          1. Network compression
          2. Enabling network compression
          3. Session Data Unit
      15. Summary
    15. 9. Miscellaneous New Features
      1. Oracle data pump enhancements
        1. Full transportable export and import of data
          1. Restrictions in a full transportable export
        2. Disabling logging for data pump import
        3. Exporting views as a table
        4. Creating a SecureFile LOB during import
        5. Specifying an encryption password
      2. SQL Loader enhancements
        1. SQL* Loader express mode
        2. Support for loading of identity columns
        3. SQL* Loader syntax enhancements and external tables
      3. Partitioning enhancements
        1. Online partition operations
        2. Reference partitioning enhancements
          1. Interval reference partitioning
          2. CASCADE option for truncate partition
        3. Multi-partition maintenance operations
          1. Adding multiple partitions
          2. Truncating multiple partitions
          3. Merging multiple partitions
          4. Splitting multiple partitions
          5. Dropping multiple partitions
      4. Index enhancements for partitioned tables
        1. Partial index for partitioned tables
        2. Specifying default indexing property for table/partitions
          1. Creating partial local and global indexes
          2. Modifying the indexing property of a partition/table
          3. Effect of partial indexes on SQL plans
          4. Data dictionary changes
        3. Asynchronous global index maintenance
        4. The DBMS_PART package
      5. Oracle Database Migration Assistant for Unicode
      6. SecureFile LOB enhancements
      7. The row limiting clause
      8. Extended data types
        1. Enabling extended data types
      9. Summary
    16. 10. Core Administration
      1. Fundamentals of DB architecture
        1. Oracle database files
        2. Oracle instances
      2. Memory architecture of the Oracle database
        1. System Global Area
          1. Program Global Area
        2. User Global Area
      3. Oracle database process architecture
        1. Client process
        2. Server process
        3. Background processes
      4. Shared server architecture and dedicated server architecture
        1. Dedicated server processes
        2. Shared server processes
      5. Installing and configuring a database
        1. Configuring the database
        2. Data file location or OMF
        3. Enabling archiving
        4. Configuring the listener and service names
          1. Static registration
          2. Dynamic service registration
      6. Monitoring database errors and alerts
        1. Monitoring errors with trace files and alert log files
        2. Monitoring database operations with server generated alerts
      7. Perform daily administration tasks
        1. Moving tables online with the least downtime
        2. Recompiling invalid objects
        3. Using various advisors to tune various components of the database
          1. Segment advisor
          2. SQL tuning advisor
            1. Enabling and disabling automatic SQL tuning
            2. Configuring automatic SQL tuning
        4. Managing long idle sessions by creating appropriate user profiles
          1. UNLIMITED resources
      8. Apply and review patches
        1. Using Enterprise Manager cloud control
        2. Using the OPatch utility
      9. Backup and recover the database
        1. Classification of backups
          1. Backup sets vs image copies
          2. RMAN backup vs user-managed backup
          3. Hot backup versus cold backup
          4. Full backup versus incremental backup
        2. Incremental backup and block change tracking file
        3. Validating backup
          1. Physical and logical block corruption
            1. Intrablock corruption
            2. Interblock corruption
        4. Data recovery advisor
          1. Detecting failures
          2. Failure status
          3. Failure priority
          4. Manual actions and automatic repair options
          5. Repair scripts
      10. Implement flashback technology
        1. Enabling Oracle flashback
        2. Flashback database and restore points
          1. Limitations of flashback database
          2. Prerequisites for flashback database
          3. Performing a flashback database operation
          4. Enabling flashback data archive
          5. DBMS_FLASHBACK package
      11. Relocate SYSAUX occupants
      12. Create a default permanent tablespace
      13. Use secure file LOBs
        1. BasicFile LOB vs SecureFile LOB
      14. Use Direct NFS
        1. Enabling Direct NFS
      15. Summary
    17. 11. Performance Management
      1. Design the database layout for optimal performance
        1. Designing for performance and scalability
        2. Collecting application requirement
          1. Designing the schema and data model
          2. Using bind variables
          3. Using automatic segment space management
            1. Locally managed tablespaces
            2. Dictionary managed tablespaces
          4. Segment space management in locally managed tablespaces
          5. Using database resource manager
        3. Designing for availability
        4. Configuring FAST_START_MTTR_TARGET parameter
        5. Protection against corruption
        6. Configure automatic shared memory management
        7. Setting up the maximum SGA size
        8. Setting SGA target size
      2. Monitoring performance
        1. Proactive database monitoring
          1. Manually monitoring database performance
        2. Diagnosing performance problems
        3. Performance degradation over time
          1. Managing baselines
          2. Comparing period AWR
        4. Using advisors to optimize database performance
      3. Managing memory
        1. Automatic memory management
        2. Automatic shared memory management
        3. PGA memory management
        4. Setting minimums for automatically sized SGA components
        5. Configuring manually sized memory components
          1. The keep and recycle buffer caches
          2. Nonstandard block size buffer caches
      4. Analysing and identifying performance issues
        1. Automatic Workload Repository (AWR)
          1. End to end application tracing
          2. Tracing for client identifier
          3. Tracing for service, module, and action
          4. Tracing for session
          5. Tracing for the entire instance or database
          6. Using the trcsess and tkprof utility
        2. Clustering factor
      5. SQL performance analyzer
        1. Running the SQL performance analyzer
        2. Comparing SQL performance
      6. Cardinality feedback
      7. Adaptive cursor sharing
      8. The purpose of adaptive cursor sharing
        1. Bind-sensitive cursors
        2. Bind-aware cursors
        3. Adaptive cursor sharing views
      9. Implement application tuning
      10. Summary
    18. 12. Storage
      1. Managing database structures
        1. Physical storage structure
        2. Logical storage structure
        3. Undo size advisor
          1. The undo advisor a PL/SQL interface
      2. Administering ASM
        1. Administering different releases
        2. Initialization parameters for an ASM instance
        3. Authentication for an ASM instance
          1. About the SYSASM Privilege
          2. Local connection using operating system authentication
        4. Oracle ASM filesystem
          1. Filenames
          2. Directories
          3. Aliases
        5. ASM metadata backup and restore
      3. Managing ASM disks and disk groups
        1. Disk group attributes
        2. Creating disk groups
        3. Altering disk groups
        4. Oracle ASM disk discovery
        5. Disk group redundancy
        6. Oracle ASM failure groups
      4. Managing an ASM instance
        1. Starting up an ASM instance
        2. Restricted mode
        3. Shutting down an ASM instance
        4. ASM background processes
      5. Managing VLDB
        1. High availability
          1. Hardware-based mirroring
          2. Mirroring using ASM
        2. Performance and manageability
          1. Hardware-based stripping
          2. Stripping using ASM
          3. Partitioning
      6. Implementing space management
        1. Logical space management
        2. Locally managed tablespaces (default)
          1. Automatic segment-space management
          2. Manual Segment Space Management
          3. Dictionary-managed tablespaces
        3. Space management in a data block
      7. Summary
    19. 13. Security
      1. Develop and implement a security policy
        1. User security
          1. Enforcing password complexity verification
          2. Assigning a default tablespace to the user
          3. Tablespace quota for the user
          4. Temporary tablespace for the user
          5. Specifying a profile for the user
          6. Default role for the user
        2. Configuring authentication
          1. Configuring password protection
          2. Password management policy
          3. Database authentication
          4. Operating system authentication
        3. Configuring authorization
        4. Privileges and roles
          1. Managing System Privileges
          2. Allowing Access to Objects in the SYS Schema
          3. ANY privileges and PUBLIC role
          4. Managing user roles
          5. Restricting SQL*Plus users from using database roles
          6. Limiting roles through the PRODUCT_USER_PROFILE table
          7. Managing object privileges
        5. Application security
          1. Associating privileges with user database roles
          2. Configuring the maximum number of authentication attempts
      2. Configure and manage auditing
        1. Purpose of auditing
        2. Mandatory auditing
        3. Auditing types
        4. Auditing general activities with standard auditing
          1. AUDIT and NOAUDIT SQL statements
            1. Auditing SQL statements
            2. Auditing privileges
            3. Auditing schema objects
            4. Auditing network activity
            5. Auditing statement executions - successful, unsuccessful, or both
        5. Fine-grained auditing
          1. Fine-grained auditing records
          2. Using the DBMS_FGA package to manage fine-grained audit policies
          3. Creating a fine-grained audit policy
          4. Auditing specific columns and rows
          5. Disabling and enabling a fine-grained audit policy
          6. Dropping a fine-grained audit policy
      3. Create the password file
        1. Sharing and disabling the password file
        2. Keeping administrator passwords synchronized with the data dictionary
          1. Adding users to a password file
          2. Viewing password file members
      4. Implement column and tablespace encryption
        1. Benefits of using transparent data encryption
        2. Types of transparent data encryption
        3. Using transparent data encryption
          1. Specifying a wallet location for transparent data encryption
          2. Using wallets with automatic login enabled
          3. Setting the master encryption key
          4. Opening and closing the encrypted wallet
        4. Creating tables with encrypted columns
        5. Encrypting entire tablespaces
          1. Setting the tablespace master encryption key
          2. Opening the Oracle wallet
          3. Creating an encrypted tablespace
        6. Restrictions on using TDE tablespace encryption
      5. Summary