2.4.2 Create the Connection
This topic describes the systematic instructions to create the connection.
User can create the Oracle Database connection by following the process below:
- From the OCI GoldenGate Overview screen, click
Connections.
Note:
User can also click Create Connection under the Get started section and move to next step - On the Connections page, click Create Connection.
- In the Create Connection tab, complete the
General Information fields as follows:
Table 2-5 General Information
Field Description Name Specify a name for the connection. Description Optional
Specify a description that helps you distinguish this connection from others.Compartment Select the compartment in which to create the connection. Type From Oracle, select Oracle Database. Show advances options Optional
Click the link to manage keys or add tags. - From Security, select one of the following:
- Select Use Oracle-managed encryption key, to leave all encryption key management to Oracle.
- Select Use Customer-managed encryption key, to select a specific encryption key stored in the OCI Vault to encrypt the user’s connection credentials.
- From Tags, add tags to organize the resources
- Click Next.
- Complete the Connection Details fields as follows:
- Select an existing database in the selected compartment and complete the rest of the fields as needed.
- Click Change Compartment, to select a database
in a different compartment. Also, maintain the following details:
Table 2-6 Compartment Details
Field Description Database Information Specify the database details. Database Connection String Optional
Specify the database's connection string.Database Username Specify the username to connect to the database. Database Password Specify the password associated to the username provided in the previous step. Database Wallet Optional
Drag-drop or select the wallet.zip for the database.- Network Connectivity: Select a traffic
routing method as follows:
- Shared endpoint: To share an endpoint with the assigned deployment. User must allow connectivity from the deployment's ingress IP.
- Dedicated endpoint: For network traffic through a dedicated endpoint in the assigned subnet in the VCN. User must allow connectivity from this connection's ingress IPS.
- Select a Session mode.
- Direct, to use the local listener running on a single database node, and then select the required subnet.
- Redirect, to use the SCAN listener used in Oracle Real Application Cluster (RAC) deployments, and then select the required subnet.
- Network Connectivity: Select a traffic
routing method as follows:
- Click Create.
- Assign the deployment details.
Click Options icon to the extreme right, for the assigned deployment and click Test connection.
Note:
- If an error message Network-level connectivity test failed! is displayed, then you need to allow ingress rule for port 1522. For more information, refer OCI Autonomous Database Setup.
- The user should also unlock the GGADMIN account before testing the connection.
Parent topic: OCI GoldenGate Deployment Setup





