--- title: Replicating PostgreSQL data using Oracle GoldenGate - RheoData description: Something that has been brewing for years – since late 2017 – is the constant... image: https://rheodata.com/hubfs/Imported_Blog_Media/blog-feature-Logo-Oct-31-2025-04-57-26-6962-PM.png --- [![RheoData - Logo - transparent-1](https://rheodata.com/hs-fs/hubfs/RheoData%20-%20Logo%20-%20transparent-1.png?width=250&height=50&name=RheoData%20-%20Logo%20-%20transparent-1.png "RheoData - Logo - transparent-1")](https://rheodata.com/) - Who We Are - [About Us](https://rheodata.com/who-we-are) - Services - Consulting - [The Studio](https://rheodata.com/the-studio) - Accelerators - [FrostCore](https://rheodata.com/frostcore) - [FrostAI](https://rheodata.com/frostai) - [RedCore](https://rheodata.com/redcore) - [RedAI](https://rheodata.com/redai) - [RedGuard](https://rheodata.com/redguard) - [BlueCore](https://rheodata.com/bluecore) - [Calypso](https://rheodata.com/calypso) - Services - [Data Integration](https://rheodata.com/data-integration) - [Analytics](https://rheodata.com/data-analytics) - [Multi-Cloud](https://rheodata.com/multi-cloud) - [Oracle@Google Cloud](https://rheodata.com/oracle-google-cloud) - [Exadata & Oracle Database](https://rheodata.com/exadata-and-oracle-database-26ai) - Verticals - [Manufacturing](https://rheodata.com/manufacturing) - [Retail](https://rheodata.com/retail) - [State & Local](https://rheodata.com/sled) - [Customer Stories](https://rheodata.com/customer-stories) - [Altec](https://rheodata.com/customer-stories/altec-oci-goldengate-data-migration) - [Shoe Carnival](https://rheodata.com/customer-stories/shoe-carnival-goldengate-microservices-migration) - [Icon](https://rheodata.com/customer-stories/icon-transatlantic-replication) - [Inovalon](https://rheodata.com/customer-stories/inovalon-data-pipeline-automation) - Resources - [Blog](https://rheodata.com/en-us/blog) - Books - [Pro Oracle GoldenGate 23ai](https://rheodata.com/pro-oracle-goldengate-23ai-for-the-dba-pdf-landing-page) - [Contact](https://rheodata.com/contact) [![](https://rheodata.com/hs-fs/hubfs/Imported_Blog_Media/blog-feature-Logo-Nov-26-2025-07-14-39-7226-PM.png?width=100&height=100&name=blog-feature-Logo-Nov-26-2025-07-14-39-7226-PM.png)](https://rheodata.com/) [![RheoData - Logo - transparent-1](https://rheodata.com/hs-fs/hubfs/RheoData%20-%20Logo%20-%20transparent-1.png?width=250&height=50&name=RheoData%20-%20Logo%20-%20transparent-1.png "RheoData - Logo - transparent-1")](https://rheodata.com/) - Who We Are - [About Us](https://rheodata.com/who-we-are) - Services - Consulting - [The Studio](https://rheodata.com/the-studio) - Accelerators - [FrostCore](https://rheodata.com/frostcore) - [FrostAI](https://rheodata.com/frostai) - [RedCore](https://rheodata.com/redcore) - [RedAI](https://rheodata.com/redai) - [RedGuard](https://rheodata.com/redguard) - [BlueCore](https://rheodata.com/bluecore) - [Calypso](https://rheodata.com/calypso) - Services - [Data Integration](https://rheodata.com/data-integration) - [Analytics](https://rheodata.com/data-analytics) - [Multi-Cloud](https://rheodata.com/multi-cloud) - [Oracle@Google Cloud](https://rheodata.com/oracle-google-cloud) - [Exadata & Oracle Database](https://rheodata.com/exadata-and-oracle-database-26ai) - Verticals - [Manufacturing](https://rheodata.com/manufacturing) - [Retail](https://rheodata.com/retail) - [State & Local](https://rheodata.com/sled) - [Customer Stories](https://rheodata.com/customer-stories) - [Altec](https://rheodata.com/customer-stories/altec-oci-goldengate-data-migration) - [Shoe Carnival](https://rheodata.com/customer-stories/shoe-carnival-goldengate-microservices-migration) - [Icon](https://rheodata.com/customer-stories/icon-transatlantic-replication) - [Inovalon](https://rheodata.com/customer-stories/inovalon-data-pipeline-automation) - Resources - [Blog](https://rheodata.com/en-us/blog) - Books - [Pro Oracle GoldenGate 23ai](https://rheodata.com/pro-oracle-goldengate-23ai-for-the-dba-pdf-landing-page) - [Contact](https://rheodata.com/contact) [![](https://rheodata.com/hs-fs/hubfs/Imported_Blog_Media/blog-feature-Logo-Nov-26-2025-07-14-39-7226-PM.png?width=100&height=100&name=blog-feature-Logo-Nov-26-2025-07-14-39-7226-PM.png)](https://rheodata.com/) - Who We Are - [About Us](https://rheodata.com/who-we-are) - Services - Consulting - [The Studio](https://rheodata.com/the-studio) - Accelerators - [FrostCore](https://rheodata.com/frostcore) - [FrostAI](https://rheodata.com/frostai) - [RedCore](https://rheodata.com/redcore) - [RedAI](https://rheodata.com/redai) - [RedGuard](https://rheodata.com/redguard) - [BlueCore](https://rheodata.com/bluecore) - [Calypso](https://rheodata.com/calypso) - Services - [Data Integration](https://rheodata.com/data-integration) - [Analytics](https://rheodata.com/data-analytics) - [Multi-Cloud](https://rheodata.com/multi-cloud) - [Oracle@Google Cloud](https://rheodata.com/oracle-google-cloud) - [Exadata & Oracle Database](https://rheodata.com/exadata-and-oracle-database-26ai) - Verticals - [Manufacturing](https://rheodata.com/manufacturing) - [Retail](https://rheodata.com/retail) - [State & Local](https://rheodata.com/sled) - [Customer Stories](https://rheodata.com/customer-stories) - [Altec](https://rheodata.com/customer-stories/altec-oci-goldengate-data-migration) - [Shoe Carnival](https://rheodata.com/customer-stories/shoe-carnival-goldengate-microservices-migration) - [Icon](https://rheodata.com/customer-stories/icon-transatlantic-replication) - [Inovalon](https://rheodata.com/customer-stories/inovalon-data-pipeline-automation) - Resources - [Blog](https://rheodata.com/en-us/blog) - Books - [Pro Oracle GoldenGate 23ai](https://rheodata.com/pro-oracle-goldengate-23ai-for-the-dba-pdf-landing-page) - [Contact](https://rheodata.com/contact) # Replicating PostgreSQL data using Oracle GoldenGate Posted by [Bobby Curtis](https://rheodata.com/en-us/blog/author/bobby-curtis) Nov 10, 2025 9:30:46 PM 5 minutes to read ![Post Featured Image](https://rheodata.com/hubfs/Imported_Blog_Media/blog-feature-Logo-Oct-31-2025-04-57-26-6962-PM.png) ## Replicating PostgreSQL data using Oracle GoldenGate Something that has been brewing for years – since late 2017 – is the constant request from Oracle customers on how to capture data from PostgreSQL databases.  Many of Oracle’s customers are either moving towards PostgreSQL and off of Oracle or looking for another way to pull data from PostgreSQL into their Oracle Data Warehouses.  In either case, Oracle has finally gotten around to releasing a fully supported version of Oracle GoldenGate for PostgreSQL, meaning that customers can now capture (extract) and apply (replicat) data from PostgreSQL 10 and later. The downside to this is that Oracle released it in “Classic” architecture instead of the “Microservices” architecture.  Meaning customers still do not have access to remote administration capabilities and will have to rely on server access.  A positive though is that this version of Oracle GoldenGate can be used in a hub-n-spoke architecture and for bi-directional replication.  I will not be covering those topics though. Let’s get started … ### Prerequisites: As with anything there is always a set of prerequisites that are needed before you can proceed with an installation.  In this cases, it holds true – the Oracle docs don’t even cover a good bit of these, but with a little help I was able to resolve what was needed.   #### Linux Packages: PostgreSQL#-contrib – this package is needed to allow you to register the extract with the PostgreSQL database #### PostgreSQL.conf file changes: These items were interesting and documented in Oracle docs, but remember, after changes the PostgreSQL database must be restarted. ``` wal_level = logicial max_replication_slots = 10 (default) max_wal_sender = 10 (default) wal_receiver_status_interval (optional) wal_sender_timeout (optional) track_commit_timestamp = false (optional) ``` As you can tell Oracle is leveraging the Write Ahead Logging (WAL) parameters to ensure everything is read from the database and transaction logs correctly. #### Users: Just like typical Oracle GoldenGate setup, you must define a user that will be used for Oracle GoldenGate.  In my setups, I typically name the user “ggate” but this user can be named anything. The key here is to ensure the right privileges are assigned.  To setup an Oracle GoldenGate user, the following can be ran against a PostgreSQL database: ``` create user ggate with password 'ggate' login; ``` ``` alter user ggate with replication; ``` #### Environment Variables: There are a slew of environment variables that will need to be set to ensure that replication works.  What is listed below is what I had to setup to ensure it all worked.  Mileage will vary. ``` export PG_HOME=/usr/pgsql-12 export OGG_HOME=/opt/app/oracle/19.1.0/oggcore_1 export ODBCINI=/home/oracle/odbc.ini export LD_LIBRARY_PATH=$PG_HOME/lib:$OGG_HOME/lib:$LD_LIBRARY_PATH export PATH=$ODBCINI:$PATH ``` A couple of things to note here.  The $PG\_HOME must be in the $LD\_LIBRARY\_PATH.  The $ODBCINI file location must be in the $PATH.  These items can be easily setup in the .bashrc or .bash\_profile for your environment. #### ODBC.ini file: Oracle GoldenGate uses the ODBC.ini file to connect to the PostgreSQL database.  This file has to be configured and located by using the $ODBCINI environment variable.  For simplicity of this blog, a little, I’m not going to post what it should look like.  You can fine details within the Oracle docs -> [here](https://docs.oracle.com/en/middleware/goldengate/core/19.1/gghdb/configuring-odbc-connection-postgresql.html). ### Setting up replication: With all the prerequisites established, replication can be setup the exact same as any other Oracle GoldenGate “Classic” environment.  The steps are similar to these below. #### Extract: 1. Install Oracle GoldenGate software – unzip/untar in the $OGG\_HOME of choice.  Then open GGSCI and run CREATE SUBDIRS (./GGSCI) + (CREATE SUBDIRS) 2. Edit the MGR parameter file (EDIT PARAMS MGR), assign port number (default 7809), and start manager (START MGR) 3. Login to the PostgreSQL databases as your GoldenGate user (DBLOGIN SOURCEDB USERID PASSWORD ) 4. Register extract with PostgreSQL database (REGISTER EXTRACT ) 5. Add extract (ADD EXTRACT , TRANLOG, BEGIN NOW) 6. Add trail file (ADD EXTTRAIL ./dirdat/aa, EXTRACT ) 7. Edit parameter file for extract (EDIT PARAMS ) 8. Add Trandata (ADD TRANDATA .) 9. Start MGR and EXTRACT (START MGR) + (START EXTRACT ) 10. Validate that MGR and EXTRACT have been started (INFO ALL) #### Replicat: 1. Create the GoldenGate schema inside of the PostgreSQL database (CREATE SCHEMA ) 2. Login to the PostgreSQL database (DBLOGIN SOURCEDB USERID PASSWORD ) 3. Add Checkpoint Table (ADD CHECKPOINTTABLE .) 4. Add Replicat (ADD REPLICAT , EXTTRAIL ./dirdat/aa, CHECKPOINTTABLE .) 5. Start Replicat (START REPLICAT ) 6. Check status of Replicat (INFO ALL) ### What you didn’t see/Summary: In the examples above, what was missing is the Data Pump Extract.  Since I was configuring the movement of data on a single server with a single PostgreSQL database to two (2) different schemas, the Data Pump Extract was not needed.  If you plan on moving data between sites, the Data Pump Extract is needed to route the trail files correctly.  Another option is to configure Oracle GoldenGate in the hub-n-spoke architecture and the same approach as above can be followed and simply use the remote-capture/remote-apply functionality. In closing, Oracle has finally answered the call from customers by allowing them to capture and apply within a PostgreSQL environment.  This brings the replication standard of reliable replication to a development platform as well as enabling organizations to maximize their data movement strategies. Enjoy!! - - - - - [mailto:?subject='https://rheodata.com/en-us/blog/replicating-postgresql-data-using-oracle-goldengate'](mailto:?subject='https://rheodata.com/en-us/blog/replicating-postgresql-data-using-oracle-goldengate') [Cloud](https://rheodata.com/en-us/blog/tag/cloud), [move off of oracle](https://rheodata.com/en-us/blog/tag/move-off-of-oracle), [GoldenGate](https://rheodata.com/en-us/blog/tag/goldengate), [19c](https://rheodata.com/en-us/blog/tag/19c) ### [Bobby Curtis](https://rheodata.com/en-us/blog/author/bobby-curtis) ### Recent posts ### Posts by Tag - [Cloud (88)](https://rheodata.com/en-us/blog/tag/cloud) - [GoldenGate (73)](https://rheodata.com/en-us/blog/tag/goldengate) - [Business Insights (51)](https://rheodata.com/en-us/blog/tag/business-insights) - [AI (36)](https://rheodata.com/en-us/blog/tag/ai) - [19c (22)](https://rheodata.com/en-us/blog/tag/19c) - [ai pipelines (17)](https://rheodata.com/en-us/blog/tag/ai-pipelines) - [18c (15)](https://rheodata.com/en-us/blog/tag/18c) - [21c (14)](https://rheodata.com/en-us/blog/tag/21c) - [12c (11)](https://rheodata.com/en-us/blog/tag/12c) - [machine learning (10)](https://rheodata.com/en-us/blog/tag/machine-learning) - [23ai (9)](https://rheodata.com/en-us/blog/tag/23ai) - [database (9)](https://rheodata.com/en-us/blog/tag/database) - [goldengate 21c (9)](https://rheodata.com/en-us/blog/tag/goldengate-21c) - [artificial intelligence (8)](https://rheodata.com/en-us/blog/tag/artificial-intelligence) - [data analytics (8)](https://rheodata.com/en-us/blog/tag/data-analytics) - [Google (7)](https://rheodata.com/en-us/blog/tag/google) - [23ai AI vector search (6)](https://rheodata.com/en-us/blog/tag/23ai-ai-vector-search) - [aws ec2 (6)](https://rheodata.com/en-us/blog/tag/aws-ec2) - [aws ec2 compute (6)](https://rheodata.com/en-us/blog/tag/aws-ec2-compute) - [ec2 (6)](https://rheodata.com/en-us/blog/tag/ec2) - [ggs (6)](https://rheodata.com/en-us/blog/tag/ggs) - [goldengate 19c (6)](https://rheodata.com/en-us/blog/tag/goldengate-19c) - [install nginx (6)](https://rheodata.com/en-us/blog/tag/install-nginx) - [23.4 (5)](https://rheodata.com/en-us/blog/tag/23-4) - [AI Vector Search (5)](https://rheodata.com/en-us/blog/tag/ai-vector-search) - [analytics (5)](https://rheodata.com/en-us/blog/tag/analytics) - [classic to microservices (5)](https://rheodata.com/en-us/blog/tag/classic-to-microservices) - [cloud-migration (5)](https://rheodata.com/en-us/blog/tag/cloud-migration) - [data mesh (5)](https://rheodata.com/en-us/blog/tag/data-mesh) - [database migration (5)](https://rheodata.com/en-us/blog/tag/database-migration) - [goldengate microservices (5)](https://rheodata.com/en-us/blog/tag/goldengate-microservices) - [11g (4)](https://rheodata.com/en-us/blog/tag/11g) - [19c goldengate (4)](https://rheodata.com/en-us/blog/tag/19c-goldengate) - [Azure (4)](https://rheodata.com/en-us/blog/tag/azure) - [Database Modernization (4)](https://rheodata.com/en-us/blog/tag/database-modernization) - [Google Cloud (4)](https://rheodata.com/en-us/blog/tag/google-cloud) - [Oracle GoldenGate (4)](https://rheodata.com/en-us/blog/tag/oracle-goldengate) - [autonomous database (4)](https://rheodata.com/en-us/blog/tag/autonomous-database) - [cloud management (4)](https://rheodata.com/en-us/blog/tag/cloud-management) - [cloud services (4)](https://rheodata.com/en-us/blog/tag/cloud-services) - [data engineering (4)](https://rheodata.com/en-us/blog/tag/data-engineering) - [data engineers (4)](https://rheodata.com/en-us/blog/tag/data-engineers) - [data governance (4)](https://rheodata.com/en-us/blog/tag/data-governance) - [heatwave (4)](https://rheodata.com/en-us/blog/tag/heatwave) - [12.2.1.x (3)](https://rheodata.com/en-us/blog/tag/12-2-1-x) - [12.3.x (3)](https://rheodata.com/en-us/blog/tag/12-3-x) - [12c goldengate (3)](https://rheodata.com/en-us/blog/tag/12c-goldengate) - [18c goldengate (3)](https://rheodata.com/en-us/blog/tag/18c-goldengate) - [23c (3)](https://rheodata.com/en-us/blog/tag/23c) - [AI Integration (3)](https://rheodata.com/en-us/blog/tag/ai-integration) - [Database Administration (3)](https://rheodata.com/en-us/blog/tag/database-administration) - [GoldenGate 23c (3)](https://rheodata.com/en-us/blog/tag/goldengate-23c) - [MySQL (3)](https://rheodata.com/en-us/blog/tag/mysql) - [Oracle Cloud Migration (3)](https://rheodata.com/en-us/blog/tag/oracle-cloud-migration) - [Oracle Database 26ai (3)](https://rheodata.com/en-us/blog/tag/oracle-database-26ai) - [adminclient (3)](https://rheodata.com/en-us/blog/tag/adminclient) - [architecture of data pipelines (3)](https://rheodata.com/en-us/blog/tag/architecture-of-data-pipelines) - [automation (3)](https://rheodata.com/en-us/blog/tag/automation) - [batch processing (3)](https://rheodata.com/en-us/blog/tag/batch-processing) - [big data (3)](https://rheodata.com/en-us/blog/tag/big-data) - [data cleaning (3)](https://rheodata.com/en-us/blog/tag/data-cleaning) - [data integration (3)](https://rheodata.com/en-us/blog/tag/data-integration) - [data pipelines (3)](https://rheodata.com/en-us/blog/tag/data-pipelines) - [data pipelines vs ETL pipelines (3)](https://rheodata.com/en-us/blog/tag/data-pipelines-vs-etl-pipelines) - [data science (3)](https://rheodata.com/en-us/blog/tag/data-science) - [data-replication (3)](https://rheodata.com/en-us/blog/tag/data-replication) - [database-platforms (3)](https://rheodata.com/en-us/blog/tag/database-platforms) - [enterprise data replication (3)](https://rheodata.com/en-us/blog/tag/enterprise-data-replication) - [gcp (3)](https://rheodata.com/en-us/blog/tag/gcp) - [hashicorp vault enterprise (3)](https://rheodata.com/en-us/blog/tag/hashicorp-vault-enterprise) - [Agentic AI (2)](https://rheodata.com/en-us/blog/tag/agentic-ai) - [Bring Your Own License (BYOL) Oracle (2)](https://rheodata.com/en-us/blog/tag/bring-your-own-license-byol-oracle) - [Cloud Database (2)](https://rheodata.com/en-us/blog/tag/cloud-database) - [Cloud modernization strategy (2)](https://rheodata.com/en-us/blog/tag/cloud-modernization-strategy) - [Docker (2)](https://rheodata.com/en-us/blog/tag/docker) - [EnterpriseDB (2)](https://rheodata.com/en-us/blog/tag/enterprisedb) - [Flask (2)](https://rheodata.com/en-us/blog/tag/flask) - [Google Cloud for Oracle workloads (2)](https://rheodata.com/en-us/blog/tag/google-cloud-for-oracle-workloads) - [Legacy Oracle systems (2)](https://rheodata.com/en-us/blog/tag/legacy-oracle-systems) - [Oracle AI Vector Search (2)](https://rheodata.com/en-us/blog/tag/oracle-ai-vector-search) - [Oracle Cloud Infrastructure (2)](https://rheodata.com/en-us/blog/tag/oracle-cloud-infrastructure) - [Oracle DBA skills in the cloud (2)](https://rheodata.com/en-us/blog/tag/oracle-dba-skills-in-the-cloud) - [Oracle GoldenGate 23ai (2)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-23ai) - [Oracle migration assessment (2)](https://rheodata.com/en-us/blog/tag/oracle-migration-assessment) - [Oracle on GCP (2)](https://rheodata.com/en-us/blog/tag/oracle-on-gcp) - [Snowflake (2)](https://rheodata.com/en-us/blog/tag/snowflake) - [Snowflake cost optimization (2)](https://rheodata.com/en-us/blog/tag/snowflake-cost-optimization) - [aws (2)](https://rheodata.com/en-us/blog/tag/aws) - [azure ai studio (2)](https://rheodata.com/en-us/blog/tag/azure-ai-studio) - [build mysql heatwave (2)](https://rheodata.com/en-us/blog/tag/build-mysql-heatwave) - [cloud dba (2)](https://rheodata.com/en-us/blog/tag/cloud-dba) - [cloud ready (2)](https://rheodata.com/en-us/blog/tag/cloud-ready) - [cohere generate documentation (2)](https://rheodata.com/en-us/blog/tag/cohere-generate-documentation) - [data-pipeline (2)](https://rheodata.com/en-us/blog/tag/data-pipeline) - [database replication security (2)](https://rheodata.com/en-us/blog/tag/database-replication-security) - [deployment (2)](https://rheodata.com/en-us/blog/tag/deployment) - [docker adminclient (2)](https://rheodata.com/en-us/blog/tag/docker-adminclient) - [golden gate (2)](https://rheodata.com/en-us/blog/tag/golden-gate) - [goldengate cloud (2)](https://rheodata.com/en-us/blog/tag/goldengate-cloud) - [goldengate migrations (2)](https://rheodata.com/en-us/blog/tag/goldengate-migrations) - [goldengate parameter files (2)](https://rheodata.com/en-us/blog/tag/goldengate-parameter-files) - [google postgresql migration (2)](https://rheodata.com/en-us/blog/tag/google-postgresql-migration) - [ml (2)](https://rheodata.com/en-us/blog/tag/ml) - [real-time data replication (2)](https://rheodata.com/en-us/blog/tag/real-time-data-replication) - [0.12upgrade (1)](https://rheodata.com/en-us/blog/tag/0-12upgrade) - [11.2.0.4 (1)](https://rheodata.com/en-us/blog/tag/11-2-0-4) - [11g to 19c (1)](https://rheodata.com/en-us/blog/tag/11g-to-19c) - [11g to 21c (1)](https://rheodata.com/en-us/blog/tag/11g-to-21c) - [11g to 23c (1)](https://rheodata.com/en-us/blog/tag/11g-to-23c) - [11g to OCI (1)](https://rheodata.com/en-us/blog/tag/11g-to-oci) - [19.1.0.0.0 (1)](https://rheodata.com/en-us/blog/tag/19-1-0-0-0) - [19.1.0.0.1 (1)](https://rheodata.com/en-us/blog/tag/19-1-0-0-1) - [2024 (1)](https://rheodata.com/en-us/blog/tag/2024) - [5.7 (1)](https://rheodata.com/en-us/blog/tag/5-7) - [5.7 to 8.0 (1)](https://rheodata.com/en-us/blog/tag/5-7-to-8-0) - [8.0 (1)](https://rheodata.com/en-us/blog/tag/8-0) - [AI Agents (1)](https://rheodata.com/en-us/blog/tag/ai-agents) - [AI Data Platform (1)](https://rheodata.com/en-us/blog/tag/ai-data-platform) - [AI Infrastructure Management (1)](https://rheodata.com/en-us/blog/tag/ai-infrastructure-management) - [AI Machine Learning (1)](https://rheodata.com/en-us/blog/tag/ai-machine-learning) - [AI blog writing (1)](https://rheodata.com/en-us/blog/tag/ai-blog-writing) - [AI business productivity (1)](https://rheodata.com/en-us/blog/tag/ai-business-productivity) - [AI content creation (1)](https://rheodata.com/en-us/blog/tag/ai-content-creation) - [AI data infrastructure (1)](https://rheodata.com/en-us/blog/tag/ai-data-infrastructure) - [AI data management (1)](https://rheodata.com/en-us/blog/tag/ai-data-management) - [AI data platform optimization (1)](https://rheodata.com/en-us/blog/tag/ai-data-platform-optimization) - [AI database administration (1)](https://rheodata.com/en-us/blog/tag/ai-database-administration) - [AI database management tools (1)](https://rheodata.com/en-us/blog/tag/ai-database-management-tools) - [AI ethics content (1)](https://rheodata.com/en-us/blog/tag/ai-ethics-content) - [AI governance (1)](https://rheodata.com/en-us/blog/tag/ai-governance) - [AI inference bottlenecks (1)](https://rheodata.com/en-us/blog/tag/ai-inference-bottlenecks) - [AI model deployment strategies (1)](https://rheodata.com/en-us/blog/tag/ai-model-deployment-strategies) - [AI security (1)](https://rheodata.com/en-us/blog/tag/ai-security) - [AI writing tools (1)](https://rheodata.com/en-us/blog/tag/ai-writing-tools) - [AI-Driven-Revenue-Growth (1)](https://rheodata.com/en-us/blog/tag/ai-driven-revenue-growth) - [AI-Native Applications (1)](https://rheodata.com/en-us/blog/tag/ai-native-applications) - [AI-ROI (1)](https://rheodata.com/en-us/blog/tag/ai-roi) - [AI-Ready Data (1)](https://rheodata.com/en-us/blog/tag/ai-ready-data) - [AI-accuracy (1)](https://rheodata.com/en-us/blog/tag/ai-accuracy) - [AI-compliance (1)](https://rheodata.com/en-us/blog/tag/ai-compliance) - [AI-hallucination-prevention (1)](https://rheodata.com/en-us/blog/tag/ai-hallucination-prevention) - [AI-powered database replication management (1)](https://rheodata.com/en-us/blog/tag/ai-powered-database-replication-management) - [API authentication (1)](https://rheodata.com/en-us/blog/tag/api-authentication) - [AWS S3 (1)](https://rheodata.com/en-us/blog/tag/aws-s3) - [Apache Iceberg (1)](https://rheodata.com/en-us/blog/tag/apache-iceberg) - [Apache Spark data platform (1)](https://rheodata.com/en-us/blog/tag/apache-spark-data-platform) - [Atlanta database consultants (1)](https://rheodata.com/en-us/blog/tag/atlanta-database-consultants) - [Azure Data Lake (1)](https://rheodata.com/en-us/blog/tag/azure-data-lake) - [Big Query (1)](https://rheodata.com/en-us/blog/tag/big-query) - [BigQuery Integration (1)](https://rheodata.com/en-us/blog/tag/bigquery-integration) - [Business-Intelligence-Modernization (1)](https://rheodata.com/en-us/blog/tag/business-intelligence-modernization) - [CLOB to VARCHAR (1)](https://rheodata.com/en-us/blog/tag/clob-to-varchar) - [Change Data Capture GoldenGate Extract (1)](https://rheodata.com/en-us/blog/tag/change-data-capture-goldengate-extract) - [Cloud Data Platform (1)](https://rheodata.com/en-us/blog/tag/cloud-data-platform) - [Cloud database migration (1)](https://rheodata.com/en-us/blog/tag/cloud-database-migration) - [Coordinated Replicat (1)](https://rheodata.com/en-us/blog/tag/coordinated-replicat) - [Cortex Agents (1)](https://rheodata.com/en-us/blog/tag/cortex-agents) - [Cosine distance Oracle (1)](https://rheodata.com/en-us/blog/tag/cosine-distance-oracle) - [Cross-platform data monitoring (1)](https://rheodata.com/en-us/blog/tag/cross-platform-data-monitoring) - [Customer-Experience-Optimization (1)](https://rheodata.com/en-us/blog/tag/customer-experience-optimization) - [DBA burnout prevention (1)](https://rheodata.com/en-us/blog/tag/dba-burnout-prevention) - [DBA productivity (1)](https://rheodata.com/en-us/blog/tag/dba-productivity) - [DBA skills AI (1)](https://rheodata.com/en-us/blog/tag/dba-skills-ai) - [Data Modernization (1)](https://rheodata.com/en-us/blog/tag/data-modernization) - [Data Pipeline Architecture (1)](https://rheodata.com/en-us/blog/tag/data-pipeline-architecture) - [Data Pipeline Management (1)](https://rheodata.com/en-us/blog/tag/data-pipeline-management) - [Data Streaming (1)](https://rheodata.com/en-us/blog/tag/data-streaming) - [Data Transformation (1)](https://rheodata.com/en-us/blog/tag/data-transformation) - [Data pipeline troubleshooting (1)](https://rheodata.com/en-us/blog/tag/data-pipeline-troubleshooting) - [Database Security (1)](https://rheodata.com/en-us/blog/tag/database-security) - [Database lag monitoring (1)](https://rheodata.com/en-us/blog/tag/database-lag-monitoring) - [Database migration strategy (1)](https://rheodata.com/en-us/blog/tag/database-migration-strategy) - [Database migration vs. replication (1)](https://rheodata.com/en-us/blog/tag/database-migration-vs-replication) - [Database replication blind spots (1)](https://rheodata.com/en-us/blog/tag/database-replication-blind-spots) - [Database replication monitoring (1)](https://rheodata.com/en-us/blog/tag/database-replication-monitoring) - [Database replication performance monitoring (1)](https://rheodata.com/en-us/blog/tag/database-replication-performance-monitoring) - [Databricks comparison (1)](https://rheodata.com/en-us/blog/tag/databricks-comparison) - [Delta Lake integration (1)](https://rheodata.com/en-us/blog/tag/delta-lake-integration) - [Digital-Transformation-ROI (1)](https://rheodata.com/en-us/blog/tag/digital-transformation-roi) - [EXTFILE (1)](https://rheodata.com/en-us/blog/tag/extfile) - [EXTRAIL (1)](https://rheodata.com/en-us/blog/tag/extrail) - [Edge computing AI (1)](https://rheodata.com/en-us/blog/tag/edge-computing-ai) - [Enterprise AI Strategy (1)](https://rheodata.com/en-us/blog/tag/enterprise-ai-strategy) - [Enterprise AI scalability (1)](https://rheodata.com/en-us/blog/tag/enterprise-ai-scalability) - [Enterprise cloud migration (1)](https://rheodata.com/en-us/blog/tag/enterprise-cloud-migration) - [Enterprise data migration (1)](https://rheodata.com/en-us/blog/tag/enterprise-data-migration) - [Enterprise database replication monitoring (1)](https://rheodata.com/en-us/blog/tag/enterprise-database-replication-monitoring) - [Forward Deployed Engineering (1)](https://rheodata.com/en-us/blog/tag/forward-deployed-engineering) - [GPU memory optimization (1)](https://rheodata.com/en-us/blog/tag/gpu-memory-optimization) - [GUI (1)](https://rheodata.com/en-us/blog/tag/gui) - [Gemini Enterprise (1)](https://rheodata.com/en-us/blog/tag/gemini-enterprise) - [GoldenGate 21c upgrade (1)](https://rheodata.com/en-us/blog/tag/goldengate-21c-upgrade) - [GoldenGate 23ai to 26ai (1)](https://rheodata.com/en-us/blog/tag/goldengate-23ai-to-26ai) - [GoldenGate 26ai new features (1)](https://rheodata.com/en-us/blog/tag/goldengate-26ai-new-features) - [GoldenGate 26ai release notes (1)](https://rheodata.com/en-us/blog/tag/goldengate-26ai-release-notes) - [GoldenGate 26ai upgrade (1)](https://rheodata.com/en-us/blog/tag/goldengate-26ai-upgrade) - [GoldenGate AI integration (1)](https://rheodata.com/en-us/blog/tag/goldengate-ai-integration) - [GoldenGate CDC configuration (1)](https://rheodata.com/en-us/blog/tag/goldengate-cdc-configuration) - [GoldenGate DAA (1)](https://rheodata.com/en-us/blog/tag/goldengate-daa) - [GoldenGate Extract user permissions (1)](https://rheodata.com/en-us/blog/tag/goldengate-extract-user-permissions) - [GoldenGate Yugabyte support (1)](https://rheodata.com/en-us/blog/tag/goldengate-yugabyte-support) - [GoldenGate certificate authentication (1)](https://rheodata.com/en-us/blog/tag/goldengate-certificate-authentication) - [GoldenGate cutover planning (1)](https://rheodata.com/en-us/blog/tag/goldengate-cutover-planning) - [GoldenGate deployment automation (1)](https://rheodata.com/en-us/blog/tag/goldengate-deployment-automation) - [GoldenGate granular permissions setup (1)](https://rheodata.com/en-us/blog/tag/goldengate-granular-permissions-setup) - [GoldenGate least privilege security (1)](https://rheodata.com/en-us/blog/tag/goldengate-least-privilege-security) - [GoldenGate lifecycle management (1)](https://rheodata.com/en-us/blog/tag/goldengate-lifecycle-management) - [GoldenGate migration guide (1)](https://rheodata.com/en-us/blog/tag/goldengate-migration-guide) - [GoldenGate migration sizing (1)](https://rheodata.com/en-us/blog/tag/goldengate-migration-sizing) - [GoldenGate monitoring and lag management (1)](https://rheodata.com/en-us/blog/tag/goldengate-monitoring-and-lag-management) - [GoldenGate operational ownership (1)](https://rheodata.com/en-us/blog/tag/goldengate-operational-ownership) - [GoldenGate password management (1)](https://rheodata.com/en-us/blog/tag/goldengate-password-management) - [GoldenGate port configuration (1)](https://rheodata.com/en-us/blog/tag/goldengate-port-configuration) - [GoldenGate replication lag detection (1)](https://rheodata.com/en-us/blog/tag/goldengate-replication-lag-detection) - [GoldenGate response file (1)](https://rheodata.com/en-us/blog/tag/goldengate-response-file) - [GoldenGate trail file management (1)](https://rheodata.com/en-us/blog/tag/goldengate-trail-file-management) - [GoldenGate troubleshooting solutions (1)](https://rheodata.com/en-us/blog/tag/goldengate-troubleshooting-solutions) - [GoldenGate unified console (1)](https://rheodata.com/en-us/blog/tag/goldengate-unified-console) - [GoldenGateMCP (1)](https://rheodata.com/en-us/blog/tag/goldengatemcp) - [Google Cloud Platform (1)](https://rheodata.com/en-us/blog/tag/google-cloud-platform) - [Google Cloud Storage (1)](https://rheodata.com/en-us/blog/tag/google-cloud-storage) - [Google-AlloyDB (1)](https://rheodata.com/en-us/blog/tag/google-alloydb) - [HashiCorp (1)](https://rheodata.com/en-us/blog/tag/hashicorp) - [Hybrid queries Oracle (1)](https://rheodata.com/en-us/blog/tag/hybrid-queries-oracle) - [IT cost optimization (1)](https://rheodata.com/en-us/blog/tag/it-cost-optimization) - [IT infrastructure simplification (1)](https://rheodata.com/en-us/blog/tag/it-infrastructure-simplification) - [IT leadership mental health (1)](https://rheodata.com/en-us/blog/tag/it-leadership-mental-health) - [Initial Load (1)](https://rheodata.com/en-us/blog/tag/initial-load) - [Inventory management data lag (1)](https://rheodata.com/en-us/blog/tag/inventory-management-data-lag) - [LLM inference optimization (1)](https://rheodata.com/en-us/blog/tag/llm-inference-optimization) - [Large language model performance (1)](https://rheodata.com/en-us/blog/tag/large-language-model-performance) - [MCP Server for Oracle (1)](https://rheodata.com/en-us/blog/tag/mcp-server-for-oracle) - [MCP Server, (1)](https://rheodata.com/en-us/blog/tag/mcp-server) - [Mental Health Awareness Month tech industry (1)](https://rheodata.com/en-us/blog/tag/mental-health-awareness-month-tech-industry) - [Migration readiness (1)](https://rheodata.com/en-us/blog/tag/migration-readiness) - [Model Context Protocol (1)](https://rheodata.com/en-us/blog/tag/model-context-protocol) - [Model inference costs (1)](https://rheodata.com/en-us/blog/tag/model-inference-costs) - [OMA assessment (1)](https://rheodata.com/en-us/blog/tag/oma-assessment) - [ONNX embedding model Oracle (1)](https://rheodata.com/en-us/blog/tag/onnx-embedding-model-oracle) - [Operating Model (1)](https://rheodata.com/en-us/blog/tag/operating-model) - [Oracle 23ai features (1)](https://rheodata.com/en-us/blog/tag/oracle-23ai-features) - [Oracle 26ai features (1)](https://rheodata.com/en-us/blog/tag/oracle-26ai-features) - [Oracle AI Data Platform (1)](https://rheodata.com/en-us/blog/tag/oracle-ai-data-platform) - [Oracle AI Solutions (1)](https://rheodata.com/en-us/blog/tag/oracle-ai-solutions) - [Oracle Autonomous Database migration (1)](https://rheodata.com/en-us/blog/tag/oracle-autonomous-database-migration) - [Oracle CPAT vs OMA comparison (1)](https://rheodata.com/en-us/blog/tag/oracle-cpat-vs-oma-comparison) - [Oracle Database 23ai vectors (1)](https://rheodata.com/en-us/blog/tag/oracle-database-23ai-vectors) - [Oracle Database 26ai vectors (1)](https://rheodata.com/en-us/blog/tag/oracle-database-26ai-vectors) - [Oracle EBS migration (1)](https://rheodata.com/en-us/blog/tag/oracle-ebs-migration) - [Oracle Exadata on Google Cloud (1)](https://rheodata.com/en-us/blog/tag/oracle-exadata-on-google-cloud) - [Oracle GoldenGate 26ai (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-26ai) - [Oracle GoldenGate AI diagnostics (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-ai-diagnostics) - [Oracle GoldenGate Azure (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-azure) - [Oracle GoldenGate Management (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-management) - [Oracle GoldenGate REST API automation (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-rest-api-automation) - [Oracle GoldenGate SQL Server permissions (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-sql-server-permissions) - [Oracle GoldenGate automation (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-automation) - [Oracle GoldenGate heartbeat (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-heartbeat) - [Oracle GoldenGate least privilege security (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-least-privilege-security) - [Oracle GoldenGate managed services (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-managed-services) - [Oracle GoldenGate migration strategy (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-migration-strategy) - [Oracle GoldenGate monitoring tools (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-monitoring-tools) - [Oracle GoldenGate replication best practices (1)](https://rheodata.com/en-us/blog/tag/oracle-goldengate-replication-best-practices) - [Oracle and Google Cloud AI (1)](https://rheodata.com/en-us/blog/tag/oracle-and-google-cloud-ai) - [Oracle cloud cost optimization (1)](https://rheodata.com/en-us/blog/tag/oracle-cloud-cost-optimization) - [Oracle cloud migration assessment (1)](https://rheodata.com/en-us/blog/tag/oracle-cloud-migration-assessment) - [Oracle data replication 2026 (1)](https://rheodata.com/en-us/blog/tag/oracle-data-replication-2026) - [Oracle data replication compliance (1)](https://rheodata.com/en-us/blog/tag/oracle-data-replication-compliance) - [Oracle database migration to OCI (1)](https://rheodata.com/en-us/blog/tag/oracle-database-migration-to-oci) - [Oracle replication governance (1)](https://rheodata.com/en-us/blog/tag/oracle-replication-governance) - [Oracle replication lag diagnosis (1)](https://rheodata.com/en-us/blog/tag/oracle-replication-lag-diagnosis) - [Oracle to cloud migration (1)](https://rheodata.com/en-us/blog/tag/oracle-to-cloud-migration) - [Oracle vs Databricks (1)](https://rheodata.com/en-us/blog/tag/oracle-vs-databricks) - [Oracle workload analysis (1)](https://rheodata.com/en-us/blog/tag/oracle-workload-analysis) - [Oracle@Google Cloud (1)](https://rheodata.com/en-us/blog/tag/oraclegoogle-cloud) - [Parallel Replicat (1)](https://rheodata.com/en-us/blog/tag/parallel-replicat) - [Parquet (1)](https://rheodata.com/en-us/blog/tag/parquet) - [RAG pipeline database (1)](https://rheodata.com/en-us/blog/tag/rag-pipeline-database) - [REST API (1)](https://rheodata.com/en-us/blog/tag/rest-api) - [Real-time AI processing (1)](https://rheodata.com/en-us/blog/tag/real-time-ai-processing) - [SQL Server replication security best practices (1)](https://rheodata.com/en-us/blog/tag/sql-server-replication-security-best-practices) - [Semantic search database (1)](https://rheodata.com/en-us/blog/tag/semantic-search-database) - [Similarity search Oracle (1)](https://rheodata.com/en-us/blog/tag/similarity-search-oracle) - [Snowflake Optima indexing (1)](https://rheodata.com/en-us/blog/tag/snowflake-optima-indexing) - [Snowflake Search Optimization Service (1)](https://rheodata.com/en-us/blog/tag/snowflake-search-optimization-service) - [Snowflake alternatives (1)](https://rheodata.com/en-us/blog/tag/snowflake-alternatives) - [Snowflake automatic clustering (1)](https://rheodata.com/en-us/blog/tag/snowflake-automatic-clustering) - [Snowflake budget monitoring (1)](https://rheodata.com/en-us/blog/tag/snowflake-budget-monitoring) - [Snowflake cloud data warehouse performance (1)](https://rheodata.com/en-us/blog/tag/snowflake-cloud-data-warehouse-performance) - [Snowflake cost governance (1)](https://rheodata.com/en-us/blog/tag/snowflake-cost-governance) - [Snowflake cost management (1)](https://rheodata.com/en-us/blog/tag/snowflake-cost-management) - [Snowflake cost reduction strategies (1)](https://rheodata.com/en-us/blog/tag/snowflake-cost-reduction-strategies) - [Snowflake credit usage (1)](https://rheodata.com/en-us/blog/tag/snowflake-credit-usage) - [Snowflake materialized views (1)](https://rheodata.com/en-us/blog/tag/snowflake-materialized-views) - [Snowflake migration staffing (1)](https://rheodata.com/en-us/blog/tag/snowflake-migration-staffing) - [Snowflake performance optimization (1)](https://rheodata.com/en-us/blog/tag/snowflake-performance-optimization) - [Snowflake query acceleration service (1)](https://rheodata.com/en-us/blog/tag/snowflake-query-acceleration-service) - [Snowflake query performance tuning (1)](https://rheodata.com/en-us/blog/tag/snowflake-query-performance-tuning) - [Snowflake resource monitors (1)](https://rheodata.com/en-us/blog/tag/snowflake-resource-monitors) - [Snowflake serverless compute costs (1)](https://rheodata.com/en-us/blog/tag/snowflake-serverless-compute-costs) - [Snowflake spend attribution (1)](https://rheodata.com/en-us/blog/tag/snowflake-spend-attribution) - [Snowflake warehouse optimization (1)](https://rheodata.com/en-us/blog/tag/snowflake-warehouse-optimization) - [Snowflake warehouse right-sizing (1)](https://rheodata.com/en-us/blog/tag/snowflake-warehouse-right-sizing) - [Token generation latency (1)](https://rheodata.com/en-us/blog/tag/token-generation-latency) - [VECTOR datatype Oracle (1)](https://rheodata.com/en-us/blog/tag/vector-datatype-oracle) - [VECTOR\_DISTANCE function (1)](https://rheodata.com/en-us/blog/tag/vector_distance-function) - [Vector embeddings Oracle (1)](https://rheodata.com/en-us/blog/tag/vector-embeddings-oracle) - [What's new GoldenGate 26ai (1)](https://rheodata.com/en-us/blog/tag/whats-new-goldengate-26ai) - [access control (1)](https://rheodata.com/en-us/blog/tag/access-control) - [activepass (1)](https://rheodata.com/en-us/blog/tag/activepass) - [adb (1)](https://rheodata.com/en-us/blog/tag/adb) - [add (1)](https://rheodata.com/en-us/blog/tag/add) - [add credentials (1)](https://rheodata.com/en-us/blog/tag/add-credentials) - [adminclient add credentials (1)](https://rheodata.com/en-us/blog/tag/adminclient-add-credentials) - [administration (1)](https://rheodata.com/en-us/blog/tag/administration) - [adw (1)](https://rheodata.com/en-us/blog/tag/adw) - [ai failures 2024 (1)](https://rheodata.com/en-us/blog/tag/ai-failures-2024) - [ai stratgies (1)](https://rheodata.com/en-us/blog/tag/ai-stratgies) - [ai-architecture (1)](https://rheodata.com/en-us/blog/tag/ai-architecture) - [all or nothing (1)](https://rheodata.com/en-us/blog/tag/all-or-nothing) - [allowPublicKeyRetrieval (1)](https://rheodata.com/en-us/blog/tag/allowpublickeyretrieval) - [alloydb (1)](https://rheodata.com/en-us/blog/tag/alloydb) - [alter extract 21c (1)](https://rheodata.com/en-us/blog/tag/alter-extract-21c) - [amazon (1)](https://rheodata.com/en-us/blog/tag/amazon) - [ansible (1)](https://rheodata.com/en-us/blog/tag/ansible) - [approximate-nearest-neighbor (1)](https://rheodata.com/en-us/blog/tag/approximate-nearest-neighbor) - [automl (1)](https://rheodata.com/en-us/blog/tag/automl) - [azure-cloud (1)](https://rheodata.com/en-us/blog/tag/azure-cloud) - [azure-native (1)](https://rheodata.com/en-us/blog/tag/azure-native) - [bastion (1)](https://rheodata.com/en-us/blog/tag/bastion) - [bastion host configuartion (1)](https://rheodata.com/en-us/blog/tag/bastion-host-configuartion) - [bastion setup oracle (1)](https://rheodata.com/en-us/blog/tag/bastion-setup-oracle) - [bug 30193036 (1)](https://rheodata.com/en-us/blog/tag/bug-30193036) - [bugs (1)](https://rheodata.com/en-us/blog/tag/bugs) - [build a compute node in oci (1)](https://rheodata.com/en-us/blog/tag/build-a-compute-node-in-oci) - [business-continuity (1)](https://rheodata.com/en-us/blog/tag/business-continuity) - [certificate-based authentication (1)](https://rheodata.com/en-us/blog/tag/certificate-based-authentication) - [change data capture (1)](https://rheodata.com/en-us/blog/tag/change-data-capture) - [changing ssh keys (1)](https://rheodata.com/en-us/blog/tag/changing-ssh-keys) - [channels (1)](https://rheodata.com/en-us/blog/tag/channels) - [cloud cost control (1)](https://rheodata.com/en-us/blog/tag/cloud-cost-control) - [cloud data platform cost control (1)](https://rheodata.com/en-us/blog/tag/cloud-data-platform-cost-control) - [cloud migration readiness assessment (1)](https://rheodata.com/en-us/blog/tag/cloud-migration-readiness-assessment) - [cloud-database-setup (1)](https://rheodata.com/en-us/blog/tag/cloud-database-setup) - [cloud-sql-migration (1)](https://rheodata.com/en-us/blog/tag/cloud-sql-migration) - [cloud-strategy (1)](https://rheodata.com/en-us/blog/tag/cloud-strategy) - [cohere command (1)](https://rheodata.com/en-us/blog/tag/cohere-command) - [compute (1)](https://rheodata.com/en-us/blog/tag/compute) - [compute portability (1)](https://rheodata.com/en-us/blog/tag/compute-portability) - [compute-instance (1)](https://rheodata.com/en-us/blog/tag/compute-instance) - [connect to database via bastion host (1)](https://rheodata.com/en-us/blog/tag/connect-to-database-via-bastion-host) - [connect to database via bastion host oci (1)](https://rheodata.com/en-us/blog/tag/connect-to-database-via-bastion-host-oci) - [consultants (1)](https://rheodata.com/en-us/blog/tag/consultants) - [content strategy (1)](https://rheodata.com/en-us/blog/tag/content-strategy) - [cost-optimization (1)](https://rheodata.com/en-us/blog/tag/cost-optimization) - [cryptographic authentication (1)](https://rheodata.com/en-us/blog/tag/cryptographic-authentication) - [curl (1)](https://rheodata.com/en-us/blog/tag/curl) - [daemon (1)](https://rheodata.com/en-us/blog/tag/daemon) - [data encryption (1)](https://rheodata.com/en-us/blog/tag/data-encryption) - [data fabric (1)](https://rheodata.com/en-us/blog/tag/data-fabric) - [data governance framework (1)](https://rheodata.com/en-us/blog/tag/data-governance-framework) - [data lake architecture (1)](https://rheodata.com/en-us/blog/tag/data-lake-architecture) - [data lakehouse platform (1)](https://rheodata.com/en-us/blog/tag/data-lakehouse-platform) - [data pipeline security (1)](https://rheodata.com/en-us/blog/tag/data-pipeline-security) - [data platform selection (1)](https://rheodata.com/en-us/blog/tag/data-platform-selection) - [data team workload management (1)](https://rheodata.com/en-us/blog/tag/data-team-workload-management) - [database AI transformation (1)](https://rheodata.com/en-us/blog/tag/database-ai-transformation) - [database administrators (1)](https://rheodata.com/en-us/blog/tag/database-administrators) - [database capacity planning tools (1)](https://rheodata.com/en-us/blog/tag/database-capacity-planning-tools) - [database certificate authentication (1)](https://rheodata.com/en-us/blog/tag/database-certificate-authentication) - [database compliance audit replication (1)](https://rheodata.com/en-us/blog/tag/database-compliance-audit-replication) - [database consolidation strategy (1)](https://rheodata.com/en-us/blog/tag/database-consolidation-strategy) - [database credential management (1)](https://rheodata.com/en-us/blog/tag/database-credential-management) - [database migration planning tools (1)](https://rheodata.com/en-us/blog/tag/database-migration-planning-tools) - [database modernization AI (1)](https://rheodata.com/en-us/blog/tag/database-modernization-ai) - [database replication management (1)](https://rheodata.com/en-us/blog/tag/database-replication-management) - [database transformation consulting (1)](https://rheodata.com/en-us/blog/tag/database-transformation-consulting) - [database-failover (1)](https://rheodata.com/en-us/blog/tag/database-failover) - [database-vectors (1)](https://rheodata.com/en-us/blog/tag/database-vectors) - [db\_owner risk SQL Server replication (1)](https://rheodata.com/en-us/blog/tag/db_owner-risk-sql-server-replication) - [dba\_capture (1)](https://rheodata.com/en-us/blog/tag/dba_capture) - [dba\_queues (1)](https://rheodata.com/en-us/blog/tag/dba_queues) - [dbms\_aqadm.drop\_queue\_table (1)](https://rheodata.com/en-us/blog/tag/dbms_aqadm-drop_queue_table) - [dbms\_comparison (1)](https://rheodata.com/en-us/blog/tag/dbms_comparison) - [ddl (1)](https://rheodata.com/en-us/blog/tag/ddl) - [direct initial load (1)](https://rheodata.com/en-us/blog/tag/direct-initial-load) - [dml (1)](https://rheodata.com/en-us/blog/tag/dml) - [docker goldengate (1)](https://rheodata.com/en-us/blog/tag/docker-goldengate) - [docker images (1)](https://rheodata.com/en-us/blog/tag/docker-images) - [dynamic (1)](https://rheodata.com/en-us/blog/tag/dynamic) - [edb database (1)](https://rheodata.com/en-us/blog/tag/edb-database) - [elephant database (1)](https://rheodata.com/en-us/blog/tag/elephant-database) - [eliminate database password authentication (1)](https://rheodata.com/en-us/blog/tag/eliminate-database-password-authentication) - [emd360 (1)](https://rheodata.com/en-us/blog/tag/emd360) - [enable ddl (1)](https://rheodata.com/en-us/blog/tag/enable-ddl) - [enterprise (1)](https://rheodata.com/en-us/blog/tag/enterprise) - [enterprise AI (1)](https://rheodata.com/en-us/blog/tag/enterprise-ai) - [enterprise AI implementation (1)](https://rheodata.com/en-us/blog/tag/enterprise-ai-implementation) - [enterprise AI infrastructure (1)](https://rheodata.com/en-us/blog/tag/enterprise-ai-infrastructure) - [enterprise data governance (1)](https://rheodata.com/en-us/blog/tag/enterprise-data-governance) - [enterprise data integration (1)](https://rheodata.com/en-us/blog/tag/enterprise-data-integration) - [enterprise data strategy (1)](https://rheodata.com/en-us/blog/tag/enterprise-data-strategy) - [enterprise goldengate backup solution (1)](https://rheodata.com/en-us/blog/tag/enterprise-goldengate-backup-solution) - [enterprise manager (1)](https://rheodata.com/en-us/blog/tag/enterprise-manager) - [exception handling (1)](https://rheodata.com/en-us/blog/tag/exception-handling) - [experts in oracle goldengate (1)](https://rheodata.com/en-us/blog/tag/experts-in-oracle-goldengate) - [extract changes (1)](https://rheodata.com/en-us/blog/tag/extract-changes) - [extract load transform (1)](https://rheodata.com/en-us/blog/tag/extract-load-transform) - [extract transform load (1)](https://rheodata.com/en-us/blog/tag/extract-transform-load) - [failures (1)](https://rheodata.com/en-us/blog/tag/failures) - [fintech postgreSQL (1)](https://rheodata.com/en-us/blog/tag/fintech-postgresql) - [firewalld goldengate (1)](https://rheodata.com/en-us/blog/tag/firewalld-goldengate) - [firewalld microservices (1)](https://rheodata.com/en-us/blog/tag/firewalld-microservices) - [fivetran (1)](https://rheodata.com/en-us/blog/tag/fivetran) - [framework (1)](https://rheodata.com/en-us/blog/tag/framework) - [frameworks (1)](https://rheodata.com/en-us/blog/tag/frameworks) - [free tools (1)](https://rheodata.com/en-us/blog/tag/free-tools) - [fresh data (1)](https://rheodata.com/en-us/blog/tag/fresh-data) - [gemini (1)](https://rheodata.com/en-us/blog/tag/gemini) - [genai (1)](https://rheodata.com/en-us/blog/tag/genai) - [general information (1)](https://rheodata.com/en-us/blog/tag/general-information) - [ggsci (1)](https://rheodata.com/en-us/blog/tag/ggsci) - [ggsmon (1)](https://rheodata.com/en-us/blog/tag/ggsmon) - [goldengate active passive (1)](https://rheodata.com/en-us/blog/tag/goldengate-active-passive) - [goldengate backup automation (1)](https://rheodata.com/en-us/blog/tag/goldengate-backup-automation) - [goldengate bug (1)](https://rheodata.com/en-us/blog/tag/goldengate-bug) - [goldengate errors (1)](https://rheodata.com/en-us/blog/tag/goldengate-errors) - [goldengate experts (1)](https://rheodata.com/en-us/blog/tag/goldengate-experts) - [goldengate free (1)](https://rheodata.com/en-us/blog/tag/goldengate-free) - [goldengate github integration (1)](https://rheodata.com/en-us/blog/tag/goldengate-github-integration) - [goldengate high availiability (1)](https://rheodata.com/en-us/blog/tag/goldengate-high-availiability) - [goldengate maa (1)](https://rheodata.com/en-us/blog/tag/goldengate-maa) - [goldengate microservices port (1)](https://rheodata.com/en-us/blog/tag/goldengate-microservices-port) - [goldengate microservices ports (1)](https://rheodata.com/en-us/blog/tag/goldengate-microservices-ports) - [goldengate ogg-02028 (1)](https://rheodata.com/en-us/blog/tag/goldengate-ogg-02028) - [goldengate parameter file backup (1)](https://rheodata.com/en-us/blog/tag/goldengate-parameter-file-backup) - [google cloudsql (1)](https://rheodata.com/en-us/blog/tag/google-cloudsql) - [google mysql migration (1)](https://rheodata.com/en-us/blog/tag/google-mysql-migration) - [heatwave experts (1)](https://rheodata.com/en-us/blog/tag/heatwave-experts) - [high performance mysql (1)](https://rheodata.com/en-us/blog/tag/high-performance-mysql) - [human creativity AI (1)](https://rheodata.com/en-us/blog/tag/human-creativity-ai) - [human vs AI writing (1)](https://rheodata.com/en-us/blog/tag/human-vs-ai-writing) - [hybrid cloud data architecture (1)](https://rheodata.com/en-us/blog/tag/hybrid-cloud-data-architecture) - [integrated extract oracle (1)](https://rheodata.com/en-us/blog/tag/integrated-extract-oracle) - [integrated replicat oracle (1)](https://rheodata.com/en-us/blog/tag/integrated-replicat-oracle) - [lic (1)](https://rheodata.com/en-us/blog/tag/lic) - [license (1)](https://rheodata.com/en-us/blog/tag/license) - [logmnr\_session$ (1)](https://rheodata.com/en-us/blog/tag/logmnr_session) - [managed service provider (1)](https://rheodata.com/en-us/blog/tag/managed-service-provider) - [managed services for database teams (1)](https://rheodata.com/en-us/blog/tag/managed-services-for-database-teams) - [management (1)](https://rheodata.com/en-us/blog/tag/management) - [migration compatibility validation (1)](https://rheodata.com/en-us/blog/tag/migration-compatibility-validation) - [monitor oracle goldengate rest api (1)](https://rheodata.com/en-us/blog/tag/monitor-oracle-goldengate-rest-api) - [monolithic database architecture (1)](https://rheodata.com/en-us/blog/tag/monolithic-database-architecture) - [move off of oracle (1)](https://rheodata.com/en-us/blog/tag/move-off-of-oracle) - [multi-cloud data platform (1)](https://rheodata.com/en-us/blog/tag/multi-cloud-data-platform) - [oci bastion (1)](https://rheodata.com/en-us/blog/tag/oci-bastion) - [oem emd360 (1)](https://rheodata.com/en-us/blog/tag/oem-emd360) - [ogg deployments (1)](https://rheodata.com/en-us/blog/tag/ogg-deployments) - [open table format (1)](https://rheodata.com/en-us/blog/tag/open-table-format) - [oracle database (1)](https://rheodata.com/en-us/blog/tag/oracle-database) - [preventing tech employee attrition (1)](https://rheodata.com/en-us/blog/tag/preventing-tech-employee-attrition) - [reducing on-call burnout (1)](https://rheodata.com/en-us/blog/tag/reducing-on-call-burnout) - [securing Oracle GoldenGate on SQL Server (1)](https://rheodata.com/en-us/blog/tag/securing-oracle-goldengate-on-sql-server) - [tech team burnout (1)](https://rheodata.com/en-us/blog/tag/tech-team-burnout) - [thought leadership (1)](https://rheodata.com/en-us/blog/tag/thought-leadership) - [vector database consolidation (1)](https://rheodata.com/en-us/blog/tag/vector-database-consolidation) See all ## Related Posts ## [Deploying Oracle GoldenGate 21c with Ansible](https://rheodata.com/en-us/blog/deploying-oracle-goldengate-21c-with-ansible) Posted by [Fame](https://rheodata.com/en-us/blog/author/fame) | Nov 10, 2025 9:30:52 PM Ansible has become a standard configuration tool for many enterprises and is used is many CI/CD... Read more ## [Oracle GoldenGate Response Files: Understanding the Evolution from 12c to 23ai](https://rheodata.com/en-us/blog/oracle-goldengate-response-files-21c-vs-23ai) Posted by [Bobby Curtis](https://rheodata.com/en-us/blog/author/bobby-curtis) | Nov 7, 2025 10:48:00 AM ## Clear Objectives. Team Success. If you’ve been deploying Oracle GoldenGate using response files... Read more ## [Build an HVR Hub without underlying database](https://rheodata.com/en-us/blog/build-an-hvr-hub-without-underlying-database) Posted by [Bobby Curtis](https://rheodata.com/en-us/blog/author/bobby-curtis) | Nov 10, 2025 9:29:56 PM In recent years, the data integration/replication space has stared to become crowded. Products like... Read more ##### About RheoData RheoData is based out of Metro Atlanta, GA and provide expert Oracle, Microsoft, Google, and Snowflake services.  Let us  know how we can help! ##### Links - [About Us](https://rheodata.com/who-we-are) - [FrostCore](https://rheodata.com/frostcore) - [RedCore](https://rheodata.com/redcore) - [BlueCore](https://rheodata.com/bluecore) ##### Contact us [hello@rheodata.com](mailto:hello@rheodata.com) ©RheoData2026. All Rights Reserved. ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Bobby Curtis", "url" : "https://rheodata.com/en-us/blog/author/bobby-curtis" }, "dateModified" : "2025-11-11T02:30:46.401Z", "datePublished" : "2025-11-11T02:30:46.000Z", "headline" : "Replicating PostgreSQL data using Oracle GoldenGate - RheoData", "image" : [ "https://rheodata.com/hubfs/Imported_Blog_Media/blog-feature-Logo-Oct-31-2025-04-57-26-6962-PM.png" ], "mainEntityOfPage" : { "@id" : "https://rheodata.com/en-us/blog/replicating-postgresql-data-using-oracle-goldengate", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://rheodata.com/hubfs/RheoData%20-%20Logo%20-%20transparent-1.png" } } } ``` ```json { "@context" : "https://schema.org", "@type" : "Organization", "address" : { "@type" : "PostalAddress", "addressCountry" : "US", "addressRegion" : "GA" }, "description" : "Elite specialist partner for Oracle, Snowflake, BigQuery, and AI-ready data platforms.", "email" : "hello@rheodata.com", "foundingDate" : "2020", "logo" : "https://rheodata.com/hubfs/RheoData%20-%20Logo%20-%20transparent-1.png", "name" : "RheoData", "sameAs" : [ "https://www.linkedin.com/company/rheodata" ], "url" : "https://rheodata.com" } ``` ```json { "@context" : "https://schema.org", "@type" : "WebSite", "name" : "RheoData", "potentialAction" : { "@type" : "SearchAction", "query-input" : "required name=search_term_string", "target" : "https://rheodata.com/search?q={search_term_string}" }, "url" : "https://rheodata.com" } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Bobby Curtis", "url" : "https://rheodata.com/en-us/blog/author/bobby-curtis" }, "dateModified" : "2025-11-11T02:30:46+0000", "datePublished" : "2025-11-11T02:30:46+0000", "description" : "Something that has been brewing for years – since late 2017 – is the constant...", "headline" : "<span id="hs_cos_wrapper_name" class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="meta_field" data-hs-cos-type="text" >Replicating PostgreSQL data using Oracle GoldenGate</span>", "image" : "https://50642793.fs1.hubspotusercontent-na1.net/hubfs/50642793/Imported_Blog_Media/blog-feature-Logo-Oct-31-2025-04-57-26-6962-PM.png", "mainEntityOfPage" : { "@id" : "https://rheodata.com/en-us/blog/replicating-postgresql-data-using-oracle-goldengate", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://rheodata.com/hubfs/RheoData%20-%20Logo%20-%20transparent-1.png" }, "name" : "RheoData" } } ``` ```json { "@context" : "http://schema.org", "@type" : "BlogPosting", "articleBody" : "Something that has been brewing for years – since late 2017 – is the constant request from Oracle customers on how to capture data from PostgreSQL databases. Many of Oracle’s customers are either moving towards PostgreSQL and off of Oracle or looking for another way to pull data from PostgreSQL into their Oracle Data Warehouses. In either case, Oracle has finally gotten around to releasing a fully supported version of Oracle GoldenGate for PostgreSQL, meaning that customers can now capture (extract) and apply (replicat) data from PostgreSQL 10 and later. The downside to this is that Oracle released it in “Classic” architecture instead of the “Microservices” architecture. Meaning customers still do not have access to remote administration capabilities and will have to rely on server access. A positive though is that this version of Oracle GoldenGate can be used in a hub-n-spoke architecture and for bi-directional replication. I will not be covering those topics though. Let’s get started … Prerequisites: As with anything there is always a set of prerequisites that are needed before you can proceed with an installation. In this cases, it holds true – the Oracle docs don’t even cover a good bit of these, but with a little help I was able to resolve what was needed. Linux Packages: PostgreSQL#-contrib – this package is needed to allow you to register the extract with the PostgreSQL database PostgreSQL.conf file changes: These items were interesting and documented in Oracle docs, but remember, after changes the PostgreSQL database must be restarted. wal_level = logicial max_replication_slots = 10 (default) max_wal_sender = 10 (default) wal_receiver_status_interval (optional) wal_sender_timeout (optional) track_commit_timestamp = false (optional) As you can tell Oracle is leveraging the Write Ahead Logging (WAL) parameters to ensure everything is read from the database and transaction logs correctly. Users: Just like typical Oracle GoldenGate setup, you must define a user that will be used for Oracle GoldenGate. In my setups, I typically name the user “ggate” but this user can be named anything. The key here is to ensure the right privileges are assigned. To setup an Oracle GoldenGate user, the following can be ran against a PostgreSQL database: create user ggate with password 'ggate' login; alter user ggate with replication; Environment Variables: There are a slew of environment variables that will need to be set to ensure that replication works. What is listed below is what I had to setup to ensure it all worked. Mileage will vary. export PG_HOME=/usr/pgsql-12 export OGG_HOME=/opt/app/oracle/19.1.0/oggcore_1 export ODBCINI=/home/oracle/odbc.ini export LD_LIBRARY_PATH=$PG_HOME/lib:$OGG_HOME/lib:$LD_LIBRARY_PATH export PATH=$ODBCINI:$PATH A couple of things to note here. The $PG_HOME must be in the $LD_LIBRARY_PATH. The $ODBCINI file location must be in the $PATH. These items can be easily setup in the .bashrc or .bash_profile for your environment. ODBC.ini file: Oracle GoldenGate uses the ODBC.ini file to connect to the PostgreSQL database. This file has to be configured and located by using the $ODBCINI environment variable. For simplicity of this blog, a little, I’m not going to post what it should look like. You can fine details within the Oracle docs -> here. Setting up replication: With all the prerequisites established, replication can be setup the exact same as any other Oracle GoldenGate “Classic” environment. The steps are similar to these below. Extract: 1. Install Oracle GoldenGate software – unzip/untar in the $OGG_HOME of choice. Then open GGSCI and run CREATE SUBDIRS (./GGSCI) + (CREATE SUBDIRS) 2. Edit the MGR parameter file (EDIT PARAMS MGR), assign port number (default 7809), and start manager (START MGR) 3. Login to the PostgreSQL databases as your GoldenGate user (DBLOGIN SOURCEDB USERID PASSWORD ) 4. Register extract with PostgreSQL database (REGISTER EXTRACT ) 5. Add extract (ADD EXTRACT , TRANLOG, BEGIN NOW) 6. Add trail file (ADD EXTTRAIL ./dirdat/aa, EXTRACT ) 7. Edit parameter file for extract (EDIT PARAMS ) 8. Add Trandata (ADD TRANDATA .) 10. Validate that MGR and EXTRACT have been started (INFO ALL) Replicat: 1. Create the GoldenGate schema inside of the PostgreSQL database (CREATE SCHEMA ) 2. Login to the PostgreSQL database (DBLOGIN SOURCEDB USERID PASSWORD ) 3. Add Checkpoint Table (ADD CHECKPOINTTABLE .) 4. Add Replicat (ADD REPLICAT , EXTTRAIL ./dirdat/aa, CHECKPOINTTABLE .) 5. Start Replicat (START REPLICAT ) 6. Check status of Replicat (INFO ALL) What you didn’t see/Summary: In the examples above, what was missing is the Data Pump Extract. Since I was configuring the movement of data on a single server with a single PostgreSQL database to two (2) different schemas, the Data Pump Extract was not needed. If you plan on moving data between sites, the Data Pump Extract is needed to route the trail files correctly. Another option is to configure Oracle GoldenGate in the hub-n-spoke architecture and the same approach as above can be followed and simply use the remote-capture/remote-apply functionality. In closing, Oracle has finally answered the call from customers by allowing them to capture and apply within a PostgreSQL environment. This brings the replication standard of reliable replication to a development platform as well as enabling organizations to maximize their data movement strategies. Enjoy!!) 9. Start MGR and EXTRACT (START MGR) + (START EXTRACT", "author" : { "@type" : "Person", "name" : "Bobby Curtis", "sameAs" : "", "url" : "https://rheodata.com/en-us/blog/author/bobby-curtis" }, "dateModified" : "10/11/2025", "datePublished" : "10/11/2025", "headline" : "Replicating PostgreSQL data using Oracle GoldenGate", "image" : { "@type" : "ImageObject", "height" : 400, "url" : "https://50642793.fs1.hubspotusercontent-na1.net/hubfs/50642793/Imported_Blog_Media/blog-feature-Logo-Oct-31-2025-04-57-26-6962-PM.png", "width" : 750 }, "mainEntityOfPage" : "https://rheodata.com/en-us/blog/replicating-postgresql-data-using-oracle-goldengate", "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://50642793.fs1.hubspotusercontent-na1.net/hubfs/50642793/RheoData%20-%20Logo%20-%20transparent-1.png" }, "name" : "RheoData", "url" : "rheodata.com" } } ```