Course Outline

1. Introduction
Objectives 1-2
Oracle GoldenGate: What Is It? 1-3
Why Do You Need Oracle GoldenGate for Government? 1-4
Uses of Oracle GoldenGate for Government 1-5
Use Case Example Oracle GoldenGate for Operational Reporting in Government 1-6
Oracle GoldenGate for Oracle Database Eliminate Down Time for Migrations and Application Upgrades for Government 1-7
Oracle GoldenGate for Oracle Database Eliminate Down Time During Oracle Database Upgrades for Government 1-8
Oracle GoldenGate for Oracle Database Eliminate Unplanned Down Time with Active Data Guard for Government 1-9
Oracle GoldenGate Eliminate Unplanned Down Time with Live Standby for Government 1-10
Oracle GoldenGate Increase Return on Investment on Existing Servers and Synchronize Global Data for Government 1-11
Oracle GoldenGate for Oracle Database Complete Data Replication Platform for Sharded Database for Government 1-12
Oracle GoldenGate for Oracle Database Offload Redo Logs for Government 1-13
Oracle GoldenGate for Oracle Database Improve Production System Performance and Lower Costs for Government 1-14
Oracle GoldenGate Topologies for Government 1-15
Supported Databases for Government 1-17
Oracle GoldenGate for Big Data: Typical Data Flow for Government 1-18
Supported Operating Systems for Government 1-19
Oracle Middleware for Business Intelligence for Government 1-20
Oracle GoldenGate and Oracle Data Integrator for Government 1-21
Oracle GoldenGate Product Line for Government 1-22
Quiz 1-23
Summary 1-26
Practice 1 Overview: Verifying the Lab Environment for Government 1-27

2. Oracle GoldenGate Architecture
Objectives 2-2
Oracle GoldenGate Architectures for Government 2-3
Classic Versus Microservices Architecture for Government 2-4
Oracle GoldenGate Classic Architecture for Government 2-5
Classic Architecture: Components of Oracle GoldenGate for Government 2-6
Microservices Architecture for Government 2-12
Microservices Architecture Example for Government 2-13
Microservices Architecture: Main Components for Government 2-14
Microservices Architecture: Additional Components for Government 2-15
Microservices Architecture: REST API for Government 2-16
The REST API for Government 2-17
Microservices Architecture: Service Manager for Government 2-18
Microservices Architecture: Security, Authentication, and Authorization for Government 2-19
Microservices Architecture Authentication for Government 2-20
Microservices Architecture: Secure and Nonsecure Deployments for Government 2-21
Microservices Architecture: 19c Secure Deployment Options for Government 2-22
Microservices Architecture: Target Initiated Paths for Government 2-23
Microservices Architecture: ipACL for Government 2-24
Microservices Architecture: Roles for Government 2-26
Microservices Architecture: GoldenGate 19c Security Features for Government 2-28
Microservices Architecture: Integration with External Key Management Services for Government 2-29
Oracle GoldenGate Process Groups for Government 2-30
Process Group Naming Conventions for Government 2-31
Classic Architecture: GGSCI for Government 2-33
Parameter Files for Government 2-34
Extract Types for Government 2-35
Microservices Architecture: Capture and Delivery Using a Distribution Server and Path for Government 2-36
Classic Architecture: Capture and Delivery Workflow for Government 2-37
Classic Architecture: Capture and Delivery Using a Data Pump for Government 2-39
Distributed Topologies for Integrated Extract: Same Machine for Government 2-40
Distributed Topologies for Integrated Extract: Different Machine, Real Time for Government 2-41
Distributed Topologies for Integrated Extract: Different Machine, Non-Real-Time for Government 2-42
Online Versus Batch Operation for Government 2-43
Running an Initial Load for Government 2-44
Classic Architecture: Initial Load Workflow for Government 2-45
Microservices Architecture: Initial Load Workflow for Government 2-46
Checkpoints: Capture for Government 2-47
Checkpoints: Pump (CA Only) for Government 2-48
Checkpoints: Distribution Server Path (MA Only) for Government 2-49
Checkpoints: Delivery for Government 2-50
Commit Sequence Number for Government 2-51
Discussion Questions 2-52
Quiz 2-53
Summary 2-54

