In this video, you will learn the steps to add and configure various options for a deployment using the Oracle GoldenGate Configuration Assistant.
After installing Oracle GoldenGate, run the Oracle GoldenGate Configuration Assistant wizard (oggca) to set up the Service Manager and add deployments.
The oggca.sh utility is located in the /bin folder of the Oracle GoldenGate home directory.
You can also run OGGCA in silent mode but for the purposes of this video, the OGGCA wizard is used.
When you run the OGGCA utility for the first time, you get the option to create a new Service Manager.
You can then add new deployments to this Service Manager.
On the Service Manager Options screen, add a location for the Service Manger deployment home directory.
For better manageability, select a location outside the Oracle GoldenGate home directory.
Enter a hostname and port number that will be used to connect to the Service Manager.
You can select Register the Service Manager as a System Service (daemon) to avoid manually starting or stopping the Service Manager, when the host server restarts.
The Integrate with XAG option configures the Service Manager to integrate the deployment with an Oracle Grid Infrastructure for Oracle Database.
This option is disabled if you choose to register the Service Manager as a system service.
Click Next.
On the Configuration Options screen, select Add new GoldenGate deployment.
Click Next.
On the Deployment Details screen, add a name for the deployment.
Select Enable sharding, if you want to use shards with your Oracle database.
Select Enable FIPS mode for better security of OGG processes.
Click Next.
On the Deployment Directories screen, enter location for the deployment home directory.
Oracle recommends that you create the deployment home outside of the Oracle GoldenGate home directory.
Select Customize directories to change the location or names of the configuration directories for the deployment.
Click Next.
On the Environment Variables screen, check that the environment variables are configured for the deployment, the database server, and the operating system.
For example, make sure that you set the TNS_ADMIN variable if you are working with Oracle database.
Click Next.
On the Administrator Account screen, you can either add a user name and password for the deployment, or enter the username and password for an external identity provider for user authentication.
Oracle GoldenGate currently supports Oracle Identity Cloud Service (IDCS).
You use these credentials to access the Service Manager and other microservices.
Click Next.
On the Security Options screen, select SSL/TLS security to set up a secure deployment.
Make sure that you already created your wallets or certificates.
Add the location of the Server wallet or use a certificate with a passphrase.
Likewise, add the wallet details for the client side.
Click Next.
The Advanced Security Options screen lists the cipher suites available with TLS 1.2 encryption, which is selected by default.
Although you can choose the cipher suites as required, you can also select all the cipher suites and the encryption would be applied sequentially based on this list.
On the Port Setting screen, specify the port numbers for the OGG microservices.
Select Enable Performance Monitoring and specify a datastore where the performance data would be stored.
You can use the default datastore type, which is Berkeley Database (BDB) or you can use Light Memory Database (LMDB).
Click Next.
On the Specify OGG Replication Settings screen, add the schema name that contains the database objects owned by Oracle GoldenGate.
Click Next.
The Summary screen allows you to review the deployment configuration and make adjustments.
You can also save the response file from this screen.
Oracle recommends saving the response file for reference, if need.
Click Finish.
This begins the process for creating the configurations for the Service Manager and the deployment.
The deployment configuration has completed successfully.
Click Next and then click Close to exit the OGGCA wizard.
Log in to the Service Manager to validate that the deployment was successfully added to the Service Manager.
The deployment is listed in the Deployments section of the Service Manager Overview page.
Be sure to check the Oracle GoldenGate documentation home page on Oracle Help Center for more insight into the product.
Thanks for watching!