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

# Deploying GermainUX Monitoring for Oracle Database: Steps and Configuration

> Deploy GermainUX monitoring for Oracle Database to monitor availability, performance, SQL, sessions, locks, storage, errors, and backups.

Components
[`Engine`](/main/germain-ux-engine)

Availability
2014.1 or later

> **[Determine the Monitoring Scope](#1-determine-the-monitoring-scope)**
>
> Pick scope before setup

> **[Start the Oracle Database Server Wizard](#5-start-the-oracle-database-server-wizard)**
>
> Set up Oracle environment

> **[Validate Database Connectivity](#8-validate-database-connectivity)**
>
> Check data source access

> **[Validate the Deployment](#11-validate-the-deployment)**
>
> Confirm monitors are live

## Overview

Deploy GermainUX monitoring for Oracle Database to monitor availability, performance, SQL, sessions, locks, storage, errors, backups, and application-specific database conditions.

> [!NOTE]
>
> Oracle Database monitoring is executed by the **GermainUX Engine** using a database connection to the monitored Oracle environment.

## 1. Determine the Monitoring Scope

Before deployment, determine whether GermainUX will monitor:

* A single Oracle Database instance
* Oracle RAC
* Individual RAC instances
* The RAC environment as a whole
* Oracle system telemetry
* Application-specific tables or data

The required database permissions depend on the selected monitoring scope.

## 2. Create an Oracle Monitoring Account

For basic monitoring of a single Oracle instance, GermainUX can use a regular Oracle Database account with **CONNECT** permissions.

More comprehensive monitoring requires SELECT permission on the Oracle system and DBA views required by the deployed monitors.

Use a dedicated monitoring account and grant only the permissions required for the selected monitoring scope.

## 3. Grant Oracle Monitoring Permissions

For deeper Oracle Database monitoring, grant the monitoring account SELECT access to the required Oracle views.

### Single Instance / RAC

| Single Instance | RAC / Multi-Instance |
| - | - |
| `V$SYSSTAT` | `GV$SYSSTAT` |
| `V$SYSTEM_EVENT` | `GV$SYSTEM_EVENT` |
| `V$SESSION` | `GV$SESSION` |
| `V$SQL` | `GV$SQL` |
| `V$SQLTEXT` | `GV$SQLTEXT` |
| `V$SYSTEM_PARAMETER` | `GV$SYSTEM_PARAMETER` |
| `V$RESOURCE_LIMIT` | `GV$RESOURCE_LIMIT` |
| `V$SQLSTATS` | `GV$SQLSTATS` |
| `V$SESSTAT` | `GV$SESSTAT` |
| `V$STATNAME` | `GV$STATNAME` |
| `V$DIAG_ALERT_EXT` | `GV$DIAG_ALERT_EXT` |
| `V$LOCKED_OBJECT` | `GV$LOCKED_OBJECT` |

Additional Oracle views used by GermainUX include:

* `V$LOG`
* `V$RECOVERY_FILE_DEST`
* `DBA_DATA_FILES`
* `DBA_TABLESPACE_USAGE_METRICS`
* `DBA_TEMP_FILES`
* `DBA_TEMP_FREE_SPACE`

Grant **SELECT** access only to the views required for the monitoring capabilities being deployed.

## 4. Application-Specific Database Access — Optional

GermainUX can also monitor other Oracle tables, including:

* System tables
* Application tables
* Business data tables
* Operational tables

Extend the monitoring account's permissions only when application-specific database monitoring is required.

Use least-privilege access.

## 5. Start the Oracle Database Server Wizard

In Germain Workspace, navigate to:

Left Menu
Wizards
Oracle Database Server

Start the Oracle Database Server Wizard.

Use the Wizard to configure the Oracle environment GermainUX will monitor.

## 6. Add Oracle Database Credentials

Navigate to:

Germain Workspace
Left Menu
Data Sources
Credentials

Add the Oracle Database monitoring credentials.

Use the dedicated monitoring account configured for the required monitoring scope.

## 7. Add Oracle Database as a Data Source

Navigate to:

Germain Workspace
Left Menu
Data Sources
Database
Add New Configuration

Configure the Oracle Database connection.

Associate the appropriate credentials and database connection information with the data source.

## 8. Validate Database Connectivity

Verify that GermainUX can connect to Oracle Database using the configured data source.

Confirm that:

* Credentials are valid
* Network connectivity is available
* Database connection succeeds
* Required Oracle views are accessible
* RAC views are accessible where applicable
* Application tables are accessible where specifically configured

Resolve connectivity or permission issues before deploying additional monitors.

## 9. Select the Monitoring Node & Engine

Oracle Database monitoring executes from a GermainUX Engine.

Configure:

**Monitoring Node** \
 The GermainUX Node from which the Engine operates.

**Engine** \
 The Engine that executes the Oracle monitor.

Ensure the selected Engine has network connectivity to Oracle Database.

## 10. Configure the Monitoring Schedule

Define how frequently the Oracle monitor should execute.

Choose the frequency according to:

* Required detection speed
* Database workload
* Query complexity
* Operational importance
* Monitoring overhead

Use high-frequency monitoring selectively for conditions requiring rapid detection.

## 11. Validate the Deployment

After deployment, verify:

* Oracle connectivity
* Monitoring-account permissions
* Oracle system-view access
* RAC access where applicable
* Monitoring Node
* Engine
* Schedule
* Expected Oracle telemetry

Verify deployed monitors in:

**Germain State**

## Next Steps

Once Oracle Database monitoring is operational, configure:

* SQL Query Monitors
* KPIs
* SLAs
* Sessions and locks
* Tablespaces and datafiles
* Redo/archive logs

> **Show all 12**
>
> * Cursors
> * Errors
> * Custom database conditions
> * Alerts
> * Automation
> * Dashboards and reports

See **Configure Monitoring for Oracle Database**.

## Get Help

> **[Contact GermainUX Support](/main/support.md)**
>
> The Germain Team can help you set this up.

> **Can't find what you need?**
>
> Search all GermainUX docs with **Ctrl + K**, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.