3. Installing Oracle GoldenGate Microservices Architecture for Government
Objectives 3-2
Operating System Requirements: Memory for Government 3-3
Operating System Requirements: Swap for Government 3-4
Operating System Requirements: Disk for Government 3-5
Operating System Requirements: Network for Government 3-6
Operating System Requirements: Privileges for Government 3-7
Oracle GoldenGate 19c MA Software Bundle for Government 3-8
Phase 1, Step 1: Select the Database Release for Government 3-9
Phase 1, Step 2: Select the GoldenGate Home for Government 3-10
Phase 1, Step 3: Install the Software for Government 3-11
Phase 1, Steps 4 and 5: Monitor the Installation for Government 3-12
Phase 2: Creating Certificates for Government 3-13
Example: Create a Self-Signed CA Certificate for Government 3-14
Example: Self-Signed Server Certificate Creation for Government 3-15
Example: Self-Signed Client Certificate Creation for Government 3-17
Adding Trusted Points for Government 3-19
Configuring MA Servers/Services Using oggca for Government 3-20
Phase 3, oggca.sh Step 1: Service Manager Details for Government 3-21
Phase 3, oggca.sh Step 2: Deployment Configuration Option for Government 3-22
Phase 3, oggca.sh Step 3: Deployment Details for Government 3-23
Phase 3, oggca.sh Step 4: Deployment Home for Government 3-24
Phase 3, oggca.sh Step 5: Deployment Home for Government 3-25
Phase 3, oggca.sh Step 6: Administrator Account for Government 3-26
Phase 3, oggca.sh Step 7: SSL/TLS Security for Government 3-27
Phase 3, oggca.sh Step 8: Cryptography Protocols for Government 3-28
Phase 3, oggca.sh Step 9: Servers and Monitoring for Government 3-30
Phase 3, oggca.sh Step 10: Replication Options for Government 3-31
Phase 3, oggca.sh Step 11: Click Finish or Save Response File for Government 3-32
Phase 3, oggca.sh Step 12: Execute Configuration Scripts for Government 3-33
Phase 3, oggca.sh Step 13: Select Close for Government 3-34
Verifying Deployment Configuration Using Browser for Government 3-35
MA Admin Client Overview for Government 3-36
Admin Client and GGSCI: Similarities and Differences for Government 3-37
Admin Client: MA-Specific Syntax for Government 3-38
Admin Client Environment Variables for Government 3-39
Connecting Using the adminclient for Government 3-40
Verifying Deployment Configuration Using adminclient for Government 3-41
Discussion Questions 3-42
Quiz 3-43
Summary 3-45
Practice 3 Overview: Installing Oracle GoldenGate Microservices Architecture for Government 3-46

4. Installing Oracle GoldenGate Classic Architecture for Government
Objectives 4-2
Operating System Requirements: Memory for Government 4-3
Operating System Requirements: Disk for Government 4-4
Operating System Requirements: Network for Government 4-5
Downloading Oracle GoldenGate for Government 4-6
Setting Environment Variables for Government 4-7
Installation on UNIX, Linux, or z/OS Systems for Government 4-8
Oracle Universal Installer GUI for Government 4-9
Installation on Linux Using a tar Command for Government 4-11
Installation on Windows Systems for Government 4-12
Oracle GoldenGate Directories for Government 4-13
GGSCI Command Interpreter for Government 4-17
GGSCI Commands for Government 4-18
GGSCI Examples for Government 4-22
Obey Files for Government 4-23
Running Oracle GoldenGate from the OS Shell for Government 4-24
Discussion Questions 4-25
Summary 4-26
Practice 4 Overview: Installing Oracle GoldenGate Classic Architecture for Government 4-27

5. Preparing the Environment for Government
Objectives 5-2
Configuring Oracle GoldenGate: Overview for Government 5-3
Configuring Oracle GoldenGate for Government 5-4
Preparing the Environment: Enabling Oracle GoldenGate in the Database for Government 5-5
Preparing the Environment: Defining Roles and Privileges for Government 5-6
Create a Wallet and Credential Store for Government 5-9
Preparing the Environment: Supplemental Logging for Government 5-10
CA: Using Command Security for Government 5-12
CA: Sample CMDSEC Statements for Government 5-13
Handling TCP/IP Errors for Government 5-14
The tcperrs File for Government 5-15
CA: Preparing the Environment - Starting the Manager for Government 5-16
CA: Preparing the Environment - Sample Manager Parameter File for Government 5-17
Preparing the Environment: Generating an Optional Target Definitions File for Government 5-18
Replication Lag Analysis for Government 5-19
Quiz 5-20
Summary 5-22
Practice 5 Overview: Preparing the Environment for Government 5-23

