---
sourceDocument: Brazil IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/it-operations-management

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Oracle check

# Oracle check {#ariaid-title1}

Release version: Brazil  
Updated September 29, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Learn about the
credential
and permission requirements for the Oracle checks `app.oracle.check-oracle-alive`, `app.oracle.metrics-oracle`, and
`util.metrics-oracle-query`.
Oracle checks require two separate accounts with different permissions.

## Oracle database account {#oracle-check__section_i2f_pw5_skc}

The database user configured in ServiceNow® must have the following permissions:

* CREATE SESSION or CONNECT
* SELECT access to the Oracle views or tables queried by the specific check that is running

{#oracle-check__ul_kpv_255_skc}{#oracle-check__table_gqb_455_skc__entry__2}

| Check | Queries |
|-|-|
| `check-oracle-alive` | `SELECT BANNER FROM v$version WHERE banner LIKE 'Oracle%'` |
| `metrics-oracle` | `SELECT TABLESPACE_NAME, sum(BYTES), sum(MAXBYTES) FROM sys.dba_data_files GROUP BY TABLESPACE_NAME` |
| `util.metrics-oracle-query` | Any custom query. The database account needs SELECT on the object targeted by that query. |
[Table 1. Checks and queries]

{#oracle-check__table_gqb_455_skc}

## Agent Client Collector agent OS account {#oracle-check__section_o3m_tw5_skc}

All three checks run sqlplus locally on the target host where the OS account runs the Agent Client Collector agent.
This
is a separate identity from the Oracle database account.  
Agent Client Collector agent OS account needs the following access:

* Execute access to `$ORACLE_HOME/bin/sqlplus`
* Access to Oracle client libraries under `$ORACLE_HOME/lib`
* Access to Oracle configuration files if applicable, such as `tnsnames.ora` and `sqlnet.ora`
{#oracle-check__ul_uzy_5w5_skc}

Depending on the Oracle installation, this means the Agent Client Collector agent OS account must be a member of `oinstall` or a database administrator.  
Configuration Prerequisites:

* sqlplus installed and reachable at `$ORACLE_HOME/bin/sqlplus`
* Oracle listener reachable from the agent host through `--host`, `default localhost`, and `--port`, default 1521
* Valid Oracle database credentials
{#oracle-check__ul_w4x_cx5_skc}
{#oracle-check__table_vty_gx5_skc__entry__2}

| Error | Cause |
|-|-|
| Permission denied or command not found on sqlplus | The Agent Client Collector agent OS account lacks access to `$ORACLE_HOME` or sqlplus. This is not a database credential problem. |
| `ORA-xxxxx` errors | Oracle-side error that points to the database account or grants and not the OS account. |
| Custom query fails only on `util.metrics-oracle-query` | Re-check SELECT grants whenever `--query` is changed to target a new object. |
[Table 2. Troubleshooting]

{#oracle-check__table_vty_gx5_skc}