1Z0-068: Oracle Database 12c - RAC and Grid Infrastructure Administration

Exam Number: 1Z0-068

Exam Title: Oracle Database 12c - RAC and Grid Infrastructure Administration

Associated Certification Paths

Oracle 1Z0-068 Certification Details:

Exam Name Oracle Database 12c - RAC and Grid Infrastructure Administration
Exam Code 1Z0-068
Exam Product Version Oracle Database 12c
Exam Price USD $245
Duration 150 minutes
Number of Questions 90
Passing Score 60%
Section 1 - 60%
Section 2 - 45%
Section 3 - 33%
Validated Against Exam has been validated for product version
Format Multiple Choice
Recommended Practice 1Z0-068 Online Practice Exam
Recommended Training Oracle Database 12c: ASM Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: RAC Administration

Oracle 1Z0-068 Certification Topics:

Oracle Database 12c: RAC Administration

Grid Infrastructure
  • Explain the principles and purposes of clusters
  • Describe the Oracle Clusterware architecture
  • Describe how Grid Plug and Play affects Clusterware
RAC Databases and Architecture
  • Describe the benefits of Oracle RAC
  • Explain the necessity of global resources
  • Describe global cache coordination
Installing and Configuring Oracle RAC
  • Install the Oracle database software
  • Create a cluster database
  • Perform post-database-creation tasks
  • Convert a single instance Oracle database to RAC
Administering Oracle RAC
  • Use Enterprise Manager Cluster Database pages
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment
Managing Backup and Recovery for RAC
  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Configure RMAN for the RAC environment
Managing Global Resources
  • Explain the need for  global concurrency control
  • Describe the Global Resource Directory
  • Explain how  global resources are managed
  • Explain global enqueue and instance lock management
  • Explain global buffer cache management
RAC Database Monitoring and Tuning
  • Identify RAC-specific tuning components
  • Determine RAC-specific wait-events, global enqueues and system statistics
  • Implement the most common RAC tuning practices
  • Use the Cluster Database Performance pages
  • Use the Automatic Workload Repository (AWR) in RAC
  • Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Managing High Availability of Services
  • Configure and manage services in a RAC environment
  • Use services with client applications
  • Use services with the Database Resource Manager
  • Use services with the Scheduler
  • Configure services aggregation and tracing
Managing High Availability for Connections and Applications
  • Configure client-side connect-time load balancing and failover
  • Configure server-side connect-time load balancing
  • Use the Load Balancing Advisory (LBA)
  • Explain the benefits of Fast Application Notification (FAN)
  • Configure server-side callouts
  • Configure the server- and client-side ONS
  • Configure Transparent Application Failover (TAF)
Upgrading and Patching Oracle RAC
  • Describe the different types of patches
  • Plan for rolling patches and rolling updates
  • Install a patchset with the Oracle Universal Installer (OUI) utility
  • Install a patch with the opatch utility
Managing Oracle RAC One Node
  • Perform an online database migration
  • Add an Oracle RAC One Node database to an existing cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Use DBCA to convert a single-instance database to a RAC One Node database
Using Oracle Database Quality of Service Management (QoS)
  • Explain the purpose and benefits of using QoS
  • Describe the components of QoS
  • Explain the operation of QoS
Using Multitenant Architecture in a RAC Environment
  • Describe the multitenant architecture in RAC and non-RAC environments
  • Create a RAC multitenant container database (CDB)
  • Create a pluggable database (PDB) in a RAC CDB
  • Use the default CDB and PDB services
  • Create PDB services to associate PDB services with server pools
  • Drop a PDB from a RAC CDB
Oracle Database 12c: Grid Infrastructure Administration
Introduction to Clusterware
  • Explain the principles and purposes of clusters
  • Describe Cluster hardware best practices
  • Describe how Grid Plug and Play affects Clusterware
Oracle Clusterware Architecture
  • Explain the Oracle Clusterware architecture
  • Describe Oracle Clusterware startup details
Flex Clusters
  • Explain the Flex Cluster architecture and components
  • Describe the effect of node failure in a Flex Cluster
Grid Infrastructure Installation Planning and Pre-Tasks
  • Plan for Grid Infrastructure installation
  • Verify system and network requirements
  • Install required OS packages
  • Set kernel parameters
  • Create groups and users
  • Create directories
  • Configure shell limits
Grid Infrastructure Installation
  • Install Grid Infrastructure
  • Verify the installation
  • Configure ASM disk groups
Managing Cluster Nodes
  • Perform the prerequisite steps to extend a cluster
  • Use addNode.sh to add a node to a cluster
  • Delete a node from a cluster
Traditional Clusterware Management
  • Perform day to day Clusterware administration tasks
  • Perform Oracle Cluster Registry (OCR) backup and recovery
  • Manage network settings
  • Explain the scope and capabilities of what-if command evaluation
Policy-Based Cluster Management
  • Explain the architecture and components of policy-based cluster management
  • Administer server categorization
  • Administer a policy set
  • Activate a policy
Upgrading and Patching Grid Infrastructure
  • Explain the types of patches and upgrades available
  • Plan for rolling patches and rolling upgrades
  • Compare software versions with the active version
  • Install a patchset with the Oracle Universal Installer (OUI)
  • Install a patch with the opatch utility
Troubleshooting Oracle Clusterware
  • Locate the Oracle Clusterware log files and use diagcollection.pl
  • Enable resource debugging
  • Enable component-level debugging
  • Enable tracing for Java-based tools
  • Troubleshoot the Oracle Cluster Registry (OCR) file
Making Applications Highly Available with Oracle Clusterware
  • Explain the hivh availability components of Oracle Clusterware
  • Explain policy-managed and administration-managed databases
  • Create an application Virtual IP (VIP)
  • Manage application resources
Automatic Storage Management (ASM) Administration
Overview of ASM
  • Explain the Automatic Storage Management (ASM) architecture
  • Describe the components of ASM
Administering ASM Instances
  • Explain and apply initialization parameters for ASM instances
  • Manage ASM instances and associated processes
  • Monitor ASM instances using the V$ASM dynamic performance views
  • Describe the architecture and components of Flex ASM
  • Install and configure Flex ASM
  • Manage Flex ASM
Administering ASM Disk Groups
  • Create and delete ASM disk groups
  • Set the attributes of an existing ASM disk group
  • Perform ongoing maintenance tasks on ASM disk groups
  • Explain key performance and scalability considerations for ASM disk groups
Administering ASM Files, Directories and Templates
  • Use client tools to access ASM files
  • Describe the format of a fully qualified ASM file name
  • Explain how ASM files, directories and aliases are created and managed
  • Describe and manage disk group templates
Administering Oracle CloudFS
  • Administer ASM Dynamic Volume Manager
  • Manage ASM volumes
  • Implement ASM Cluster File System (ACFS)
  • Use ACFS snapshots
Oracle CloudFS Advance Topics
  • Configure ACFS auditing
  • Implement ACFS encryption
  • Configure and manage ACFC replication
  • Implement ACFS tagging
  • Describe the ASCF plug-in architecture
  • Configure High Availability NFS

Oracle 1Z0-068 - Oracle Database 12c - RAC and Grid Infrastructure Administration Exam Preparation: