Get in Touch
 Duration 35 hours

Course Outline

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

  • Review of prerequisites and supported platforms
  • Process for installing Oracle Database 19c SE2 and establishing the initial database
  • Configuring post-installation elements (listeners, services, EM Express)

Oracle Database Architecture and Core Infrastructure

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

Administration Tools and Connectivity

  • Fundamentals of Enterprise Manager Express and common administrative tasks
  • Utilizing SQL Developer for both administration and development purposes
  • Configuration of Oracle Net Services and listeners (basics of dedicated/shared)

Database Creation and Instance Management

  • Building databases using DBCA and SQL
  • Managing startup/shutdown modes, services, and basic PDB awareness (suited for SE2)
  • Handling initialization parameters and dynamic performance views (V$)

Best Practices in Storage Management

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

Security and Auditing Protocols

  • Managing users, roles, system/object privileges, and applying least-privilege design
  • Enforcing password policies, profiles, and resource limits
  • Implementing auditing concepts appropriate for SE2

Backup and Recovery Strategies via RMAN

  • Defining backup types, retention policies, and recovery objectives
  • Setting up RMAN, catalogs (where relevant), and performing validation
  • Executing media recovery, point-in-time recovery, and handling failure scenarios

Performance Monitoring and Troubleshooting (SE2-Compatible Methods)

  • Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE)
  • Basics of SQL tracing and wait events
  • Implementing proactive monitoring through data dictionary and dynamic views

Migrating from 11g to 19c

  • Evaluating upgrade paths, prerequisites, and compatibility factors
  • Utilizing pre/auto-upgrade utilities and conducting validation steps
  • Completing post-upgrade tasks, addressing deprecated features, and testing

Conclusion and Future Directions

Requirements

  • Fundamental understanding of SQL
  • Experience with operating system administration (Linux or Windows)
  • Comprehension of core networking concepts (ports, services, hostnames)

Target Audience

  • System administrators
  • Technical consultants
  • Database administrators

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories