Certificate Authentication

Introduction

• Overview of Oracle database server architecture
• Overview of Oracle multitenant container database
• Oracle database instance and database sharding

Accessing Oracle Database

• Connecting to an Oracle database instance
• Using Oracle database tools
• SQL*Plus
• Using Oracle SQL developer
• Using Database Configuration Assistant (DBCA)
• Understanding the Enterprise Manager cloud control 13c features
• Overview of Oracle Enterprise Manager component
• Single pane of glass for enterprise management
• Managing Oracle Enterprise Manager database

Creating an Oracle Database

• Creating an Oracle database using DBCA
• Creating an Oracle database using an SQL command

Working with Database Instances

• Starting the Oracle database instance
• Shutting down an Oracle database instance
• Comparing Shutdown modes
• Opening and closing PDBs
• Configuring PDBs

Managing Database Instances

• Using initialization parameters
• Working with the automatic diagnostic repository
• Viewing the alert log
• Using trace files
• Administering the DDL log file
• Working with dynamic performance views
• Using a data dictionary

Overview of Oracle Net Services

• Defining components of Oracle net services
• Configuring and managing Oracle net services
• Overview of Oracle net listener
• Comparing dedicated and shared server architecture

Naming Methods

• Establishing Oracle network connections
• Understanding the naming methods
• Easy connect
• Local and directory naming
• Managing workloads using database services
• Creating database services

Working with the Listener

• Using the default listener
• Configuring dynamic service registration
• Configuring static service registration

Configuring a Shared Server Architecture

• Enabling a shared server
• Controlling shared server operations
• Using SGA and PGA
• Shared server configuration considerations

Configuring Oracle Connect Manager

• Understanding Oracle Connection Manager
• Using filtering rules
• Implementing intranet and internet access control
• Using session multiplexing
• Configuring Oracle Connection Manager
• Configuring the cman.ora file
• Configuring clients
• Configuring the database server
• Using the Oracle Connection Manager control utility

Creating PDBs

• Provisioning new pluggable databases
• Creating a new PDB from PDB$SEED
• Using the FILE_NAME_CONVERT clause
• Using OMF or the PDB_FILE_NAME_CONVERT parameter
• Other techniques for creating PDBs

Managing PDBs

• Changing the PDB mode
• Modifying PDB settings
• Changing initialization parameters
• Using the Alter System Command in a PDB
• Configuring hostname and port number per PDB
• Dropping PDBs

Understanding Database Storage

• Database storage architecture
• Database structures
• Using segments, extents, and blocks
• Using tablespaces and data files
• Understanding the types of segments
• Storing table data
• Database block content
• Managing deferred segment creation
• Monitoring tablespace space usage

Managing Tablespaces

• Creating tablespaces
• Defining default permanent tablespaces
• Working with temporary tablespaces
• Altering and dropping tablespaces
• Implementing Oracle Managed File (OMF)
• Moving or renaming online data file

Improving Usage Space

• Understanding space management features
• Managing block space
• Specifying table compression

Managing Undo Data

• Managing transactions and undo data
• Storing undo information
• Configuring undo retention
• Enabling temporary undo

Creating and Managing User Accounts

• Oracle-supplied administrator accounts
• Authenticating users
• Assigning quotas

Configuring Privilege and Role Authorization

• Understanding system privileges
• Configuring system privileges
• Managing privileges

Configuring User Resource Limits

• Managing profiles and users
• Understanding profile parameters

Oracle Database Auditing

• Understanding database security
• Auditing implementation
• FGA policy

Loading and Transporting Data

• Moving data
• Data loading methods
• Exporting and importing data
• Transporting a database

Database Monitoring

• Performance management activities
• Maintaining databases
• Understanding methods of performance tuning

Database Processes

• Process architecture and structure
• Using the different writer and monitor process

Managing Memory

• Managing memory components
• Automatic memory management

Analyzing SQL

• Using Oracle optimizer
• Optimising access paths
• SQL plan directives

Summary and Next Steps