DBASolved

Subscribe to  DBASolved feed  DBASolved
Data Migration, Data Replication, Cloud and DevOps
Updated: 4 hours 38 min ago

Manually purging trail files from OCI GoldenGate Service

Fri, 2023-05-19 21:09

Oracle GoldenGate Service is Oracle’s cloud offering  to quickly use GoldenGate to move data within OCI as well as other […]

The post Manually purging trail files from OCI GoldenGate Service appeared first on DBASolved.

Categories: DBA Blogs

Using NGINX in unsecure mode for Oracle GoldenGate

Tue, 2023-04-18 11:43

Sometimes, you just want to run NGINX in unsecure mode (over port 80) for internal environments.  The steps here are […]

The post Using NGINX in unsecure mode for Oracle GoldenGate appeared first on DBASolved.

Categories: DBA Blogs

GoldenGate Parameter Files – Format and Logic

Sat, 2023-03-18 22:37

As I have done multiple engagements with Oracle GoldenGate and helped clients get the most out of their investment; I […]

The post GoldenGate Parameter Files – Format and Logic appeared first on DBASolved.

Categories: DBA Blogs

Identifying Predefined Administrative Accounts in Autonomous Database or any other Oracle database

Wed, 2023-03-15 13:12

A quick post as a reminder for myself some time down the road.  After all, we all need reminders every […]

The post Identifying Predefined Administrative Accounts in Autonomous Database or any other Oracle database appeared first on DBASolved.

Categories: DBA Blogs

Access Oracle DBCS Pluggable Database via Bastion Connection

Sun, 2023-03-05 21:22

What is a Bastion? There a three primary definition for the word Bastion.  They are: A projecting part of a […]

The post Access Oracle DBCS Pluggable Database via Bastion Connection appeared first on DBASolved.

Categories: DBA Blogs

Setting up OCI API Keys

Tue, 2023-02-28 13:48

When setting up a new environment or getting access to a client’s OCI environment, the first thing that should be […]

The post Setting up OCI API Keys appeared first on DBASolved.

Categories: DBA Blogs

OGG-12031 error … What happened?

Sat, 2023-02-04 15:47

    On one of our projects, we have been using an Oracle GoldenGate (Microservices) hub architecture to run the […]

The post OGG-12031 error … What happened? appeared first on DBASolved.

Categories: DBA Blogs

CreateOUIProcess(): 13 … Permission issue or Library issue?

Wed, 2023-02-01 13:39

Recently I have been doing some installs for Oracle GoldenGate via the silent install process; mostly using Ansible.  Every once […]

The post CreateOUIProcess(): 13 … Permission issue or Library issue? appeared first on DBASolved.

Categories: DBA Blogs

Configure Oracle GoldenGate’s ServiceManager as a Linux Service

Tue, 2023-01-31 18:58

  After installing Oracle GoldenGate with a manual ServiceManager, you realize that the ServiceManager will not come back up on […]

The post Configure Oracle GoldenGate’s ServiceManager as a Linux Service appeared first on DBASolved.

Categories: DBA Blogs

Performance with Oracle GoldenGate

Thu, 2023-01-26 16:46

  Recently I have been talking with customers about their Oracle GoldenGate implementations and how these implementations can benefit their […]

The post Performance with Oracle GoldenGate appeared first on DBASolved.

Categories: DBA Blogs

Mimic GGSCI with Python

Thu, 2023-01-12 15:49

Since the release of Oracle GoldenGate 12.2 (Classic) and Oracle GoldenGate 12.3 (Microservices), users have been able to interact with […]

The post Mimic GGSCI with Python appeared first on DBASolved.

Categories: DBA Blogs

Data comparisons and the DBMS_COMPARISON package

Thu, 2022-12-29 12:05

    When doing building and validating an Oracle GoldenGate implementation, understanding the data goes a bit deeper than only […]

The post Data comparisons and the DBMS_COMPARISON package appeared first on DBASolved.

Categories: DBA Blogs

Retrieving and understanding a response file for Oracle GoldenGate Deployment configuration

Sun, 2022-11-27 12:46

To say that Oracle GoldenGate has undergone a transformation over the last seven year is an understatement.  Back in 2017, […]

The post Retrieving and understanding a response file for Oracle GoldenGate Deployment configuration appeared first on DBASolved.

Categories: DBA Blogs

Running x86_64 Docker Images on Mac M1 Max (Oracle Database 19c)

Thu, 2022-09-22 14:42

  A few months ago, I wrote a post about me switching back to Windows (here).  I can say I […]

The post Running x86_64 Docker Images on Mac M1 Max (Oracle Database 19c) appeared first on DBASolved.

Categories: DBA Blogs

GoldenGate StreamAdmin account via Python

Sun, 2022-09-04 11:51

A few years ago, I wrote a blog post called “Where is my StreamAdmin account”?  This post was related to […]

The post GoldenGate StreamAdmin account via Python appeared first on DBASolved.

Categories: DBA Blogs

Opening a port in firewalld on RHEL for Oracle GoldenGate (Microservices)

Tue, 2022-06-28 19:36

With Oracle GoldenGate (Microservices) running on Linux, there is a setting that needs to be configured.  I you are like […]

The post Opening a port in firewalld on RHEL for Oracle GoldenGate (Microservices) appeared first on DBASolved.

Categories: DBA Blogs

Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c

Mon, 2022-06-27 07:45

When installed, Oracle GoldenGat (Microservices) will set up “services” that require a port number for access.  For the first run of the […]

The post Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c appeared first on DBASolved.

Categories: DBA Blogs

Initial Load from Tandem (HP-UX) to AWS Kafka

Mon, 2022-05-30 12:27

Working with a customer where we needed to move data from a Tandem (HP-UX Guardian) system up to an AWS […]

The post Initial Load from Tandem (HP-UX) to AWS Kafka appeared first on DBASolved.

Categories: DBA Blogs

Adding a database to MySQL HeatWave using Auto Parallel Load

Sat, 2022-05-21 14:59

If you are reading this post, more than likely you are either looking at Oracle’s MySQL HeatWave for the first […]

The post Adding a database to MySQL HeatWave using Auto Parallel Load appeared first on DBASolved.

Categories: DBA Blogs

Removing a MySQL Heatwave Cluster

Sat, 2022-05-21 11:36

Recently I’ve been playing with Oracle’s MySQL Database Service (MDS) and testing out the Heatwave option.  Heatwave is very impressive […]

The post Removing a MySQL Heatwave Cluster appeared first on DBASolved.

Categories: DBA Blogs

Pages