Modern Oracle DBA

Microservices Architecture (MA) Adding an Extract in Oracle GoldenGate 21c Microservices Architecture can be done via the Administration Service Console (Web UI) or the Admin Client (Command Line) . Method 1: Administration Service Console (Web UI) 1.      Log in to the Oracle GoldenGate Administration Service URL. 2.      Navigate to the Overview page. 3.      Click the + (plus) button next to Extracts to open the Add Extract wizard. 4.      Select Extract Type     Choose Integrated Extract (most common for Oracle) or Initial Load Extract .     Click Next . 5.      Basic Information     Name : Up to 8 characters     Description : Optional     Intent : Select Unidirectional , High Availability , etc.     Begin Note : Select NOW , Custom Time , or CSN 6.      Trail File ...

The following steps are applicable when setting up a GoldenGate MA archicture  GoldenGate Environment Setup Launch GGSCI ggsci Create required subdirectories (first-time only) GGSCI> CREATE SUBDIRS Create credential store (first-time only) GGSCI> ADD CREDENTIALSTORE Credential Store Add user to credential store (source) GGSCI> ALTER CREDENTIALSTORE ADD USER c##ggadmin@PDB19C PASSWORD <Password> ALIAS ggadmin Add user to credential store (target) GGSCI> ALTER CREDENTIALSTORE ADD USER ggrep@myebspdb PASSWORD <Password> ALIAS ggrep Database Login Login with alias GGSCI> DBLOGIN USERIDALIAS ggadmin Login to PDB with username/password GGSCI> DBLOGIN USERID c##ggadmin@myebsapdb PASSWORD <Password> Enable Supplemental Logging (per schema on source) Add schematrandata for APPLSYS GGSCI> ADD SCHEMATRANDATA "myebspdb".APPLSYS Add schematrandata for CSI GGSCI> ADD ...

1. Manager Process The Manager process is the heart of GoldenGate. It must be running on both source and target systems Extract or Replicat processes cannot start without Manager Performs the following key functions: Starts, stops, and monitors GoldenGate processes Manages trail files Controls ports and resources Generates reports and error logs Always ensure the Manager process is running before starting Extract or Replicat.   2. Extract Process The Extract process runs on the source system and is responsible for capturing data changes. Key Responsibilities Captures transactional changes from the source database Supports: ·       Initial Load (full data load) ·       Change Data Capture (CDC) ·       Can also capture DDL changes (where supported) Data Capture Methods Extract can capture data from: Database transaction logs (Oracle, SQL Server, DB2, MySQL, etc.) Vendor Access M...

Oracle GoldenGate (OGG) is a tool used to copy data in real time from one database to another. It works by reading database transaction logs and sending changes immediately to the target system. GoldenGate is mainly used when businesses need high availability, real-time data, and zero downtime. History of Oracle GoldenGate 1995: GoldenGate software was created 2009: Oracle acquired GoldenGate 21c: Last version that supports Classic Architecture 23c onwards: Only Microservices Architecture is supported Why Do We Use Oracle GoldenGate? Oracle GoldenGate is commonly used for: Backup and Disaster Recovery Auditing and Compliance Real-time Reporting Analytics systems Load distribution (offloading reporting load from production) Database migration with minimum downtime Key Features of Oracle GoldenGate Supports one-way, two-way, and multi-way replication Can replicate data between multiple databases at the same time Allows filtering and transforming data during replica...

Purpose This guide describes a step-by-step approach to perform a switchover in an Oracle Data Guard configuration. Prerequisites Primary and Standby are healthy and synchronized. Both databases are under clusterware control. SYSDBA connectivity is available. Application services are stopped before switchover. Environment Details Primary Database:   PRD_CDB Standby Database:   STBY_CDB Primary Server:   PRD_NODE1 Standby Server:  STBY_NODE1 Switchover Procedure (With Actual Output) STEP 1. Remove DelayMins (if configured) DGMGRL> connect sys/<password> DGMGRL> show database PRD_CDB delaymins; DGMGRL> edit database PRD_CDB set property 'DelayMins'='0'; DGMGRL> show database PRD_CDB delaymins; Sample Output: DelayMins = '180' Property "DelayMins" updated  D...

Artificial Intelligence is entering a new era. What started as productivity assistance has now evolved into digital teammates capable of performing business tasks independently. Microsoft CEO Satya Nadella recently outlined a three-phase roadmap that explains how AI will reshape workplaces in the coming years. This article breaks down these phases and explains how this transformation will impact Oracle DBAs specifically.   Phase 1: Copilot- AI as a Personal Assistant The first evolution in workplace AI began with tools like Microsoft Copilot. Copilot functions as a personal digital assistant inside daily-use applications such as Word, Excel, PowerPoint, Outlook, Teams, and coding tools.   What Copilot Helps With Drafting documents and emails Summarising long reports and meetings Analysing Excel data Creating PowerPoint slides Generating or reviewing code Automating routine writing tasks   Phase 2: Digital Labor - AI Agents as Virtual...

1. What is PCP? PCP stands for  Parallel Concurrent Processing . It allows  Concurrent Managers  in Oracle E-Business Suite to run on multiple nodes instead of just one. Why use PCP? Load Balancing  – Distributes workload across multiple nodes for better performance. High Availability  – If one node fails, managers can failover to another node. Failover and Failback  – Automatically moves managers to available nodes during failure and back when the node is restored.   2. PCP Setup Types RAC Database Setup  – Commonly used with PCP. Non-RAC Setup  – PCP can still work without RAC by using TNS aliases for connectivity. 3. How PCP Works Each node runs Concurrent Managers. Managers connect to the database using TWO_TASK (TNS alias) defined in: adcmctl.sh gsmstart.sh   4. Internal Monitor (IMON) Optional Service  but recommended. Monitors the...