Connections Lifecycle

A connection typically progresses through the following lifecycle:

• Create – Create a connection and specify the required endpoint, authentication, security, and optional runtime settings.

• Validate – Validate the connection to verify connectivity and authentication before it is used by an Oracle GoldenGate for DAA process.

• Use – Select the validated connection when creating or editing an Extract or Replicat process.

• Maintain – Update the connection as needed. For example, update credentials, certificates, endpoints, or runtime settings when they change. Revalidate the connection after modifying its configuration.

Using reusable connections reduces the administrative effort and promotes consistent connectivity across multiple Oracle GoldenGate processes.

Connections created before Oracle GoldenGate for DAA 26.3 cannot be reused by the Copy Connection feature or by Extracts and Replicats created in Oracle GoldenGate for DAA 26.3 or later.

For Oracle GoldenGate for DAA 26.3 and later, create a new connection before creating new Extracts or Replicats.

After you upgrade to Oracle GoldenGate for DAA 26.3 or later, observe the following behavior:

• Existing Extract and Replicat processes that are already configured continue to operate normally without requiring any configuration changes.

• Existing database connections used by these configured Extract and Replicat processes remain fully functional for ongoing replication.

• Existing connections cannot be reused when creating new Extract or Replicat processes after applying the patch for Oracle GoldenGate for DAA 26.3.

• To create a new Extract or Replicat process, create a new target connection and use that connection during the process configuration. Note: When creating a new connection, ensure that the runtime classpath for third-party dependencies ends with /*. The /* suffix enables Oracle GoldenGate for DAA to load all required dependency JAR files from the specified directory.