Linux-UNIX: Oracle Unified Auditing parameters
These parameters define the Oracle Unified Auditing connection between the S-TAP and the SQL server.
These parameters are stored in the individual [SQLC_<integer>] sections of the S-TAP properties
file, guard_tap.ini. There can be multiple sections in a properties file, each
describing one connection for pulling data from a database, which is used by this S-TAP.
Note: The
password can be defined only with the API command store_sql_credentials.
| GUI | guard_tap.ini | Default value | Description |
|---|---|---|---|
| DB type | db_type | Required. The type of data monitored repository. Valid value:
|
|
| Instance name | instance | Required. service_name that specifies the connection identifier in the tnsnames.ora that is used to connect to the database. | |
| Data pull interval (sec.) | data_pull_interval | 30 | Frequency, in seconds, of S-TAP polls of the audit table that looks for new data. |
| User name | username | Required. User name of a user with access to the database and permission to read entries in the unified audit table. | |
| User role | role | Role for user with access to the database and permission to read entries in the audit table, for example, for a user name “sys”, you might specify a user role of “sysdba” | |
| Data pull number of rows | data_pull_rows | 100 | The number of rows to attempt to pull in one iteration. Each check interval, S-TAP attempts to pull the full amount of new data to the collector. Use this parameter to tune the amount of memory that is used by the S-TAP versus impact on the database for collecting data. It is recommended to leave it at the default value. |
| Timeout (sec.) | timeout | 300000 | Time, in seconds, to allow the database to respond. |