6. Configuring the Extracts for Government
Objectives 6-2
Step 2: Change Capture for Government 6-3
Extract: Overview for Government 6-4
CA: Data Pump Overview for Government 6-5
CA Data Pumps: One-to-Many Trails for Government 6-6
CA Data Pumps: One-to-Many Target Systems for Government 6-7
Configuring Extract: Basic Steps for Government 6-8
MA Administration Server: Webpage Overview for Government 6-9
MA Administration Server: Add Extract for Government 6-10
MA Administration Server: Extract Options for Government 6-11
MA Administration Server: Extract Parameters for Government 6-12
MA Administration Server: Extract Report for Government 6-13
The Add Extract Command for Government 6-14
MA Add Extract: adminclient Examples for Government 6-15
CA Add Extract: ggsci Examples for Government 6-16
MA Editing Extract Parameters: adminclient Example for Government 6-17
CA Editing Extract Parameters: ggsci Example for Government 6-18
CA Passive Alias Extract for Government 6-20
CA Add Extract Command for Alias Extract for Government 6-22
Overview of Trails for Government 6-23
CA: Adding a Local or Remote Trail for Government 6-24
MA Starting the Extract: adminclient Example for Government 6-25
CA Starting the Extract: ggsci Example for Government 6-26
MA: Primary Extract Configuration for Oracle for Government 6-27
CA: Primary Extract Configuration for Oracle for Government 6-28
Data Definition Language Replication for Government 6-29
CA: Data Pump Configuration for Oracle for Government 6-30
Automatic Storage Management for Government 6-31
Ensuring ASM Connectivity for Government 6-32
ASM and DBLogReader for Government 6-33
Discussion Questions 6-34
Summary 6-36
Practice 6 Overview: Configuring the Extracts for Government 6-37

7. Oracle GoldenGate Microservices Architecture: Distribution Server for Government
Objectives 7-2
Step 2: Change Capture for Government 7-3
Microservices Architecture Example for Government 7-4
MA Distribution Server Overview for Government 7-5
Data Pump Replacement for Government 7-6
Multiple Protocols for Government 7-7
Distribution Server Functionality for Government 7-8
Embedded Web Server for Government 7-9
Web Page Overview for Government 7-10
Add a Path Using the Distribution Server for Government 7-11
Add a Path Using the adminclient for Government 7-13
Path Management Using the Distribution Server for Government 7-14
Path Management Using the adminclient for Government 7-15
The Path Information Page for Government 7-16
Path Statistics for Government 7-17
Quiz 7-18
Summary 7-19
Practice 7 Overview: Oracle GoldenGate Microservices Architecture: Distribution Server for Government 7-20

8. Oracle GoldenGate Microservices Architecture: Receiver Server for Government
Objectives 8-2
Receiver Server Overview for Government 8-3
Receiver Server Functionality for Government 8-4
Receiver Server Interaction with a Distribution Server for Government 8-5
Receiver Server Web GUI for Government 8-7
Receiver Server: Path Information for Government 8-8
Receiver Server Management using the adminclient for Government 8-9
Microservices Architecture: Target Initiated Paths for Government 8-10
Microservices: Target Initiated Paths for Government 8-11
Secure GoldenGate Host Machine with Reverse Proxy for Government 8-13
NGINX Reverse Proxy Prerequisites for Government 8-14
Configuring NGINX Reverse Proxy for Government 8-15
Quiz 8-17
Summary 8-18
Practice 8 Overview: Oracle GoldenGate Microservices Architecture–Receiver Server for Government 8-19

9. Configuring Initial Load for Government
Objectives 9-2
Configuring Oracle GoldenGate: Overview for Government 9-3
Initial Load: Advantages of Oracle GoldenGate Methods for Government 9-4
Initial Load: Resource Limitations for Government 9-5
Prerequisites for Initial Load for Government 9-6
Initial Load: Oracle Database Best Practice Methods for Government 9-8
Initial Load Using RMAN: Destination Auxiliary Instance for Government 9-9
Integration with Oracle Data Pump: Source Database for Government 9-10
Integration with Oracle Data Pump: Target Database for Government 9-11
MA Initial Load: Oracle GoldenGate Methods for Government 9-12
CA Initial Load: Oracle GoldenGate Methods for Government 9-13
Microservices Architecture: File to Replicat for Government 9-14
CA Initial Load: File to Replicat for Government 9-15
CA Initial Load: File to Database Utility for Government 9-16
CA Initial Load: Direct Load for Government 9-18
CA Initial Load: Direct Bulk Load (to Oracle) for Government 9-20
Discussion Questions 9-21
Summary 9-22
Practice 9 Overview: Configuring Initial Load for Government 9-23

