Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction and Fundamentals
- Overview of Oracle Database architecture for government use
- Differentiation between a database instance and the database itself
- Examination of memory and process architecture, including SGA, PGA, and background processes
- Detailed exploration of parameter files, control files, redo logs, alert logs, and trace files
- General overview of Oracle Multitenant architecture (CDB and PDB) and its scope in SE2 for government applications
Environment Preparation and Installation
- Prerequisites and supported platforms for government deployment
- Step-by-step installation of Oracle Database 19c SE2 for government systems
- Creation of the initial database using DBCA for government environments
- Post-installation configuration, including listeners, services, and Enterprise Manager Express for government use
Administration Tools and Connectivity
- Connecting to an Oracle Database instance for government operations
- Basic commands and administration using SQL*Plus for government tasks
- Utilizing Oracle SQL Developer for government database management
- Monitoring and common tasks with Oracle Enterprise Manager Express for government use
- Configuration of Net Services and listeners for government networks
Instance and Database Management
- Understanding startup and shutdown modes for government databases
- Creating a database with DBCA and SQL commands for government systems
- Managing initialization parameters and dynamic performance views (V$) for government applications
- Handling alert logs, trace files, and the Automatic Diagnostic Repository for government databases
- Utilizing the data dictionary for government database management
Connectivity and Naming Methods
- Establishing network connections for government systems
- Exploring naming methods: Easy Connect, Local Naming, and Directory Naming for government use
- Managing database services for government applications
- Configuring listener agents dynamically and statically for government environments
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Concepts of CDB and PDB for government use
- Creating PDBs using PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters for government systems
- Managing PDB modes, parameters, and host/port configurations for government databases
- Removing PDBs from government environments
- Configuring shared server settings (SGA, PGA, shared server mode) for government use
Storage Administration
- Managing tablespaces and datafiles for government databases
- Handling temporary and undo tablespaces for government systems
- Understanding segments, extents, blocks, and space management for government applications
- File growth, Oracle Managed Files (OMF), and datafile movement for government use
Security and Auditing
- Managing users, roles, and privileges with the principle of least privilege for government systems
- Configuring profiles, password policies, and resource limits for government databases
- Exploring auditing concepts in Oracle SE2 for government use
- Auditing critical operations for government applications
Backup and Recovery (RMAN)
- Developing backup strategies, including types, retention policies, and recovery objectives for government systems
- Configuring RMAN and catalogs for government databases
- Addressing recovery scenarios such as media recovery, point-in-time recovery, and common failures for government use
- Validating backups for government applications
Monitoring and Performance Optimization
- Using execution plans (EXPLAIN PLAN, AUTOTRACE) for government database optimization
- Diagnosing waits and common events in government systems
- Proactive monitoring with the data dictionary and dynamic views for government applications
- Applying tuning methods specific to SE2 for government use
Migration from Oracle 11g to 19c
- Identifying upgrade paths and prerequisites for government systems
- Utilizing pre/auto-upgrade tools for government database migrations
- Performing validation steps and resolving incompatibilities for government applications
- Completing post-upgrade tasks and addressing deprecated features for government systems
- Conducting post-migration testing for government use
Course Closure
- General summary of the course content for government applications
- Best practice recommendations for government database management
Summary and Next Steps
Requirements
- A comprehensive understanding of relational database concepts
- Practical experience with SQL
- Basic knowledge of operating systems, including Windows or Linux
Audience for Government
- Database administrators
- System administrators
- IT professionals responsible for managing Oracle environments within government agencies
49 Hours
