Oracle GoldenGate – ReverseProxySettings Application and Configuration

An Oracle GoldenGate MA installation includes the ReverseProxySettings application in the $OGG_HOME/lib/utl/reverseproxy/directory.
You can see the list of options available with the application, using the -help command i.e. $OGG_HOME/lib/utl/reverseproxy/ReverseProxySettings –help
This application can generates a configuration file for a reverse proxy server.
The ReverseProxySettings application has two additional parameters in Oracle GoldenGate version 12.3.0.1 or later:
* -P : Password for a Service Manager account.
* -u : Name of the Service Manager account to use.
These values are used when connecting to the Service Manager and are required when authentication is enabled.

Basic Steps to Configure a Reverse Proxy

  1. Create GoldenGate deployments.
  2. Run the utility to create the settings file for Nginx: $OGG_HOME/lib/utl/reverseproxy/ReverseProxySettings -u adminid -P admin password -o ogg.conf http://localhost:9100
  3. Replace the existing Nginx configuration with the configuration required for MA deployment: sudo mv ogg.conf /etc/nginx/conf.d/
  4. Create self-signed certificate for Nginx: sudo sh /etc/ssl/certs/make-dummy-cert /etc/nginx/ogg.pem
  5. Test the new Nginx configuration using: sudo nginx -tnginx
  6. As root, reload and restart Nginx and the new configuration: sudo nginx -s reload
  7. Use cURL to verify that reverse proxy is working: curl -sv ….

Note: If the deployments associated with the target Service Manager change, the Nginx configuration file must be re-generated and reloaded.

 

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments