Cookbook – Goldengate Integrated Extract on Pluggable Database

#Export ORACLE_SID of container DATABASE, – My Container DB is “cdb01”.

[oracle@greporalab]$ export ORACLE_SID=cdb01

[oracle@greporalab]$ sqlplus / as sysdba

#Change to CONTAINER’s ROOT Session

SQL> alter session set container=CDB$ROOT;

#Create user and ADD Roles

Continue reading

Advertisements

Introducing Oracle GoldenGate Studio 12.2.1

Now GoldenGate developments is easy friendly.

Cheers for Oracle Demo that include first mapping.

Oracle GoldenGate Studio Highligts:

  • Separating Logical from the fisical
    • One project contain many solutions
    • A Solutions contain one logical design and many Physical Deployments
  • You can AUTOMAP table mappings – drag and drop optional columns
  • Easy deployments
  • Easy to setup DB connections

Prost!

GoldenGate 12.3

AYE! GoldenGate 12.3 is now released!

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

Capturar

What it brings?

– Support for Oracle Database 12.2.0.1
– Microservices Architecture
– Parallel Replicat
– Automatic Conflict-Detection-Resolution (CDR) without application changes
– Procedural Replication to enable simpler application migrations and upgrades
– Database Sharding
– Fast Start Capture

Let’s test this new features 🙂

Cheers!