Log On/Register  

855.838.5028

Oracle 12c Administration II

Duration: 5 Days
Course Price: $2,695

COURSE OBJECTIVES

Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database.

COURSE OBJECTIVES

Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database.

1 - INTRODUCTION: MANAGING THE DATABASE INSTANCE

The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator

2 - INTRODUCTION: DATABASE ARCHITECTURE REVIEW

Database Instance Configurations Memory Structures Process Structures Storage Architecture

3 - INTRODUCTION: STARTING & STOPPING DATABSE 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

4 - 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

5 - 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

6 - 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

7 - 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

8 - 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)

9 - STORAGE: UNDO DATA & UNDO TABLESPACES

About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR

10 - SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES

Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS

11 - 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

12 - SECURITY & SCHEMAS: DATABASE AUDITING

Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy

13 - SECURITY & SCHEMAS: SQL LOADER

Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM

14 - 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

15 - PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING

Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics

16 - PERFORMANCE & AVAILABILITY: DATA CONCURRENCY

About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM

17 - PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS

Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist

Actual course outline may vary
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):