Get in Touch
 Duration 35 hours

Course Outline

Introduction

  • Exploration of Oracle database server architecture
  • Insights into Oracle multitenant container databases
  • Concepts of Oracle database instances and database sharding

Connecting to Oracle Database

  • Establishing connections to an Oracle database instance
  • Utilizing Oracle database tools
  • Working with SQL*Plus
  • Applying Oracle SQL developer
  • Leveraging the Database Configuration Assistant (DBCA)
  • Familiarizing with Enterprise Manager cloud control 13c capabilities
  • Review of Oracle Enterprise Manager components
  • Achieving a unified view for enterprise management
  • Administration of the Oracle Enterprise Manager database

Establishing an Oracle Database

  • Provisioning an Oracle database via DBCA
  • Initializing an Oracle database through SQL commands

Operational Control of Database Instances

  • Initiating an Oracle database instance
  • Terminating an Oracle database instance
  • Evaluating different shutdown modes
  • Managing the opening and closing of PDBs
  • Configuration of PDBs

Administration of Database Instances

  • Application of initialization parameters
  • Utilizing the automatic diagnostic repository
  • Reviewing the alert log
  • Interpreting trace files
  • Administration of the DDL log file
  • Utilizing dynamic performance views
  • Interacting with the data dictionary

Fundamentals of Oracle Net Services

  • Identification of Oracle Net Services components
  • Setup and management of Oracle Net Services
  • Review of the Oracle Net listener
  • Comparison of dedicated versus shared server architectures

Naming Mechanisms

  • Establishing Oracle network connectivity
  • Comprehension of various naming methods
  • Application of Easy Connect
  • Implementation of local and directory naming
  • Workload management via database services
  • Creation of database services

Listener Management

  • Utilizing the default listener
  • Setup of dynamic service registration
  • Setup of static service registration

Shared Server Architecture Configuration

  • Activation of shared server mode
  • Regulation of shared server operations
  • Utilization of SGA and PGA resources
  • Considerations for shared server configuration

Oracle Connect Manager Setup

  • Understanding Oracle Connection Manager
  • Application of filtering rules
  • Implementation of access controls for intranet and internet
  • Utilization of session multiplexing
  • Configuration of Oracle Connection Manager
  • Setup of the cman.ora file
  • Client configuration
  • Database server configuration
  • Use of the Oracle Connection Manager control utility

Provisioning PDBs

  • Provisioning new pluggable databases
  • Creating a new PDB from PDB$SEED
  • Application of the FILE_NAME_CONVERT clause
  • Use of OMF or the PDB_FILE_NAME_CONVERT parameter
  • Alternative methods for PDB creation

PDB Administration

  • Modification of PDB modes
  • Adjustment of PDB settings
  • Alteration of initialization parameters
  • Use of the Alter System Command within a PDB
  • Configuration of hostname and port numbers per PDB
  • Removal of PDBs

Database Storage Concepts

  • Database storage architecture
  • Database structural elements
  • Utilization of segments, extents, and blocks
  • Management of tablespaces and data files
  • Classification of segment types
  • Storage of table data
  • Content of database blocks
  • Management of deferred segment creation
  • Monitoring of tablespace utilization

Tablespace Management

  • Creation of tablespaces
  • Definition of default permanent tablespaces
  • Management of temporary tablespaces
  • Alteration and removal of tablespaces
  • Implementation of Oracle Managed Files (OMF)
  • Relocation or renaming of online data files

Space Utilization Optimization

  • Understanding of space management features
  • Management of block space
  • Specification of table compression

Undo Data Management

  • Management of transactions and undo data
  • Storage of undo information
  • Configuration of undo retention
  • Enablement of temporary undo

User Account Provisioning and Management

  • Review of Oracle-supplied administrator accounts
  • User authentication processes
  • Assignment of quotas

Privilege and Role Authorization Configuration

  • Understanding of system privileges
  • Configuration of system privileges
  • Management of privileges

User Resource Limit Configuration

  • Management of profiles and users
  • Understanding of profile parameters

Oracle Database Auditing

  • Understanding of database security principles
  • Implementation of auditing
  • FGA policy application

Data Loading and Transfer

  • Data migration processes
  • Methods of data loading
  • Data export and import procedures
  • Database transport mechanisms

Database Monitoring

  • Performance management activities
  • Database maintenance procedures
  • Understanding of performance tuning methodologies

Database Process Management

  • Process architecture and structural components
  • Utilization of various writer and monitor processes

Memory Management

  • Administration of memory components
  • Implementation of automatic memory management

SQL Analysis

  • Utilization of the Oracle optimizer
  • Optimization of access paths
  • Application of SQL plan directives

Requirements

  • Fundamental understanding of SQL

Intended Audience

  • System administrators
  • Technical consultants
  • Database administrators

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories