Install and Configure Oracle GoldenGate 12.3 Microservices Architecture

The objective of this document is to demonstrate how to install and configure the new Oracle 12.3 GoldenGate Microservices Architecture. For the purpose of demonstration and training I have created one VM database (oradb1) and will create a unidirectional replication from 2 existing schemas:  HR_SOURCE to HR_TARGET The Oracle GoldenGate Microservices Architecture have 6 main…

Replicat abending with database error 1403

Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very frequently on a production environment when implementing Goldengate for the first time. During the instantiation of the target database, if there is any open transaction which is yet to be committed, the extract is started…

SQLcl to view DDL

Today I ran into a scenario where I need to check if a table had an UNIQUE index. Instead of writing a quick sql I decided to try the new (not so new) SQLcl tool.  With the new describe (info), I could get a quick snapshot of the table DDL, Indexes and constraints. Pretty cool.  

Oracle Default Users

‘ANONYMOUS’ — HTTP access to XDB ‘APPQOSSYS’ — QOS system user ‘AUDSYS’ — audit super user ‘BI’ — Business Intelligence ‘CTXSYS’ — Text ‘DBSNMP’ — SNMP agent for OEM ‘DIP’ — Directory Integration Platform ‘DMSYS’ — Data Mining ‘DVF’ — Database Vault ‘DVSYS’ — Database Vault ‘EXDSYS’ — External ODCI System User ‘EXFSYS’ — Expression…