1/340

Contents

Title and Copyright Information

Preface

• Audience
• Related Documentation
• Conventions

Changes in This Release for Oracle Database 2 Day DBA

• Changes in Oracle Database 12c Release 1 (12.1.0.2)
  • New Features
• Changes in Oracle Database 12c Release 1 (12.1.0.1)
  • New Features

1 Introduction

• About This Guide
  • What This Guide Is Not
  • How to Use This Guide with Related Material
• About Oracle Database
• Common Oracle DBA Tasks
• Tools for Administering the Database

2 Installing Oracle Database and Creating a Database

• Overview of Installing Oracle Database Software and Creating a Database
  • Checking Oracle Database Installation Prerequisites
  • Deciding on Oracle Database Installation Choices
• Installing Oracle Database Software
• Creating and Managing a Database with DBCA
  • Starting DBCA
  • Creating a Database Using DBCA
  • Changing the Configuration of a Database Using DBCA
  • Deleting a Database Using DBCA
  • Managing Templates with DBCA
  • Using DBCA to Manage PDBs
• Manually Installing the Database Sample Schemas Post-Installation
• Installation: Oracle By Example Series

3 Getting Started with Database Administration

• Managing Your Database: An Overview
• Configuring the Operating System Environment Variables
• Introduction to Oracle Enterprise Manager Database Express
• Starting EM Express
  • Starting EM Express for a Non-CDB
  • Starting EM Express for a CDB
  • Starting EM Express for a PDB
• Configuring the HTTPS Port for EM Express
• Accessing the Database Home Page
• Granting Access to EM Express for Nonadministrative Users
• Administering the Database with SQL-Based Management Tools
  • About SQL
  • About SQL*Plus
  • Starting SQL*Plus and Connecting to the Database
  • About SQL Developer
• Getting Started with Oracle Enterprise Manager: Oracle by Example Series

4 Configuring the Network Environment

• Understanding Network Configuration
  • Oracle Net Listener Configuration
  • Client Connections
  • Tools for Network Configuration
• Viewing Listener Configuration
• Starting and Stopping the Listener
• Connecting to an Oracle Database from a Client Computer
• Networking: Oracle by Example Series

5 Managing the Oracle Instance

• Overview of the Oracle Instance and Instance Management
  • About Initialization Parameters
  • About Background Processes
  • About Server and Client Processes
  • About Instance Memory Structures
  • About Instance Startup and Shutdown
• Shutting Down and Starting Up the Oracle Instance
  • Shutting Down and Starting Up Using SQL*Plus
  • Shutting Down and Starting Up Using the Windows Services Program
• Viewing and Modifying Initialization Parameters
• Managing Memory
  • About Memory Management
  • Enabling Automatic Memory Management
  • Modifying Memory Settings – Automatic Memory Management
  • Enabling Automatic Shared Memory Management
  • Modifying Memory Settings – Automatic Shared Memory Management
  • Enabling Manual Shared Memory Management
  • Modifying Memory Settings - Manual Shared Memory Management
  • Modifying Memory Settings – Automatic PGA Memory Management
• Instances: Oracle By Example Series

6 Managing Database Storage Structures

• About Database Storage Structures
  • About Control Files
  • About Online Redo Log Files
  • About Archived Redo Log Files
  • About Rollback Segments
  • About Data Files
  • About Tablespaces
  • About Other Storage Structures
• Viewing Database Storage Structure Information
  • Viewing Control File Information
  • Viewing Online Redo Log File Information
  • Viewing Archived Redo Log File Information
  • Viewing Tablespace and Data File Information
• Performing Common Database Storage Tasks
  • Creating a Tablespace
  • Modifying a Tablespace
  • Dropping a Tablespace
• Managing the Online Redo Log
  • Multiplexing the Online Redo Log
  • Switching a Log File
• Managing Undo Data
  • About Undo Data
  • About Managing Undo Data
  • Viewing Undo Information
  • Computing the Minimum Undo Tablespace Size Using the Undo Advisor
  • Changing the Undo Tablespace to a Fixed Size
  • Changing the Datafiles for an Undo Tablespace to a Fixed Size
  • Changing Undo Management Analysis Parameters
  • Switching Undo Tablespaces
• Storage: Oracle by Example Series

7 Administering User Accounts and Security

• About User Accounts
  • About Commonality in a CDB
• About User Privileges and Roles
  • About Common and Local Roles in a CDB
  • About Privilege and Role Grants in a CDB
• About Administrative Accounts and Privileges
  • SYS and SYSTEM Users
  • SYSDBA and SYSOPER System Privileges
• Administering Roles
  • Viewing Roles
  • Example: Creating a Role
  • Example: Modifying a Role
  • Deleting a Role
• Administering Database User Accounts
  • Viewing User Accounts
  • Example: Creating a User Account
  • Creating a New User Account by Duplicating an Existing User Account
  • Example: Granting Privileges and Roles to a User Account
  • Example: Assigning a Tablespace Quota to a User Account
  • Example: Modifying a User Account
  • Locking and Unlocking User Accounts
  • Expiring a User Password
  • Example: Deleting a User Account
• Setting the Database Password Policy
  • About Password Policies
  • Modifying the Default Password Policy
• Users: Oracle by Example Series