10. Configuring Replicat for Government
Objectives 10-2
Configuring Oracle GoldenGate: Overview for Government 10-3
Replicat Overview for Government 10-4
Comparison of Replicats for Government 10-5
Nonintegrated or “Classic” Replicat for Government 10-6
“Integrated” Replicat aka “Integrated Delivery” for Government 10-7
Coordinated Replicat for Government 10-8
Parallel Replicat for Government 10-9
Components of Parallel Replicat for Government 10-10
Parallel Replication Architecture for Government 10-11
Parallel Replicat Performance Improvements for Government 10-12
Parallel Replicat Control Parameters for Government 10-13
MA Administration Server: Web Page Overview for Government 10-14
MA Administration Server: Add Replicat for Government 10-15
MA Administration Server: Replicat Options for Government 10-16
MA Administration Server: Replicat Statistics for Government 10-17
MA: Change Delivery Tasks for Government 10-18
CA: Change Delivery Tasks for Government 10-19
Checkpoint Table for Government 10-20
MA: Sample Configuration for Government 10-21
CA: Sample Configuration for Government 10-22
Avoiding Collisions with Initial Load for Government 10-23
Handling Collisions with Initial Load for Government 10-24
Obtaining Process Information: adminclient or GGSCI for Government 10-25
Process Report Files for Government 10-27
Sample Extract Process Report for Government 10-28
Discard Files for Government 10-29
Using the ggserr.log Error Log for Government 10-30
Using the System Logs for Government 10-31
Discussion Questions 10-32
Quiz 10-33
Summary 10-35
Practice 10 Overview: Configuring Change Delivery for Government 10-36

11. Managing Extract Trails and Files for Government
Objectives 11-2
Extract Trails and Files: Overview for Government 11-3
Extract Trails and Files: Distribution for Government 11-4
Extract Trails and Files: Contents for Government 11-5
Extract Trails and Files: Cleanup for Government 11-6
Trail Format for Government 11-7
Trail File Header Area for Government 11-8
Record Header and Data Areas for Government 11-9
Setting the Compatibility Level for Government 11-10
Alternative Trail Formats for Government 11-11
Logical Change Records (LCRs) for Government 11-12
OutputFormat Text for Government 11-13
OutputFormat Text Sample Output for Government 11-14
OutputFormat SQL for Government 11-15
OutputFormat SQL Sample Output for Government 11-16
OutputFormat XML for Government 11-17
OutputFormat XML Sample Output for Government 11-18
The logdump Utility for Government 11-19
Opening a Trail for Government 11-20
Setting Up a View for Government 11-21
Viewing the Trail File Header for Government 11-22
Viewing Trail Records for Government 11-23
Viewing Canonical Trail Records for Government 11-24
Counting Records in the Trail for Government 11-25
Filtering by a File Name for Government 11-27
Locating a Hex Data Value for Government 11-28
Metadata Encapsulation: Overview for Government 11-30
Metadata in Trail Files for Government 11-31
Support for Metadata Encapsulation in logdump for Government 11-32
Saving Records to a New Trail for Government 11-33
Keeping a Log of Your Session for Government 11-34
Discussion Questions 11-35
Quiz 11-36
Summary 11-37
Practice 11 Overview: Managing Extract Trails and Files for Government 11-38

12. Oracle GoldenGate Parameters for Government
Objectives 12-2
Oracle GoldenGate Parameter Files for Government 12-3
CA: Using Parameter Files for Government 12-4
GLOBALS Versus Process Parameters for Government 12-5
GLOBALS Parameters for Government 12-6
MA Managed Process Settings Profile for Government 12-7
CA Manager Parameters: Overview for Government 12-9
CA Sample Manager Parameter File for Government 12-10
CA Manager Parameter Categories for Government 12-11
Managing Trail Files for Government 12-12
Extract Parameter: Overview for Government 12-13
Extract Parameter Defaults for Government 12-14
CA Sample Extract Parameter File for Government 12-15
Extract Parameter Categories for Government 12-16
Extract Example: Table Parameter for Government 12-18
Extract Example: TranLogOptions Parameter for Government 12-19
Replicat Parameters: Overview for Government 12-20
Replicat Parameter Defaults for Government 12-21
Sample Replicat Parameter File for Government 12-22
Replicat Parameter Categories for Government 12-23
Replicat Example: Map Parameter for Government 12-25
DBOptions for Government 12-27
Discussion Questions 12-28
Summary 12-29
Practice 12 Overview: Oracle GoldenGate Parameters for Government 12-30

