Product manual

GFI EventsManager 4 Managing Event Sources | 90
The following Oracle Database versions are supported:
Oracle Database 9i
Oracle Database 10g
Oracle Database 11g
This section contains information about:
Pre-configuration settings for Oracle Servers event sources
Creating a new Oracle Server group
Adding a new Oracle Server event source
Pre-configuration settings for Oracle Servers event sources
Before adding Oracle Server event sources, follow the steps below on each Oracle Server instance you
want to monitor:
Pre-con-
figuration Step
Description
Step 1 Ensure the logon credentials used to connect, set audits and access the audit table has the nec-
essary permissions.
Step 2 Enable auditing on the Oracle Server by changing startup parameters. To enable auditing:
1. Startup parameters for the Oracle servers are stored in:
<Oracle Home Directory>\admin\<Oracle SID>\pfile\init.ora.
2. Locate and open the parameters file using a text editor.
3. Locate AUDIT_TRAIL parameter and change the default value to ‘db’ or ‘db_extended’ (‘db,
extended’ on latest versions of Oracle).
4. Save and restart the Oracle server.
Table 29: Oracle Server configuration stages
Adding a new Oracle Server group
To add a new Oracle Database group:
1. Click Configuration tab > Event Sources.
2. From Group Type, select Database Servers Groups.
Screenshot 59: Database Servers Groups
3. From Groups, right-click Oracle Servers and select Create group…