The Oracle Database 12cR2 Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 12cR2 database.

The Oracle Database 12cR2 Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The Oracle Database 12cR2 Essential Administration course is not aimed at delegates who are full time Database Administrators. The focus is on using Enterprise Manager Express and SQL Developer to teach delegates how to manage the database. The usage of SQL*Plus is also covered.

The delegate will learn and acquire skills as follows:

• Installing Oracle Database 12c Software
• Creating an Oracle database
• Administering an Oracle database with Enterprise Manager Express, SQL Developer and SQL*Plus
• Configuring the Oracle Network Environment
• Creating and Managing Database Storage Structures
• Managing Schema Objects
• Managing Users
• Maintaining Database Security
• Backing up, Restoring and Recovering the Database
• Monitoring the Performance of the Database Using Advisors

Who will the Course Benefit?

The Oracle Database 12cR2 Essential Administration course is aimed at Database Administrators of small sized databases who need to install the Oracle Database 12c software, create, monitor and support an Oracle Database 12c database.

The Oracle Database 12cR2 Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 12c software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Session 1: INTRODUCTION

Oracle product overview

Oracle Support services

Relational database concepts

Oracle architecture

Oracle Multitenant architecture

Overview of the Oracle Cloud

Database administration tasks

Database administration responsibilities

Session 2: INSTALL THE ORACLE DATABASE SOFTWARE WITH THE OIU

Installation planning

Understand system requirements and operating system pre-requisites

Oracle flexible architecture

Environment variables

Use Oracle Universal Installer to install Oracle software (OUI)

The Oracle Inventory

De-install Oracle Database softare

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

Select a storage method

Select a CDB or non-CDB database

Select a database type based on workload

Select a character set for the database

Create a database using the DBCA

Session 4: ADMINISTER A DATABASE

Administrative tools available to a DBA

Use SQL*Plus and SQL Developer to manage a database

Administer the database using Enterprise Manager Express

An overview of Enterprise Manager Cloud Control

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

Overview of network configuration

Oracle Net Listener configuration and management

Oracle Net Naming methods

Tools for configuring and managing the Oracle network

Configure local naming for client connections with Net Manager

Start and stop the Oracle listener

Configure the listener with EM

Use TNSPING to test Oracle Net connectivity

Connect to the database

Oracle Database 12cR2 Essential Administration Training Course

Session 6: MANAGE AN ORACLE INSTANCE

Oracle Instance

Instance management

Memory structures

Background processes

Database authentication methods

Initialization parameters

Password file

Shut down the database

Start up the database

View alert log and trace files

Session 7: DATABASE STORAGE STRUCTURES

Oracle database structures

Control files

Redo log and archive redo log files

Tablespaces and data files

Create tablespaces

Manage tablespaces

Manage undo and use the Undo Advisor

Use Enterprise Manager Express and SQL Developer to view the storage structure of the database

Session 8: MANAGE USERS

Database administration accounts

User accounts

Create and administer user accounts

Lock and unlock user accounts

Change a user's password

Administer privileges and roles

Session 9: MANAGE SCHEMA OBJECTS

Create schema objects

Create a new table

View the attributes and contents of a table

Understand data integrity

Define constraints

Create indexes

View index attributes

Create views

Create synonyms

Create sequences

Session 10: BACKUP, RECOVER AND RESTORE A DATABASE

Oracle backup strategy

Overview of backup, restore and recovery

Backup and recovery configuration

Configure ARCHIVELOG mode

Overview of backup and recovery operations

Overview of scheduled backups

Configure backup settings

Configure recovery settings

Perform recovery

Session 11: PERFORMANCE MONITORING

Overview of self-monitoring architecture

Monitor an Oracle database

Automatic Workload Repository

Automatic Database Diagnostics Monitor (ADDM)

Additional monitoring

Use the advisors

Delegates wishing to attend the Oracle Database 12cR2 Essential Administration course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.

This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.