Add a Deployment to an Existing Service Manager

To add a deployment to an existing Service Manager, run the OGGCA utility using the following commands:

cd $OGG_HOME/bin
./oggca.sh

The OGGCA configuration wizard is displayed. Existing Service Manager option is preselected in the Service Manager Deployment screen.


Options to add a deployment to an existing Service Manager

Use the following steps to add a deployment to the existing Service Manager:
  1. From the Configuration Options section, select Add new GoldenGate deployment to add a deployment the existing Service Manager and click Next.

  2. On the Service Manager Administrator Account screen, specify the Service Manager login credentials for the existing Service Manager and click Next, as shown in the following image.


    Enter the user login credentials for the Service Manager administrator account for the existing Service Manager.

  3. On the User Deployment screen, configure the options for the new deployment, as mentioned in the following table:

    Option Description

    Deployment Name

    Specify a deployment name.

    Deployment Home

    Browse and select the location of you deployment.

    This location must be outside the Service Manager and Oracle GoldenGate installer locations.

    Customize

    Click the Customize button to specify a different location for the configuration directories such as OGG_ETC_HOME, OGG_CONF_HOME, OGG_SSL_HOME, OGG_VAR_HOME, OGG_DATA_HOME, OGG_ARCHIVE_HOME, and Performance Metrics DataStore Home.

    Ports

    Enter the port numbers for the Microservices:

    Administration Service

    Distribution Service

    Receiver Service

    Performance Metrics Service.

    Data Store Type

    Select the type of data store you need for storing Performance Metrics data. Options include BDB, and LMDB.

    Data Store Home

    Browse and select a location for the data store home directory.

    StatsD

    Enable this check box to specify the connection details of the StatsD server, which needs to be connected to the deployment. You need to specify the host name and a unique port number of the StatsD server using the options that get enabled after you select the StatsD enable checkbox.

    StatsD Host

    Enter the hostname or IP address of the StatsD server. This information would be used by the Service Manager to connect to the StatsD host. The StatsD server can be located on the same host machine where Oracle GoldenGate deployment exists, or it could be a remote host.

    StatsD Port

    Enter the port number for the StatsD host. The default port number is 8125.

    Server Certificates

    This box is disabled as the server certificate file (.pem) is already selected while configuring the Service Manager options.

    Server Private Key

    The server certificate private key file (.key) is preselected.

    Server CA Certificate

    The trusted RootCA certificate is also preselected.

    Client Certificates

    Browse and select the client certificate file (.pem) if required.

    Client Private Key

    Browse and select the client certificate private key file (.key) for the associated client certificate.

    Client CA Certificate

    Browse and select the trusted rootCA certificate that would verify the associated client certificate.

    TNS_ADMIN

    (Oracle only) Enter the value for this environment variable based on the location of the tnsnames.ora and sqlnet.ora files.

    The TNS_ADMIN parameter specifies the directory path of Oracle Net Services in which files such as the tnsnames.ora and sqlnet.ora reside. The tnsnames.ora file is the configuration file that contains the net service names that are mapped to the connect descriptors of the database services.

    Replication Schema

    Specify the schema name of the Oracle GoldenGate Database administrator user.

    Environment Variables

    Click this button to open the Environment Variables dialog box. It includes the paths for the preset environment variables, $OGG_HOME, and $LD_LIBRARY_PATH. Some variables are fixed, others can be extended, and you can add additional variables.

  4. On the User Administrator Account screen, enter the login credentials for the new deployment. Make sure to use a strong password. Click Next.

  5. Review the configurations for the deployment on the Summary screen. Click Finish and then click Next.

  6. View the progress of the deployment set up on the Configure Deployment screen. If the deployment is added successfully, then you'll see a message that the deployment is added successfully. Click Next.

  7. Click Close on the Finish screen to exit OGGCA.