Master the DBA

How to install and configure Oracle Goldengate 21c Microservices on an Oracle 12c RAC environment.   Environmental details: Hosts: dbsrv01, dbsrv02 Clusterware and database version :12.1.0.2.0 GoldenGate version: 21.3.0.0.0 XAG Agent: 10.2 Applied Patches: 30070257   1. Setup ACFS File System for storing GoldenGate deployment files on Oracle RAC. Create the ACFS volume from the existing DATA disk group: [root@dbsrv01 ~]# su - grid Last login: Fri Aug 16 14:00:21 IST 2024 from gateway on pts/0 [grid@dbsrv01 ~]$ echo $ORACLE_SID +ASM1 [grid@dbsrv01 ~]$ asmcmd volcreate -G DATA -s 8G OGGVOL Verify the volume was created and obtain the new volume device name: [grid@dbsrv01 ~]$ asmcmd volinfo --all Diskgroup Name: DATA          Volume Name: OGGVOL          Volume Device: /dev/asm/oggvol-329          State: ENABLED          ...

Environmental details: Hosts:   dbsrv01, dbsrv02   Clusterware and database version  : 12.1.0.2   Applied Patches:   30070257   1. Create the ACFS volume from the existing DATA disk group as "grid" user:   [root@dbsrv01 ~]# su - grid Last login: Fri Aug 16 14:00:21 IST 2024 from gateway on pts/0 [grid@dbsrv01 ~]$ echo $ORACLE_SID +ASM1 [grid@dbsrv01 ~]$ asmcmd volcreate -G DATA -s 8G OGGVOL 2. Verify the volume was created and obtain the new volume device name: [grid@dbsrv01 ~]$ asmcmd volinfo --all Diskgroup Name: DATA          Volume Name: OGGVOL          Volume Device: /dev/asm/oggvol-329          State: ENABLED          Size (MB): 8192          Resize Unit (MB): 512          Redundancy: UNPROT          Stripe Columns: 8   ...

Hosts and databases used in this environment. Category Source Target Host srvdb01.localdomain srvdb02.localdomain IP Address 192.168.56.81 192.168.56.82 Database Oracle PostgreSQL Database Name orcl hr Database Version 19.3.0.0.0 12.0 Database Home /u01/app/oracle/product/19.0.0/dbhome_1 /usr/local/pg12 Goldengate Version 19.1.0.0.4 21.3.0.0.0 Goldengate Home /u01/app/oracle/product/19.1.0/ogg_1 /ogg_1 Goldengate Schema oggadmin pggadmin Table for Replication Scott.dept Public.dept We will setup table replication between Oracle to PostgreSQL databases. Oracle (Source) PostgreSQL (Target) 1.Unzip the Ora...