Introduction to Oracle DBA

• Introduction on Oracle DBA
• Oracle 12c DBA Architecture
• Explore the Oracle 11g database architecture
• Oracle Database Overview, DBA Responsibilities

Installing the Oracle Database Software

• Install software with the Oracle Universal Installer (OUI)
• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Installation: System Requirements
• Installing Oracle Grid Infrastructure
• Installing Oracle Database Software
• Install and configure 11g and 12c Oracle Database Software

Creating an Oracle Database

• Create a database with the Database Configuration Assistant (DBCA)
• Create a database design template with the DBCA
• Generate database creation scripts with the DBCA
• Using the DBCA to Create a Database
• Password Management
• Using the DBCA to Delete a Database

Managing the Oracle Instance

• Start and stop the Oracle database and components
• Use Enterprise Manager (EM)
• Access a database with SQL*Plus and iSQL*Plus
• Modify database initialization parameters
• Understand the stages of database startup
• Describe the stages of database startup
• Describe database shutdown options
• View the Alert log, Use the Data Dictionary

Managing Database Storage Structures

• Using appropriate Storage settings, Types of segments.
• Describe table data storage (in blocks)
• Define the purpose of tablespaces and data files
• Understand and utilize Oracle Managed Files (OMF)
• Space Management in Tablespaces
• Tablespaces in the Preconfigured Database
• Automatic Storage Management (ASM)
• Set up initialization parameter files for ASM instance
• Managing Undo Data, Explain DML and undo data generation

Administering User Management

• Create and manage database user accounts
• Authenticate users, Predefined Administrative Accounts
• Assign default storage areas (tablespaces)
• Create and manage roles & profiles
• Implement standard password security features
• Control resource usage by users

Implementing Oracle Database Security

• Describe DBA responsibilities for security
• Apply the principle of least privilege
• Enable standard database auditing
• Specify audit options, Review audit information

Configuring the Oracle Network Environment

• Create additional listeners
• Create Net Service aliases
• Configure connect-time failover
• Control the Oracle Net Listener
• Test Oracle Net connectivity
• Identify when to use shared versus dedicated servers
• Use Enterprise Manager to create and configure the Listener
• Enable Oracle Restart to monitor the listener
• Use tnsping to test Oracle Net connectivity
• Identify when to use shared servers and when to use dedicated servers