Syntax:

agent_config.sh|.bat AGENT_DEPLOY_LOCATION

The AGENT_DEPLOY_LOCATION can be an absolute path or a path relative to the location from where the script is running.

You must configure the Oracle GoldenGate Veridata Agent to use your database.

1. Go to the agent deployed location AGENT_DEPLOY_LOCATION.

   There is an agent.properties.sample file in this directory that contains database related properties like JDBC URL and driver.

2. Copy the agent.properties.sample file and rename to agent.properties.

3. Most of the properties defined in the file have default values. However, you must update the following properties:

   1. The server.port property is the port where the Veridata Agent listens for connection requests.

      server.port=server.port
      

      For example, server.port=7862.

   2. The database.url specifies the JDBC connection URL for the database. Samples for all supported databases are provided in the file.

      database.url=database.url
      

      For example, database.url=jdbc:oracle:thin:@localhost:1521:orcl.

   3. The server.jdbcDriver property specifies the list of JDBC driver JAR files. Sample lists for the supported databases are provided in the file.

      Use the driver corresponding to the database.url in the preceding step.

      server.jdbcDriver=<server.jdbcDriver>
      

      For example, server.jdbcDriver=ojdbc7.jar oracle.xdb_12.1.0.jar.

Go to the agent deployment location AGENT_DEPLOY_LOCATION and run following command.

$ ./agent.sh start agent.properties

Where agent.properties is the properties file that contains your database properties.

For debugging issues with the Veridata Agent deployment, run the agent_config script with an additional command line argument as follows:

Syntax:

agent_config.sh|.bat AGENT_DEPLOY_LOCATION true

When this option is true, the debug logs are printed on the screen.

On Windows platform, after installing the Oracle GoldenGate Veridata Agent, run the agent as a service. The scripts are located in AGENT_DEPLOY_LOCATION\service. The README.txt file in the service directory describes the procedure to run the agent as a service.

To install as a Windows service:

1. Go to the Oracle GoldenGate Veridata Agent installation directory.

2. Open the Set_Veridata_Agent_Env.bat file in an editor.

3. Locate the '_VERIDATA_SERVICE_NAME' property, and edit it to add a service name for the agent. The name should not contain spaces or any other special characters. Only alphabets and numbers are allowed.

4. Change the value of '_RUN_AS_SERVICE' property to true.

5. Save and close the file.

6. Open the command prompt and navigate to the directory where the agent is installed. Run the Install_veridata_Agent.bat script.

To uninstall the agent service:

1. Open the command prompt and navigate to the directory where the agent is installed. Run the Uninstall_veridata_Agent.bat script.

2. Revert changes made in the Set_Veridata_Agent_Env.bat file.

   Open the Set_Veridata_Agent_Env.bat file in an editor.

   Change the value of '_RUN_AS_SERVICE' property to false.

   Save and close the file.

To start and stop the Veridata agent:

1. Open the command prompt and navigate to the directory where the agent is installed.

2. Run one of the following commands:

   (starts the agent)

   Start_Veridata_Agent.bat 
   

   or

   Stop_Veridata_Agent.bat
   

You can reload logging information from the AGENT_ORACLE_HOME/config/odl.xml configuration file to a running agent by using the reloadLog option. The changes in the odl.xml file are put into effect on the agent. The agent must be running for this command to work.