Oracle Database 12c: Administration Workshop

Content Summary

Audience

The target audience for this eTextbook is all Oracle professionals. Among the specific groups for whom this eTextbook will be helpful are:

• Database administrators
• Application designers and developers
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Chief Information Officers (CIO) and other information technology (IT) management professionals

Prerequisites

These are recommended prerequisites for this eTextbook:

• Oracle Database 12c: SQL Fundamentals (Levels I & II) 
• Oracle Database 12c: Install & Upgrade Workshop
• Oracle Database 12c: Architecture & Internals

Certification

This textbook considers subjects applicable to certification as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".

Contents

Introduction: Managing The Database Instance
• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administration Duties

Introduction: Database Architecture Review
• Database Instance Configurations
• Memory Structures
• Process Structures
• Storage Architecture

Introduction: Starting & Stopping Database Services
• Start & Stop The Database Listener
• About Database Startup/Shutdown
• SYSOPER
• SYSDBA
• Database State & Stages
• Startup With EM Cloud Control
• Startup With SQL*PLUS
• Shutdown With EM Cloud Control
• Shutdown With SQL*PLUS
• Using MS Windows Services

Introduction: Oracle Network Environment
• Oracle NET Services Architecture
• Oracle NET Configuration Assistant
• Oracle NET Manager
• Using EM Cloud Control
• Advanced Network Compression
• Troubleshooting Network Problems

Introduction: Diagnostics & Oracle Support
• About Database Diagnostics
• Fault Diagnosability Infrastructure
• Database Instance Health Snapshot
• The Support Workbench
• Proactive Database Health Checks
• Package Diagnostic Data
• Working With The Knowledge Base

Storage: Tablespace Management
• Starter Tablespaces
• Create Tablespace With EM CC
• Create Tablespace With SQL
• Manage Tablespaces With EM CC
• Manage Tablespaces With EM DE
• Manage Tablespaces With SQL
• DROP Tablespace
• ALTER Tablespace

Storage: Advanced Tablespace Management
• Managing Temporary Tablespaces
• Temp Tablespace Groups With EM
• Temp Tablespace Groups With SQL
• Default Permanent Tablespaces
• Bigfile Tablespaces
• Managing The SYSAUX Tablespace

Storage: Data Files & Temp Files Management
• Manage Data Files With EM
• Access Metadata With SQL
• Manage Data Files With SQL
• Manage Temp Files
• Oracle-Managed Files (OMF)

Storage: Undo Data & Undo Tablespaces
• About Undo Space Management
• Configure Undo Management
• Guarantee Undo Retention
• Monitor Undo Space With SQL
• Use The EM Undo Advisor

Security & Schemas: Security Overview & Database Privileges
• Database Security Principles
• Database System Privileges
• Database Object Privileges
• Super Administrator Roles
• Privilege Analysis

Security & Schemas: User Security
• Create & Manage User Accounts
• Manage Users With EM
• Manage Users With SQL
• CREATE User
• ALTER User
• DROP User
• Grant & Revoke Privileges
• Resource Limits Via Profiles
• ALTER Profile
• DROP Profile
• Password Management Via Profiles
• Role-Based Security Management
• Alter User...Default Role
• Set Role
• Delegating Privilege Authorization
• With Admin Option & System Privileges
• With Grant Option & Object Privileges
• Principle Of Least Privilege Checklist

Security & Schemas: Database Auditing
• Auditing Database Activity
• Traditional Auditing
• Unified Auditing
• Create Audit Policy

Security & Schemas: SQL Loader
• Loader Concepts
• Loader From The Command Line
• Control File Options
• Load Methods
• Loader Express Mode
• Loader From EM

Security & Schemas: Export & Import
• Manage Directory Objects
• The Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Dictionary Views
• Using The EM Cc Interface

Performance & Availability: Managing Performance & SQL Tuning
• Management Advisory Framework
• Performance Monitoring & AWR
• The SQL Tuning Advisor
• Monitoring Exceptions With Metrics

Performance & Availability: Data Concurrency
• About System & User Locks
• Monitor & Manage User Locks
• Monitor Locks With Data Dictionary
• Manage Locks With EM

Performance & Availability: Backup & Recovery Concepts
• Backup & Recovery Structures
• Managing Redo Data
• Configuring For Recoverability
• Instance Recovery
• Recoverability Checklist