8 Managing Schema Objects

• About Schema Objects
• About Schema Object Management Privileges
• About SQL Developer
  • Installing and Starting SQL Developer
  • Understanding the SQL Developer User Interface
  • Creating a Database Connection Using SQL Developer
• Managing Tables
  • About Tables
  • Viewing Tables
  • Viewing Table Data
  • Example: Creating a Table
  • Modifying Table Attributes
  • Example: Loading Data into a Table
  • Deleting a Table
• Managing Indexes
  • About Indexes
  • Viewing Indexes
  • Example: Creating an Index
  • Example: Deleting an Index
• Managing Views
  • About Views
  • Displaying Views
  • Example: Creating a View
  • Example: Deleting a View
• Managing Program Code Stored in the Database
  • About Program Code Stored in the Database
  • Validating (Compiling) Invalid Schema Objects
• Working with Other Schema Objects
• Schemas: Oracle by Example Series

9 Performing Backup and Recovery

• Overview of Database Backup and Recovery
  • Overview of Backing Up and Recovering CDBs and PDBs
• Database Backup and Recovery Concepts
  • ARCHIVELOG and NOARCHIVELOG Mode
  • RMAN Repository
  • Image Copies and Backup Sets
  • Full Backups and Incremental Backups
  • Consistent and Inconsistent Backups
  • Media Recovery
  • Fast Recovery Area
• Configuring Your Database for Basic Backup and Recovery
  • Planning Space Usage and Location for the Fast Recovery Area
  • Configuring Users to Perform Backup and Recovery
  • Connecting to the Target Database Using RMAN
  • Configuring Recovery Settings
  • Configuring Backup Settings
• Backing Up Your Database
  • Additional Backup Concepts
  • Performing and Scheduling Backups Using RMAN
  • Displaying Backups Stored in the RMAN Repository
  • Validating Backups and Testing Your Backup Strategy
• Displaying Backup Reports
• Managing Backups
  • About Backup Management
  • Cross-Checking Backups
  • Deleting Expired Backups
  • Marking Backups as Available or Unavailable
  • Deleting Obsolete Backups
  • Monitoring Fast Recovery Area Space Usage
• Performing Oracle Advised Recovery
  • About Data Recovery Advisor
  • Using Data Recovery Advisor
• Performing User-Directed Recovery
  • Rewinding a Table Using Oracle Flashback Table
  • Recovering a Dropped Table Using Oracle Flashback Drop
  • Rewinding a Database Using Oracle Flashback Database
  • Restoring and Recovering the Database
• Backup and Recovery: Oracle By Example Series

10 Monitoring and Tuning the Database

• Proactive Database Monitoring
  • Monitoring General Database State and Workload
  • Monitoring Performance Using the Performance Hub
  • Performance Self-Diagnostics: Automatic Database Diagnostic Monitor
• Diagnosing Performance Problems Using ADDM
  • Viewing a Summary of ADDM Performance Findings
  • Responding to ADDM Performance Findings
  • Viewing a Summary of Real-Time ADDM Findings
  • Responding to Real-Time ADDM Findings
  • Viewing a Summary of Current ADDM Findings
  • Responding to Current ADDM Findings
• Using Advisors to Optimize Database Performance
  • About Advisors
  • About the SQL Tuning Advisor
  • About the Automatic SQL Tuning Advisor
  • Configuring the Automatic SQL Tuning Advisor
  • Viewing Automatic SQL Tuning Results
  • Running the SQL Tuning Advisor
  • Optimizing Memory Usage with the Memory Advisors
• Monitoring and Tuning: Oracle by Example Series

11 Managing PDBs with EM Express

• Getting Started With Managing PDBs Using EM Express
• Overview of CDBs and PDBs
• Accessing the Containers Page in EM Express
• Modifying Resource Plans for a PDB Using EM Express
  • Using Resource Manager to Create CDB and PDB Resource Plans
  • Using EM Express to Modify a CDB Resource Plan
  • Using EM Express to Set Resource Limits for a PDB
• Setting Storage Limits for a PDB Using EM Express
• Configuring Oracle Managed Files for a CDB Using EM Express
• Provisioning a PDB Using EM Express
  • Creating a New PDB from the Seed Using EM Express
  • Creating a PDB by Cloning a PDB in the Same CDB Using EM Express
  • Creating a PDB by Cloning a PDB from a Remote CDB Using EM Express
  • Plugging in an Unplugged PDB Using EM Express
• Removing PDBs Using EM Express
  • Unplugging a PDB Using EM Express
  • Dropping a PDB Using EM Express
• Opening PDBs Using EM Express
  • Opening a PDB Using EM Express
  • Opening All the PDBs in a CDB Using EM Express
• Closing PDBs Using EM Express
  • Closing a PDB Using EM Express
  • Closing All the PDBs in a CDB Using EM Express

12 Managing Oracle Database Software

• About Software Management and Patch Releases
• Upgrading a Database
  • Overview of Database Upgrade Assistant
  • Database Releases Supported by DBUA
  • Upgrade Scenarios for Oracle Database
  • Starting DBUA
  • Upgrading a Database Using DBUA
  • Upgrading a PDB
• Removing Oracle Database Software
• Managing Oracle Software: Oracle by Example Series

Index