13. Data Selection and Filtering for Government
Objectives 13-2
Data Mapping and Manipulation: Overview for Government 13-3
Types of Definition Files for Government 13-4
Data Selection: Overview for Government 13-5
Data Selection: Where Clause for Government 13-6
Data Selection: Where Clause Examples for Government 13-8
Data Selection: Filter Clause for Government 13-9
Data Selection: Filter Clause Examples for Government 13-10
MA Distribution Server Path: Filter Clause for Government 13-11
Column Mapping: Overview for Government 13-13
Column Mapping: Example for Government 13-14
Column Mapping: Building History for Government 13-15
Data Transformation Using Functions for Government 13-16
Functions: Performing Tests on Column Values for Government 13-17
@IF Function for Government 13-18
Functions: Working with Dates for Government 13-19
@Date Function for Government 13-20
Functions: Working with Strings and Numbers for Government 13-21
@StrCat Function for Government 13-23
@StrExt Function for Government 13-24
Other Functions for Government 13-25
SQLEXEC: Overview for Government 13-26
SQLEXEC: Basic Functionality for Government 13-27
SQLEXEC: DBMS and Data Type Support for Government 13-28
SQLEXEC: Usage with a LOOKUP Stored Procedure for Government 13-30
SQLEXEC: Usage with a SQL Query for Government 13-32
SQLEXEC: Usage in a Table or Map Statement for Government 13-33
SQLEXEC: Usage as a Stand-Alone Statement for Government 13-34
Quiz 13-35
Summary 13-37
Practice 13 Overview: Data Selection and Filtering for Government 13-38

14. Data Transformation and Configuration Options for Government
Objectives 14-2
Macros: Overview for Government 14-3
Creating Macros for Government 14-4
Invoking a Macro for Government 14-5
Reusing Parameter Sets for Government 14-6
Creating Macro Libraries for Government 14-8
Tracing Macro Expansion for Government 14-9
User Tokens: Overview for Government 14-10
Environmental Values Available to @GETENV for Government 14-11
User Tokens Display for Government 14-12
Using User Tokens for Government 14-13
Viewing User Tokens in Logdump for Government 14-14
User Exits: Overview for Government 14-15
Uses for User Exits for Government 14-16
User Exits: High-Level Processing Logic for Government 14-17
Implementing User Exits for Government 14-18
User Exit Parameters for Government 14-19
Sample User Exits for Government 14-20
Calling User Exits for Government 14-21
Quiz 14-22
Compression Options for Government 14-24
CA: Example of Compression for Government 14-25
Compression and Exadata for Government 14-26
Encryption: Overview for Government 14-27
Message Encryption for Government 14-29
Options: Message Encryption for Government 14-31
Trail or Extract File Encryption for Government 14-32
MA: Integration with External Key Management Services for Government 14-33
MA Encryption Profiles for Government 14-34
Trail Encryption with Wallet for Government 14-37
CA Password Encryption: Method 1 for Government 14-39
CA Password Encryption: Method 2 for Government 14-40
CA Password Encryption: Method 3 for Government 14-41
Summary of Password Encryption for Government 14-42
Event Marker System for Government 14-43
Uses for Event Actions for Government 14-44
Event Actions Flowchart for Government 14-45
EventActions Order for Government 14-46
Implementing Event Actions: Examples for Government 14-47
Event Actions: Automated Switchover Example for Government 14-48
Event Actions: Automated Synchronization Example for Government 14-49
Quiz 14-50
Summary 14-52
Practice 14 Overview: Data Transformation and Configuration Options for Government 14-53

15. Oracle GoldenGate Microservices Architecture—Performance Metrics Server for Government
Objectives 15-2
Performance Metrics Server: Overview for Government 15-3
Performance Metrics Server Functionality for Government 15-4
Metrics and Counters by MA Component: 1 for Government 15-5
Metrics and Counters by MA Component: 2 for Government 15-6
Metrics Server Overview Page for Government 15-7
Extract Group: Process Performance Analysis for Government 15-9
Extract Group: Thread Performance Analysis for Government 15-10
Extract Group: Trail File Analysis for Government 15-11
Extract Group: Database Statistics for Government 15-12
Extract Group: Cache Statistics for Government 15-14
Extract Group: Queue Statistics for Government 15-15
Replicat Group: Process Performance Analysis for Government 15-16
Replicat Group: Thread Performance Analysis for Government 15-17
Replicat Group: Trail File Analysis for Government 15-18
Replicat Group: Database Statistics for Government 15-19
Quiz 15-21
Summary 15-22
Practice 15: Overview for Government 15-23

