Get in Touch
 Duration 35 hours

Course Outline

Environment Setup, Installation, and Configuration (SE2 Focus)

  • Prerequisites and compatible platforms
  • Installation of Oracle Database 19c SE2 and initial database creation
  • Post-installation configuration, including listeners, services, and EM Express

Oracle Database Architecture and Core Infrastructure

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

Administrative Tools and Connectivity

  • Essential tasks in Enterprise Manager Express
  • Utilizing SQL Developer for both administration and development workflows
  • Oracle Net Services and listener configuration, including dedicated/shared basics

Database Creation and Instance Management

  • Creating databases using DBCA and SQL commands
  • Startup/shutdown modes, services, and basic PDB awareness suitable for SE2
  • Initialization parameters and dynamic performance views (V$)

Storage Management Best Practices

  • Tablespaces and datafiles (local extent management, temp/undo)
  • Monitoring segments, extents, blocks, and space usage
  • Managing growth, relocating datafiles, and OMF considerations

Security and Auditing

  • Managing users, roles, system/object privileges, and least-privilege design
  • Configuring password policies, profiles, and resource limits
  • Auditing concepts and implementation suitable for SE2 environments

Backup and Recovery Strategies with RMAN

  • Backup types, retention policies, and recovery objectives
  • RMAN configuration, catalogs (where applicable), and validation processes
  • Media recovery, point-in-time recovery, and handling failure scenarios

Performance Monitoring and Troubleshooting (SE2-Safe Methods)

  • Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
  • SQL tracing and understanding wait events
  • Proactive monitoring using data dictionary and dynamic views

Migrating from 11g to 19c

  • Upgrade paths, prerequisites, and compatibility checks
  • Using pre/auto-upgrade utilities and performing validation steps
  • Post-upgrade tasks, addressing deprecated features, and testing

Summary and Recommended Next Steps

Requirements

  • Fundamental knowledge of SQL
  • Proficiency in operating system administration (Linux or Windows)
  • Grasp of core networking concepts, including ports, services, and hostnames

Target Audience

  • System administrators
  • Technical consultants
  • Database administrators

Testimonials (1)

Upcoming Courses

Related Categories