Oracle XML file agent installation and configuration (UNIX, Windows, AIX)
You can use FortiDB's Oracle XML file agent to monitor multiple Oracle databases. When it is active, the agent periodically transmits Oracle's audit log data to FortiDB for further processing.
To configure and run the Oracle XML file agent
- Obtain login credentials for a user that has read and write access for the Oracle database audit log directories that you want to monitor.
- Ensure that Java Virtual Machine (JVM) 1.6 or greater is installed, the JAVA_HOME environment variable is correctly configured, and that the bin directory is first on the execution path.
- Complete the Oracle target database pre-configuration. See Oracle target database pre-configuration.
- Configure a target that connects to the Oracle database. See Adding (or modifying) a target connection.
- As the user with the credentials specified earlier, log in to the machine where the Oracle database is located, and then unpack a copy of the Oracle XML file agent installer into a directory.
- Copy the
agent.properties.samplefile from agent'sdocdirectoryto the agent'sconfdirectory, and then change the file name toagent.properties. - Open the
agent.propertyfile in a text editor and edit the following values: - If Oracle is installed on Windows, do the following:
- In the agent's
bindirectory, execute the following command: - fdbagent install
- In the Windows Services Control Panel, configure the FortiDB
Database Monitoring Agentto run using the same login credentials that you used to unpack the FortiDB agent installation file.
- In the agent's
- To start the FortiDB agent, do one of the following:
- For Windows, Linux, or Solaris: In the agent's bin directory, execute the following command:
$ fdbagent start- To stop the agent, execute the following command:
$ fdbagent stop
- For other platforms (for example, AIX):
- In the agent's
bindirectory, execute the following command: $ nohup ./fdbagentapp &
- In the agent's
- For Windows, Linux, or Solaris: In the agent's bin directory, execute the following command:
- Configure target monitoring for the database where the agent is installed. For detailed instructions, see Configuring Oracle monitoring.
Using the SQL*Plus utility, run show parameters audit_file_dest to view the location of the Oracle database audit directory.
If Oracle is installed on Windows, ensure that the user is a member of the Administrators group. You can remove the user from this group after installation is complete.
| Parameter | Description | Required? |
|---|---|---|
| agentType | Enter ORA_XML. |
Yes |
| brokerAddress | Enter IP address or resolvable host name for FortiDB. | Yes |
| brokerPort |
Enter the port FortiDB uses to listen for transmissions from the agent. The default value is 9116. |
No |
| agentDBAddress |
Enter the IP address of the target database. Use the same value that is specified by the target configuration (General tab). |
Yes |
| agentDBPort |
Enter the listening port on the target database. Use the same value that is specified by the target configuration (General tab). |
Yes |
| pollingInterval |
Enter a positive integer that specifies the polling interval in milliseconds. For the Oracle XML file agent, the default value is 60000 (60 seconds). |
No |
| removeAuditFile | Not used for Oracle databases. | No |