Get in Touch
 Duration 35 hours

Course Outline

Preparing the Environment, Installation, and Configuration (Focus on SE2)

  • Prerequisites and supported platforms
  • Installing Oracle Database 19c SE2 and initializing the database
  • Post-installation setup, including listeners, services, and EM Express

Oracle Database Architecture and Foundational Infrastructure

  • Distinguishing between instance and database concepts
  • Components such as SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
  • Managing parameter files, diagnostic destinations, and alert/trace files

Management Tools and Connectivity

  • Overview of Enterprise Manager Express and common administrative tasks
  • Utilizing SQL Developer for both administration and development workflows
  • Configuring Oracle Net Services and listeners (covering dedicated and shared basics)

Database Creation and Instance Oversight

  • Creating databases via DBCA and SQL commands
  • Managing startup/shutdown modes, services, and basic PDB awareness suitable for SE2
  • Working with initialization parameters and dynamic performance views (V$)

Best Practices in Storage Management

  • Managing tablespaces and datafiles, including local extent management, temp, and undo
  • Monitoring segments, extents, blocks, and overall space usage
  • Handling growth, relocating datafiles, and considering OMF

Security and Audit Procedures

  • Designing least-privilege models through users, roles, and system/object privileges
  • Enforcing password policies, profiles, and resource limits
  • Implementing auditing concepts tailored to SE2 environments

RMAN-Based Backup and Recovery Strategies

  • Understanding backup types, retention policies, and recovery goals
  • Configuring RMAN, managing catalogs (when applicable), and validating backups
  • Executing media recovery, point-in-time recovery, and handling failure scenarios

Performance Monitoring and Troubleshooting (SE2-Compliant Methods)

  • Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
  • Fundamentals of SQL tracing and wait events
  • Proactive monitoring through data dictionaries and dynamic views

Migrating from 11g to 19c

  • Evaluating upgrade paths, prerequisites, and compatibility factors
  • Utilizing pre- and auto-upgrade utilities along with validation steps
  • Addressing post-upgrade tasks, deprecated features, and testing requirements

Summary and Future Recommendations

Requirements

  • Fundamental understanding of SQL
  • Experience with operating system administration (specifically Linux or Windows)
  • Basic grasp of core networking concepts, including ports, services, and hostnames

Target Audience

  • System Administrators
  • Technical Consultants
  • Database Administrators

Number of participants


Price per participant

Testimonials (1)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories