Oracle by Example brandingConnecting the Oracle GoldenGate Veridata Agent to Autonomous Data Warehouse

section 0Before You Begin

This tutorial describes how to connect the Oracle GoldenGate Veridata to Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) by using the Oracle Wallet.

Background

For proof-of-concept, you will install everything on one host. In a production scneario it would likely be three or four separate hosts: source database, target database, and the repository database with WebLogic Server installed. After completing this OBE, you might want to take more GoldenGate training and/or more WebLogic training.

Java applications require Java Key Store (JKS) or Oracle wallets to connect to ATP or ADW. There are two methods in which the Oracle GoldenGate Veridata can be connected to Autonomous Data Warehouse:

  • Using Java Key Stores
  • Using Oracle Wallet

Note: This tutorial is for using the Oracle Wallet only. For using Java Key Sores (JKS), see Java Connectivity with Autonomous Database (ATP or ADW)

What Do You Need?

section 1 Setting up the Oracle Wallet and Oracle GoldenGate Veridata Agent

To set up Oracle Wallet and the Oracle GoldenGate Veridata Agent:

  1. Ensure that you have downloaded the Wallet_ADW20190410NS.zip from the ADW/ATP console.
  2. Unzip the wallet in a location:

    -bash-4.2$ unzip Wallet_ADW20190410NS.zip

    Archive: Wallet_ADW20190410NS.zip

    inflating: cwallet.sso

    inflating: tnsnames.ora

    inflating: truststore.jks

    inflating: ojdbc.properties

    inflating: sqlnet.ora

    inflating: ewallet.p12

    inflating: keystore.jks

    -bash-4.2$

  3. Add following lines in sqlnet.ora:

    WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="AGENT_DEPLOY_LOCATION/wallet")))

    SSL_SERVER_DN_MATCH=yes

    SQLNET.USE_HTTPS_PROXY=on

    bequeath_detach=true

    SQLNET.ALLOWED_LOGON_VERSION=8

  4. Remove the comment for the following line in ojdbc.properties:

    oracle.net.wallet_location=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=${TNS_ADMIN})))

  5. Copy the jdbc 18.3 jars in Oracle GoldenGate Veridata Agent installed location.
  6. Point the Veridata Agent to pick the jdbc 18.3 jars with the following entries in agent.properties

    7. server.jdbcDriver=ojdbc8.jar ucp.jar oraclepki.jar osdt_core.jar osdt_cert.jar

    server.driversLocation = AGENT_DEPLOY_LOCATION/drivers

  7. Change the database url to: database.url=jdbc:oracle:thin:@adw20190410ns_low?TNS_ADMIN= AGENT_DEPLOY_LOCATION/wallet.
  8. Ensure that TNS_ADMIN points to the location where the Oracle wallet was unzipped earlier, by using the following syntax: jdbc:oracle:thin:@{db alias in tnsnames.ora}?TNS_ADMIN={location of the tnsnames.ora of the wallet}.
  9. Start the agent by running the command: -bash-4.1$ ./agent.sh run.
  10. Connect to the Agent through the Oracle GoldenGate Veridata Server.

section 2 Adding Proxy Information (Optional Topic)

To add proxy information:

  1. Replace the Oracle proxy and port in below example with your own (https_proxy=www-proxy-hqdc.us.oracle.com)(https_proxy_port=80). For example:

    adw20190410ns_low = (description= (address=(https_proxy=www-proxy-hqdc.us.oracle.com)(https_proxy_port=80)(protocol=tcps)

    (port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data= (service_name=n2yg3pftwi1lovg_adw20190410ns_low.adwc.oraclecloud.com))(security=(ssl_server_cert_dn=

    "CN=adwc.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) )

more informationWant to Learn More?