Oracle GoldenGate 23ai Hands-On: From Zero to Hero

Explore the essential lab software stack, including VirtualBox, Oracle Linux 8.2, Oracle database 23 ai free, Oracle Goldengate 23 ai free, and utilities like zooming, putty, winscp, and sql developer.

Learn to set up VirtualBox labs, build source and target Oracle Linux servers, install Oracle database software and GoldenGate, clone the environment, and enable replication via TCP/IP and WebSocket.

Install Oracle Linux 8.2 on a VirtualBox VM, attach the ISO, allocate 6 GB RAM and 80 GB dynamic storage, and configure host-only and bridged networks for Oracle GoldenGate 23ai prep.

Prepare the platform for Oracle by configuring host details and installing pre installed packages. Create the Oracle user, set limits and kernel parameters, and configure environment variables on Linux.

install the Oracle database software from rpm on Oracle Linux 8.2, configure the listener and pdb, verify Oracle Home and data location, then prepare Oracle GoldenGate installation for replication.

Verify the source database installation by checking dbca and installation logs, fix permission issues, configure the ora tab and environment variables, and confirm three PDBs opened in read-write mode.

Install Oracle GoldenGate 23ai software on the source server by downloading, transferring, unzipping, and running the installer, creating deployment, service manager, and home directories, and verifying success.

Power off the source VM, clone it in VirtualBox as a full clone with name and MACs, then update IP and host name and recreate pdbs from pdb1 to pdb2.

Configure the target server by updating its IPv4 address and hostname, adjust ethernet settings, verify hosts file entries, disable firewalls, and prepare deployment with the ogka ssh script.

Explore Oracle Golden Gate 23ai's microservice architecture, featuring isolated services, rest api gateway, admin client and admin service, and a service manager orchestrating deployments with a mandatory distribution service.

Explore how Oracle GoldenGate 23ai shifts from classic monolithic to microservice architecture, detailing service manager, admin service, distribution, receiver, and security enhancements for scalable, secure data replication.

Explore the architectural components of Oracle GoldenGate 23ai, including service manager, admin service, distribution, receiver, and performance metrics microservices, and how they orchestrate deployments.

Configure Oracle GoldenGate components for parallel replication, including extract and replicate processes, trail files, and checkpointing, and evaluate topology, filters, and performance monitoring.

Measure replication lag and system availability using the heartbeat table, and manage checkpoints, trail files, parameter files, and recovery workflows across Golden Gate deployments.

Explore how REST APIs enable secure, real-time data integration with Oracle GoldenGate microservices, illustrating producers and consumers, stateless requests, and URL-based resources.

Explore traditional monolithic versus microservice architectures, including scalability, fault tolerance, and independent deployment, and see how Oracle GoldenGate enables real-time replication with REST API integration.

Deploy Oracle GoldenGate on the source server with the Ojca script, configure the service manager, deployment directories, listener, and ports, and register the service as a system daemon.

Install and verify Oracle GoldenGate on the target server, configure environment variables via env script or bash profile, and ensure deployment, listener, and required directories are set up.

Deploy Oracle GoldenGate on the server using the OGC script with ports 7806–7810; configure listener and DNS admin, set tgt deployment name, then register service manager as a daemon.

Create GoldenGate credentials on source and target databases, grant OGG capture, OGG apply, and apply proc rep, choose a separate or default table space, enable archive log mode.

Drop the old free pdb one and create free pdb two on the target using a dblink, with proper dns, listener, and a common admin user across source and target.

Configure the org admin user on the target for Oracle GoldenGate 23ai, enabling privileges, unlimited quotas on the users tablespace, and archive log mode with flashback to mirror the source.

Verify the Golden Gate admin client and web interface by connecting to admin services on source and target servers using ports 7802 and 7807.

In a multitenant database, create a local user on each PDB; a common CDB root user is not inherited by PDBs. Grant privileges and verify source–target connections.

Configure and validate the local listener on source and target PDBs, update the target IP, recreate the listener in Net Manager for hosts, and verify services are registered and ready.

Enable supplemental logging on the source, create a credential store, and configure the checkpoint, trend data, and heartbeat tables to enable reliable GoldenGate replication.

Validate DNS and connection strings, configure target credentials and listener, and create a non-admin network user to establish a path connection between source and target.

Configure a path connection between source and target in Oracle GoldenGate 23ai by creating a network user and credential store in the admin service, then validate the distribution path.