Oracle Database 18c Essential Administration

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

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

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