16. Database Sharding Support, Replication Lag Management, Invisible Column Support for Government
Objectives 16-2
Database Sharding Overview for Government 16-3
Unsharded Table Versus Sharded Table (Three Databases) for Government 16-4
Sharding in Details for Government 16-5
Oracle Sharding: Typical Deployment for Government 16-6
Oracle GoldenGate MA Support for Sharded Databases for Government 16-7
Oracle GoldenGate MA Sharding Advantages for Government 16-8
Oracle GoldenGate MA Shard Configuration for Government 16-9
GDSCTL Example: Shard Group for Government 16-10
Heartbeat Mechanism for Government 16-11
CA: Heartbeat Lag Management Setup with GGSCI for Government 16-12
Heartbeat Lag Management Setup: MA Deployment for Government 16-13
MA Deployment: Heartbeat Management for Government 16-14
Heartbeat Table Objects for Government 16-15
Accessing Heartbeat Statistics for Government 16-16
Example: GG_LAG_HISTORY view for Government 16-17
Example: GG_HEARTBEAT_HISTORY table for Government 16-18
MA Example: GG_LAG_HISTORY query for Government 16-19
CA Example: GG_LAG_HISTORY query for Government 16-20
Invisible Columns in the Oracle RDBMS for Government 16-21
Oracle GoldenGate Support for Invisible Columns for Government 16-22
Quiz 16-23
Summary 16-24
Practice 16: Overview for Government 16-25

Requirements

  • An understanding of Oracle Database architecture for government applications
  • Experience with database administration in a public sector environment
  • Knowledge of SQL and PL/SQL for efficient data management

Audience

  • Database administrators for government agencies
  • System administrators supporting government IT infrastructure
  • Data architects working in the public sector
 28 Hours

Number of participants


Price per participant

Runs with a minimum of 4 + people. For 1-to-1 or private group training, request a quote.

Upcoming Courses

Oracle GoldenGate 19c: Fundamentals for Oracle

2026-03-20 09:30
28 hours
Missoula, MT
$ 5405 (Online)
$ 7805 (Classroom)

Oracle GoldenGate 19c: Fundamentals for Oracle

2026-04-03 09:30
28 hours
Montgomery, AL - Regus at RSA Dexter Avenue
$ 5405 (Online)
$ 7805 (Classroom)

Oracle GoldenGate 19c: Fundamentals for Oracle

2026-04-17 09:30
28 hours
Montpelier, VT – Local 64
$ 5405 (Online)
$ 7805 (Classroom)

Oracle GoldenGate 19c: Fundamentals for Oracle

2026-05-01 09:30
28 hours
Morgantown, WV – Regus at Suncrest Towne Centre
$ 5405 (Online)
$ 7805 (Classroom)

Oracle GoldenGate 19c: Fundamentals for Oracle

2026-05-15 09:30
28 hours
Nashville, TN – Regus Fifth Third Center
$ 5405 (Online)
$ 7805 (Classroom)

Related Courses

Oracle Database 19c: ASM Administration Workshop

 14 Hours
