Configure Replicat to Apply to an Autonomous Database

This section assumes that the source environment is already configured and provides the steps required to establish replication in the Oracle Autonomous Database environment.

In the Oracle GoldenGate instance, you need to complete the following:

Follow the steps given in Prerequisites for Configuring Oracle GoldenGate Replicat to an Autonomous Database.
Follow the steps given in Configure Oracle GoldenGate Replicat for an Autonomous Database.
Follow the steps given in Obtain the Autonomous Database Client Credentials.
Log into the server where Oracle GoldenGate was installed.
Transfer the credentials zip file that you downloaded from Oracle Autonomous Database to your Oracle GoldenGate instance.
In the Oracle GoldenGate instance, unzip the credentials file into a new directory /u02/data/adwc_credentials. This is your key directory.
To configure the connection details, open your tnsnames.ora file from the Oracle client location in the Oracle GoldenGate instance.
```
cd /u02/data/adwc_credentials
ls
tnsnames.ora
```
Edit the tnsnames.ora file in the Oracle GoldenGate instance to include the connection details available in the tnsnames.ora file in your key directory (the directory where you unzipped the credentials zip file downloaded from Oracle Autonomous Database).
```
Sample Connection String
graphdb1_low = (description= 
                (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb-preprod.us-phoenix-1.oraclecloud.com))
                (connect_data=(service_name=okd2ybgcz4mjx94_graphdb1_low.adb.oraclecloud.com))
                (security=(ssl_server_cert_dn="CN=adwc-preprod.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))
```
If Replicat becomes unresponsive due to a network timeout or lost connection, then you can add the following into the connection profile in the tnsnames.ora file:
```
(DESCRIPTION =  (RECV_TIMEOUT=120)   (ADDRESS_LIST =
      (LOAD_BALANCE=off)(FAILOVER=on)(CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = adb-preprod.us-phoenix-1.oraclecloud.com)(PORT = 1522))
```
Note:
The tnsnames.ora file provided with the credentials file contains three database service names identifiable as:
```
ADWC_Database_Name_low
ADWC_Database_Name_medium
ADWC_Database_Name_high
```
For Oracle GoldenGate replication, use ADWC_Database_Name_low.
To configure the wallet, create a sqlnet.ora file in the Oracle client location in the Oracle GoldenGate instance.
```
cd /u02/data/oci/network/admin
ls
sqlnet.ora tnsnames.ora
```

Edit this sqlnet.ora file to include your key directory.

WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/u02/data/adwc_credentials"))) 
SSL_SERVER_DN_MATCH=yes

Use GGSCI to log into the Oracle GoldenGate deployment.
Create a credential to store the GGADMIN user and password for the Replicat to use. For example:
```
ADD CREDENTIALSTORE ALTER CREDENTIALSTORE ADD USER ggadmin@databasename_low PASSWORD complex_password alias adb_alias
```
Add and configure a Replicat to deliver to Oracle Autonomous Database. For setting up your Replicat and other processes, see Add a Replicat.
The following example creates a Replicat (required to replicat to an Oracle Autonomous Database) called rauto, and instructs it to begin now.
```
ADD REPLICAT rauto, PARALLEL INTEGRATED, EXTTRAIL ./dirdat/et
```
If you want to replicate HR.EMP into COUNTRY.EMPLOYEE, then your map statement would look like this:
```
MAP HR.EMP, TARGET COUNTRY.EMPLOYEE;
```
Note:
You can use classic Replicat, coordinated Replicat, and parallel Replicat in non-integrated mode. Parallel Replicat in integrated mode is also supported for Oracle Autonomous Database.
You can now start your Replicat and perform data replication to the Autonomous Database. Here's an example:
```
START REPLICAT rauto
```
Note:

Oracle Autonomous Database times out and disconnects the Replicat when it is idle for more than 60 minutes. When Replicat tries to apply changes (when it gets new changes) after being idle, it encounters a database error and abends. Oracle recommends that you configure Oracle GoldenGate with the AUTORESTART profile to avoid having to manually restart a Replicat when it times out.