Connecting to target databases : Pre-configuration for monitoring target databases : Oracle target database pre-configuration : Oracle XML file agent installation and configuration (UNIX, Windows)
 
Oracle XML file agent installation and configuration (UNIX, Windows)
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
1. Obtain login credentials for a user that has read and write access for the Oracle database audit log directories that you want to monitor.
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.
2. 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.
3. Complete the Oracle target database pre-configuration. See “Oracle target database pre-configuration”.
4. Configure a target that connects to the Oracle database. See “Adding (or modifying) a target connection”.
5. 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 FortiDB Oracle XML file agent installer into a directory.
6. Copy the agent.properties.sample file from agent's doc directory to the agent's conf directory, and then change the file name to agent.properties.
7. Open the agent.property file in a text editor and edit the following values:
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
8. If Oracle is installed on Windows, do the following:
a. In the agent's bin directory, execute the following command:
fdbagent install
b. In the Windows Services Control Panel, configure the FortiDB Database Monitoring Agent to run using the same login credentials that you used to unpack the FortiDB agent installation file.
9. 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:
In the agent's bin directory, execute the following command:
$ nohup ./fdbagentapp &
10. Configure target monitoring for the database where the agent is installed. For detailed instructions, see “Configuring Oracle monitoring”.