Integrating TDE with CipherTrust Manager on Oracle GoldenGate 19c

Supported Mode

• Integrated Capture Mode only

Prerequisite

• Make sure the CAKM libraries are installed. Refer Installing CAKM for Oracle TDE on RHEL/Oracle Linux/AIX

  Currently, the Linux environment is supported only.

• Make sure the GoldenGate services are up and running.

• Run the ggsci utility.

  <goldengate installation directory>./ggsci
  

• Stop all DML/DDL transaction against GoldenGate (GG) related tables.

• Stop GoldenGate services on both source/target.

  stop mgr
  stop extract *
  

Integrating TDE with CipherTrust Manager on Oracle GoldenGate 19c

This section outlines the following steps to integrate TDE with the CipherTrust Manager on Oracle GoldenGate 19c:

• Migrating Auto-Login Software Wallet to Auto-Login HSM Wallet‌

• Migrating Auto-Login File Wallet with PDB to Auto-Login HSM Wallet with PDB

Migrating Auto-Login Software Wallet to Auto-Login HSM Wallet‌

After successfully Migrating Auto-Login Software Wallet to Auto-Login HSM Wallet‌, perform the following steps:

1. Start GoldenGate services on both source/target.

   start mgr
   start extract *
   

2. Access the data using select query.

   sqlplus / as sysdba
   SELECT * FROM CUSTOMERS;
   

3. Insert some values into the CUSTOMERS table.

   INSERT INTO CUSTOMERS VALUES (1, 'John', 10000);
   commit;
   

4. Access the data using select query.

   SELECT * FROM CUSTOMERS;
   

5. Check replication on target database.

   SELECT * FROM CUSTOMERS;
   

Migrating Auto-Login File Wallet with PDB to Auto-Login HSM Wallet with PDB‌

After successfully Migrating Auto-Login File Wallet to Auto-Login HSM Wallet with PDB‌, perform the following steps:

1. Start GoldenGate services on both source/target.

   start mgr
   start extract *
   

2. Access the data using select query.

   sqlplus / as sysdba
   SELECT * FROM CUSTOMERS;
   

3. Insert some values into the CUSTOMERS table.

   INSERT INTO CUSTOMERS VALUES (1, 'John', 10000);
   commit;
   

4. Access the data using select query.

   SELECT * FROM CUSTOMERS;
   

5. Check replication on target database.

   SELECT * FROM CUSTOMERS;