Deploying GermainUX Monitoring for Oracle Database: Steps and Configuration

📡 Deploy Monitoring for Oracle Database

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

📋 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

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

• Cursors

• Errors

• Custom database conditions

• Alerts

• Automation

• Dashboards and reports

See Configure Monitoring for Oracle Database.

ℹ️ Get Help

The Germain Team can help you set this up. Contact GermainUX Support.