The Oracle TriggerClosed The Oracle Trigger tool uses the Oracle Server trigger functionality to create a trigger on a table of a specified Oracle data source. When a specified data modification is attempted, such as, an attempt to add or delete a table row, the trigger then causes a task to run. Agent is not installed as part of the main BPA Platform installation. It must be installed on the computer hosting the Oracle database instance, on a Windows Server operating system.

The Oracle Trigger Agent requires Java runtime version 1.6 or higher, 32-bit edition, installed as a minimum. Note the following:

► If Java is not detected on the Oracle server, the installation aborts and you are prompted to install 32-bit Java runtime
► If only 64-bit Java runtime is detected, the installation aborts and you are prompted to install the 32-bit version
► If both 32- and 64-bit Java runtimes are detected, the installation continues

Installing the Oracle Trigger Agent

The Oracle Trigger Agent installer is automatically extracted to the C:\Windows\Installer directory — note that you must manually enter this path into Windows Explorer rather than navigate to it. If you are unable to access this folder, you can download the installation package from our Partner Area (a Codeless Platforms account is required to access this page).

  1. Copy the Oracle Agent Installer folder to the Oracle server.
  2. Open a command line interface.
  3. Change directory to the location of the Oracle Agent Installer directory.
  4. Run the InstallWin.bat file.
  5. When prompted, enter the hostname or IP address of the BPA Platform server:

    Oracle Agent Installation - BPA Platform Server Location

  6. By default, communication to the BPA Platform server is over port 4222. If this port is already in use on either the Oracle computer or the BPA Platform server, change this now.
  7. Enter the username and password of a BPA Platform account that has system administrator privileges. The Oracle Trigger Agent uses this account to access the BPA Platform server and client. By default, this is the Administrator account.
  8. Enter the full folder path for where the Agent is installed to. If the installer cannot find the directory, you are prompted whether to create it.
  9. Although you are prompted whether to rename the Oracle Trigger Agent, at the time of writing, this change does not persist; the Agent is always called ORAAGENT. Press enter to complete the installation.

    The Agent installer stops and starts the BPA Platform service as required. A reboot is not required to complete the installation.