ORACLE Database 12c

Admin, Install and Upgrade Accelerated

Ihr Nutzen

Nach dem Seminar verstehen Sie die Konzepte der Oracle Datenbank 12c und können Datenbankinstanzen installieren, konfigurierung und warten. In diesem Intensivworkshop werden die Inhalte intensiv und komprimiert (früher Teil 1 & 2) vermittelt.

Inhalte

PDF Konfigurator

    1. Tag

    • Oracle Database 12c Overview
    • Introduction & Architecture
    • Instance Configurations, Memory Structures, Process Structures
    • Database Storage Architecture
    • Logical and Physical Database Structures
    • Container and Pluggable Database Overview
    • Installing Oracle Grid Infrastructure for a Standalone Server
    • Grid Infrastructure for a Standalone Server
    • Configuring Storage for Automatic Storage Management (ASM)
    • Installing Grid Infrastructure for a Standalone Server
    • Installing Oracle Database Software
    • Planning Your Installation, System Requirements
    • Using 4 KB Sector Disks
    • Setting Environment Variables
    • Creating an Oracle Database by Using DBCA
    • Planning the Database Storage Structure
    • non-CDB or CDB, Types of Databases (based on workload)
    • Choosing the Appropriate Character Set
    • Using the Database Configuration Assistant (DBCA)
    • Using Oracle Restart
    • Overview & Process startup
    • Controlling Oracle Restart
    • Oracle Restart Configuration
    • Using the SRVCTL Utility

    2. Tag

    • Introduction to Upgrading to Oracle Database 12c
    • Upgrade Methods, Data Migration Methods
    • Overview of Upgrade Process
    • Performing a Rolling Upgrade, Upgrading a CBD
    • Preparing to Upgrade to Oracle Database 12c
    • Developing a Test Plan, Performance Testing
    • Using the Pre-Upgrade Information Tool
    • Backing Up the Database
    • Installing the Oracle Database 12c Software
    • Preparing the New Oracle Home
    • Upgrading to Oracle Database 12c
    • Upgrading by Using the Database Upgrade Assistant (DBUA)
    • Migrating Data by Using Oracle Data Pump
    • Data Pump Overview
    • Migrating by Using Data Pump
    • Importing by Using a Network Link

    3. Tag

    • Exploring the Oracle Database Architecture
    • Architecture Overview
    • Instance Configurations, Memory Structures
    • Process Architecture, Process Structures
    • Database Storage Architecture
    • Managing the Database Instance
    • Understanding the Enterprise Manager Management Framework
    • Logging in to Oracle Enterprise Manager Database Express
    • Using the Enterprise Manager Database Express Home Page
    • Using Enterprise Manager Cloud Control
    • Using SQL*Plus and SQL Developer
    • Initialization Parameter Files
    • Configuring the Oracle Network Environment
    • Oracle Net Services and Net Listener
    • Listener Control Utility, Assistant and Manager
    • Enterprise Manager Cloud Control
    • Managing Database Storage Structures
    • Database Block Contents
    • Exploring the Storage Structure
    • Creating and Managing Tablespaces

    4. Tag

    • Administering User Security
    • Database User Accounts, Administrative Accounts
    • Authentication, Privileges, Roles, Profiles
    • Managing Data Concurrency
    • Locking Mechanism, Data Concurrency
    • DML Locks, Enqueue Mechanism, Lock Conflicts
    • Managing Undo Data
    • Transactions and Undo Data
    • Storing Undo Information
    • Comparing Undo Data and Redo Data
    • Configuring Undo Retention
    • Implementing Oracle Database Auditing
    • Separation of Responsibilities, Database Security
    • Monitoring for Compliance, Standard Database Auditing
    • Unified Audit Data Trail
    • Performing Database Maintenance
    • Database Maintenance
    • Viewing the Alert History
    • Automatic Workload Repository (AWR)
    • Automatic Database Diagnostic Monitor (ADDM)
    • Advisory Framework, Enterprise Manager and Advisors

    5. Tag

    • Managing Performance
    • Performance Monitoring
    • Tuning Activities, Performance Planning
    • Instance Tuning, Monitoring Performance, Managing Memory
    • Performance Tuning Methodology & Data
    • Managing Performance: SQL Tuning
    • SQL Tuning, Oracle Optimizer
    • SQL Plan Directives, Adaptive Execution Plans
    • SQL Tuning Advisor
    • Managing Resources by Using Database Resource Manager
    • Database Resource Manager Concepts
    • Using the Resource Manager
    • Default Maintenance Resource Manager Plan
    • Resource Manager Workflow
    • Specifying Resource Plan Directives
    • Resource Allocation Methods for Resource Plans

    Zielgruppe

    IT Professional

    Original-Seminar

    D79027 mit digitalen Seminarunterlagen.

    Voraussetzungen

    Seminar ORACLE Introduction to SQLORACLE Database, Introduction to SQLoder praktische Erfahrung mit SQL

    Dauer und Investition

    Seminardauer: 5 Tag(e)
    € 3500,- pro Teilnehmer excl. MwSt.

    Individuelle Firmenseminare
    Frühbucher-Bonus möglich
    Mehr Teilnehmer?
    Punktekarte

    Beschreibung

    Oracle 12c ist eine Datenbank, die für Grid-Computing konzipiert ist. Neben Enterprise-Class Features wir Clustering, Skalierbarkeit und Hochverfügbarkeit sind intelligente Optimierungsfunktionen ein wichtiger Aspekt.

    Hinweis

    D79027, Dieses Seminar wird mit einem zertifizierten Trainingspartner durch geführt und dient somit auch als Vorbereitung für Ihre Zertifizierung.