> ## Documentation Index
> Fetch the complete documentation index at: https://docs.honeycomb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle Database

<Badge className="hny-badge-enterprise-addon" stroke>Ent+</Badge>

<Note>
  This feature is available as an add-on for the [Honeycomb Enterprise plan](https://www.honeycomb.io/pricing/).
  Please contact your Honeycomb account team for details.
</Note>

## Supported Platforms

| Platform | Metrics | Logs | Traces |
| :------- | :------ | :--- | :----- |
| Linux    | ✓       | ✓    |        |
| Windows  | ✓       | ✓    |        |
| macOS    | ✓       | ✓    |        |

## Metrics Requirements

To collect metrics from OracleDB, a user with `SELECT` access to the relevant views is required. To create a new user with those permissions, run the following SQL script as a user with sufficient permissions connected to the Oracle DB instance as SYSDBA or SYSOPER.

```sql theme={}
  -- Create the monitoring user "bindplane"
  CREATE USER bindplane IDENTIFIED BY <authentication password>;

  -- Grant the "bindplane" user the required permissions
  GRANT CONNECT TO bindplane;
  GRANT SELECT ON SYS.GV_$DATABASE to bindplane;
  GRANT SELECT ON SYS.GV_$INSTANCE to bindplane;
  GRANT SELECT ON SYS.GV_$PROCESS to bindplane;
  GRANT SELECT ON SYS.GV_$RESOURCE_LIMIT to bindplane;
  GRANT SELECT ON SYS.GV_$SYSMETRIC to bindplane;
  GRANT SELECT ON SYS.GV_$SYSSTAT to bindplane;
  GRANT SELECT ON SYS.GV_$SYSTEM_EVENT to bindplane;
  GRANT SELECT ON SYS.V_$RMAN_BACKUP_JOB_DETAILS to bindplane;
  GRANT SELECT ON SYS.V_$SORT_SEGMENT to bindplane;
  GRANT SELECT ON SYS.V_$TABLESPACE to bindplane;
  GRANT SELECT ON SYS.V_$TEMPFILE to bindplane;
  GRANT SELECT ON SYS.DBA_DATA_FILES to bindplane;
  GRANT SELECT ON SYS.DBA_FREE_SPACE to bindplane;
  GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to bindplane;
  GRANT SELECT ON SYS.DBA_TABLESPACES to bindplane;
  GRANT SELECT ON SYS.GLOBAL_NAME to bindplane;
```

## Configuration Table

| Parameter             | Type                | Default                                                                     | Description                                                                   |
| :-------------------- | :------------------ | :-------------------------------------------------------------------------- | :---------------------------------------------------------------------------- |
| telemetry\_types      | `telemetrySelector` | `["Logs", "Metrics"]`                                                       | Choose Telemetry Type.                                                        |
| audit\_log\_path      | `strings`           | "/u01/app/oracle/product/*/dbhome\_1/admin/*/adump/\*.aud"                  | File paths to audit logs.                                                     |
| enable\_alert\_log    | `bool`              | true                                                                        |                                                                               |
| alert\_log\_path      | `strings`           | "/u01/app/oracle/product/*/dbhome\_1/diag/rdbms/*/\_/trace/alert\_\_.log"   | File paths to alert logs.                                                     |
| enable\_listener\_log | `bool`              | true                                                                        |                                                                               |
| listener\_log\_path   | `strings`           | "/u01/app/oracle/product/*/dbhome\_1/diag/tnslsnr/*/listener/alert/log.xml" | File paths to listener logs.                                                  |
| start\_at             | `enum`              | end                                                                         | Start reading the file from the 'beginning' or 'end'.                         |
| host                  | `string`            | localhost                                                                   | Host to scrape metrics from.                                                  |
| port                  | `int`               | 1521                                                                        | Port of the host to scrape metrics from.                                      |
| username\*            | `string`            |                                                                             | Database user to run metric queries with.                                     |
| password              | `string`            |                                                                             | Password for user.                                                            |
| sid                   | `string`            |                                                                             | Site Identifier. One or both of sid or service\_name must be specified.       |
| service\_name         | `string`            |                                                                             | OracleDB Service Name. One or both of sid or service\_name must be specified. |
| wallet                | `string`            |                                                                             | OracleDB Wallet file location (must be URL encoded).                          |
| collection\_interval  | `int`               | 60                                                                          | Sets how often (seconds) to scrape for metrics.                               |
| enable\_audit\_log    | `bool`              | true                                                                        | Enable to collect audit logs.                                                 |