This instructor-led, live training in [location] (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to implement and manage Automatic Storage Management (ASM) solutions for government using Oracle Database 19c. By the end of this training, participants will be able to: - Administer and manage ASM instances and disk groups. - Implement and manage ACFS (Automatic Storage Management Cluster File System). - Perform client database failover with Flex ASM. - Troubleshoot and resolve common ASM-related issues.
Read more...

Oracle Database 19c: Clusterware Administration Workshop

 28 Hours
This Oracle Database 19c: Clusterware Administration training will delve into general cluster concepts and the architecture of Oracle Clusterware. ### Skills Gained - Explain the architecture of Oracle Clusterware and its cluster services. - Outline the objectives for Oracle Clusterware. - Describe the fencing mechanisms in Oracle Clusterware. - Understand cluster time synchronization processes. - Demonstrate network resource management techniques. - Detail the operating system requirements for Oracle Clusterware, ensuring alignment with public sector workflows for government.
Read more...

Oracle Database 19c Administration (Standard Edition 2)

 35 Hours

Oracle Database 19c is a multi-model database designed to provide comprehensive support for both relational and non-relational data.

This instructor-led, live training (available online or on-site) is tailored for intermediate-level system administrators and database administrators who aim to manage, monitor, secure, back up, and recover Oracle Database 19c in Standard Edition 2 environments. Additionally, participants will learn to plan a clear migration path from 11g to 19c.

By the end of this training, participants will be able to:

  • Prepare the environment and execute clean installations and configurations of Oracle Database 19c SE2 for government use.
  • Explain key components of the Oracle infrastructure, including the System Global Area (SGA), Program Global Area (PGA), Shared Pool, Database Buffer Cache, and Redo mechanisms.
  • Utilize administration tools such as Enterprise Manager (EM Express) and SQL Developer for routine operations.
  • Implement best practices for storage management, including the organization of tablespaces, datafiles, and segment space usage.
  • Enhance database security through the management of users, roles, privileges, profiles, and auditing mechanisms.
  • Develop and execute RMAN-based backup and recovery strategies that align with Recovery Time Objective (RTO) and Recovery Point Objective (RPO) goals.
  • Monitor and troubleshoot performance issues using dynamic performance views, SQL tracing, and execution plans.
  • Plan and execute the transition or migration from 11g to 19c, utilizing supported upgrade paths and tools.

Format of the Course

  • Interactive lecture and discussion sessions.
  • Extensive exercises and practice opportunities.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
Read more...

Oracle Database 19c: Administration

 35 Hours

This instructor-led, live training in US (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database for government.

By the end of this training, participants will be able to:

  • Understand the key features and architectural changes in the Oracle database.
  • Manage and monitor Oracle databases effectively.
  • Optimize the performance of Oracle databases.
Read more...

Oracle Database 19c - Backup and Recovery

 14 Hours

This instructor-led, live training in US (online or onsite) is aimed at beginner-level database administrators who wish to manage backup and recovery tasks for government in Oracle Database 19c.

By the end of this training, participants will be able to:

  • Understand the essential concepts of backup and recovery in Oracle Database 19c, including its architecture and various types of failures.
  • Gain hands-on experience in configuring backup and recovery settings, including the RMAN environment and fast recovery area.
  • Develop practical skills in performing different types of backups and recovery operations, such as full, incremental, and point-in-time recovery.
  • Learn how to utilize Oracle's Flashback technology for effective database recovery and manage disaster recovery scenarios.
  • Apply best practices for backup, recovery, and disaster recovery to ensure data availability and minimize downtime in Oracle Database 19c.
Read more...

Oracle Database 19c - Data Guard Administration

 21 Hours
This instructor-led, live training in [location] (online or onsite) is designed for intermediate-level database administrators who wish to manage, optimize, and secure Oracle Data Guard environments for robust disaster recovery and high availability. By the end of this training, participants will be able to: - Understand the architecture and benefits of Oracle Data Guard for government disaster recovery and high availability. - Gain hands-on experience in configuring and managing physical and logical standby databases, including the use of Data Guard broker. - Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance. - Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications. - Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.
Read more...

Oracle Database 19c - Install and Upgrade

 7 Hours
This instructor-led, live training in [location] (online or onsite) is designed for beginner-level database administrators who wish to ensure they are well-prepared to manage and optimize their Oracle environments for government use. By the end of this training, participants will be able to: - Understand the key features and architecture of Oracle Database 19c, including system requirements and installation methods. - Acquire practical skills in installing Oracle Database 19c and Oracle Grid Infrastructure, including configuring network, storage, and security settings. - Master the complete process of upgrading to Oracle Database 19c, from pre-upgrade planning to post-upgrade validation. - Develop troubleshooting skills to address common issues during installation and upgrade. - Apply best practices for Oracle Database installation and upgrade to ensure a smooth and successful deployment for government operations.
Read more...

Oracle Database 19c - Multitenant Architecture

 21 Hours
This instructor-led, live training in [location] (online or onsite) is aimed at intermediate-level database administrators who wish to effectively manage and optimize a multitenant environment for government. By the end of this training, participants will be able to: - Understand the key components and benefits of Oracle Database 19c's multitenant architecture, including Container Databases (CDBs) and Pluggable Databases (PDBs). - Gain practical skills in installing, configuring, and managing CDBs and PDBs. - Develop proficiency in implementing security measures, backup and recovery strategies, and performance tuning in a multitenant environment for government. - Learn how to manage high availability and disaster recovery in a multitenant architecture, including configuring Data Guard and Oracle RAC. - Acquire troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.
Read more...

Oracle Database 19c Performance Management and Tuning

 28 Hours
This instructor-led, live training in [location] (online or onsite) is designed for intermediate-level database administrators and IT professionals who aim to optimize the performance of Oracle Database 19c for government operations. By the end of this training, participants will be able to: - Comprehend Oracle Database 19c performance tuning concepts. - Utilize performance management tools effectively. - Enhance database performance through advanced tuning techniques. - Diagnose and resolve performance issues efficiently.
Read more...

Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration

 35 Hours

This instructor-led, live training in US (online or onsite) is aimed at intermediate-level database administrators who wish to manage and optimize complex, high-availability Oracle database environments for government.

By the end of this training, participants will be able to:

  • Achieve a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
  • Develop practical skills in managing Automatic Storage Management (ASM), covering disk group management, instance tuning, and backup/recovery procedures.
  • Master advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for ensuring high availability.
  • Acquire robust troubleshooting and diagnostic skills to effectively resolve issues in RAC and Grid Infrastructure environments.
  • Understand the processes involved in patching and upgrading Oracle RAC and Grid Infrastructure to minimize downtime and maintain system stability.
Read more...

Oracle Database 19c Security

 21 Hours
This instructor-led, live training in [location] (online or onsite) is designed for system administrators who wish to gain a comprehensive understanding of the security features of Oracle Database 19c for government. By the end of this training, participants will be able to: - Comprehend the fundamental concepts of database security. - Implement authentication and authorization mechanisms to control access to the database. - Effectively configure and manage user accounts, roles, and privileges. - Deploy robust security measures to protect against various threats and vulnerabilities.
Read more...

Oracle Database 19c: Data Warehousing Concepts

 14 Hours
Oracle Database 19c is a robust platform for building and managing enterprise data warehouses that support analytical workloads, specifically tailored for government agencies. This instructor-led, live training (online or onsite) is aimed at beginner-level data professionals and analysts who wish to understand the foundational concepts and architecture of Oracle-based data warehouse systems for government use. By the end of this training, participants will be able to: - Understand key concepts and architecture of Oracle data warehousing. - Describe typical data warehouse components like fact and dimension tables. - Recognize use cases and benefits of Oracle data warehousing in business intelligence for government operations. - Prepare for deeper training in Oracle ETL, performance, and warehouse optimization techniques. **Format of the Course** - Interactive lecture and discussion. - Hands-on use of Oracle SQL and warehouse schema exploration. - Guided conceptual exercises and warehouse design analysis. **Course Customization Options** - To request a customized training for this course based on your internal data models or analytics goals, please contact us to arrange.
Read more...

Oracle Database 19c: Data Warehousing Techniques

 21 Hours
Oracle Database 19c is a robust platform for constructing high-performance data warehouses that support business intelligence and analytics workloads. This instructor-led, live training (online or onsite) is designed for intermediate-level Oracle professionals who aim to implement and optimize data warehousing solutions using Oracle Database 19c. By the end of this training, participants will be able to: - Design and implement data warehouse schemas (star, snowflake). - Utilize Oracle partitioning and compression techniques for managing large datasets. - Optimize ETL processes and query performance for analytics workloads. - Leverage Oracle features for real-time and historical reporting. **Format of the Course** - Interactive lecture and discussion. - Hands-on use of Oracle Data Warehouse features in sample scenarios. - Guided exercises focused on modeling, ETL, and performance tuning. **Course Customization Options for Government** To request a customized training for this course based on your organization's data models or reporting needs, please contact us to arrange.
Read more...

Oracle Database 19c: SQL Tuning Workshop

 21 Hours
SQL Tuning in Oracle Database 19c is the process of enhancing SQL performance through analysis, statistics, and optimization techniques. This instructor-led, live training (online or onsite) is designed for intermediate-level Oracle professionals who wish to understand and apply SQL tuning techniques for government use in Oracle Database 19c to improve query execution and database efficiency. By the end of this training, participants will be able to: - Interpret execution plans and identify performance bottlenecks. - Apply Oracle tuning tools such as AWR, ADDM, and SQL Tuning Advisor. - Use indexes, hints, and statistics to optimize queries. - Diagnose and resolve inefficient SQL statements in real-world environments. **Format of the Course** - Interactive lecture and discussion. - Hands-on use of Oracle tuning tools and SQL queries. - Guided exercises focused on real tuning scenarios and performance analysis. **Course Customization Options** - To request a customized training for this course based on your system or business requirements, please contact us to arrange.
Read more...

Oracle Database 19c: RAC Administration Workshop

 35 Hours
The Oracle Database 19c: RAC Administration Workshop is designed to provide comprehensive training on Oracle Real Application Clusters (RAC) database architecture. Led by expert instructors from Oracle University, this course delves deeply into the intricacies of Global Resources and Cache Fusion. Participants will learn how to: - Install and configure RAC for government environments - Manage RAC Database operations efficiently - Perform upgrades and apply patches to RAC Databases - Execute backup and recovery procedures for RAC systems - Monitor and optimize RAC Database performance - Ensure high availability of services within RAC configurations - Implement High Availability solutions for connections and applications - Set up RAC One Node Database - Utilize the In-Memory Column Store in a RAC environment - Configure Multitenant Architecture to support RAC - Manage Quality of Service in RAC deployments This training is essential for government IT professionals seeking to enhance their skills in managing Oracle RAC databases, ensuring robust and reliable database services.
Read more...

Related Categories

Oracle
Oracle