Oracle 12c Data Base Administration Express Introduction for Support Personnel

1. Introduction

• Describe the basic concepts of a relational database
• Discuss core database administrator tasks

2. Architecture

• Describe Oracle database architecture
• Understand the instance architecture
• Use the management framework, and the database creation assistant

3. Controlling the database

• Start and stop the agent, the enterprise manager database console, and the listener
• Startup and shutdown the database

4. Storage Structures

• Define the purpose of tablespaces and data files
• Create and manage tablespaces
• Obtain tablespace information

5. Administering users

• Create and manage database user accounts, and manage roles
• Grant and revoke privileges
• Control resource usage by users

6. Oracle Database Security

• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features, and Audit database activity

7. Oracle Net Services

• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners, and configure client and middle-tier connection
• Use the listener control utility to control the Oracle Net Listener
• Use TNSPING to test Oracle Net connectivity

8. Performance Monitoring

• Troubleshoot invalid / unusable objects
• Gather optimizer statistics
• View performance metrics
• Reacting to performance issues

9.     Diagnostic Sources

• Alert Logs and Trace Files
• Enterprise Manager and Alerts
• Controlling trace file size
• Alert notification

10. Backup and Recovery Concepts

• Describe the basics of database backup, restore and recovery
• List the types of failure that may occur in an Oracle Database, and Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log file
• Configure ARCHIVELOG mode
• Flashback Database / Table / Query

11. Database backups

• Create consistent database backups, incremental backups, and Automate database backups
• Monitor the flash recovery area
• Back your database up without shutting it down

12. Database Recovery

• Recover from loss of a control file, a redo log file, or a data file
• A Day in the Life of a DBA
• Periodic and As Needed Tasks

13.  Scheduler

• Creating jobs and job classes
• Creating schedules and windows
• Scheduler programs
• Prioritizing jobs
• Scheduler component reuse
• Query Scheduler information

14. SQL Tuning Tools

• Optimizer Overview
• Execution Plans
• Rule-Based Optimization (Desupported)
• Cost-Based Optimization
• Table And Index Statistics
• DBMS_STATS
• Execution Plans
• Autotrace
• SQL_TRACE And TKPROF
• Using Hints
• Stored Outlines And Plan Stability

15.  Performance Tuning

• Application Identification
• Enterprise Manager Tools
• SQL Tuning Advisor
• SQL Access Advisor
• DBMS_SQLTUNE
• DBMS_ADVISIOR
• Quick Tune

• Install and configure the Oracle 12c database
• Create and administer user accounts in the Oracle 12c database
• Backup and recover the database
• Monitor, troubleshoot, and maintain the database
• Configure Oracle Net services

Lab 1: Architecture / Advanced Memory Management

Lab 2: Starting and Stopping the Database

Lab 3:  Managing Tablespaces / Datafiles

Lab 4:  Oracle Database Files

Lab 5:  Users and Security

Lab 6:  Oracle Networking

Lab 7:  Configuring the Database for Backup

Lab 8:  Basic Database Media Recovery

Lab 9:  Archivelog Setup

Lab 10:  Automation Tools

Lab 11:  Performance Tuning Tools

Lab 12:  Oracle Job Scheduling

• Knowledge of SQL

• Database administrators
• Support engineers
• Technical consultants
• Systems administrators
• Network managers
• Technical support personnel