My Oracle Support Banner

Troubleshooting the RUEI repository database (Doc ID 1574368.1)

Last updated on JANUARY 19, 2023

Applies to:

APM - Application Performance Management - Version 12.1.0.0.0 and later
Information in this document applies to any platform.

Purpose

  1. Oracle Real User Experience Insight (RUEI) relies heavily on the repository database for processing, reporting and configuration operations. This note will provide information related to the repository database of RUEI.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Architecture
 Database versions
 Connection details and files
 Database Side Environement Variables
 RUEI Reporter Server Environment Variables
 RUEI side database connection files
 How to test connection to the repository database?
 Check the Database listener status
 Connect to the Database locally using SQLPlus
 Verify RUEI connectivity to the database
 Standard linux OS connectivity 
 ping
 nslookup
 telnet
 Connect from RUEI with the SQLPlus client with password (optional)
 Connect from RUEI with the SQLPlus client using the wallet files
 RUEI installation for single Instance or RAC databases.
 Single instance database local to the RUEI reporter server.
 Single instance database remote from the RUEI reporter server.
 RAC database local to RUEI Reporter server.
 RAC database remote from the RUEI reporter server.
 How to install RUEI with a cluster database?
 Database administration operations for RUEI repository
 Migrating an existing RUEI repository database to a new database server.
 Database backup and restore
 Resetting the password of the RUEI database schema 
 Adding the Enterprise Manager (EM) Credentials to the wallet when the RUEI database is remote
 Moving datafiles for the RUEI repository database
 Multiple RUEI schema in a single database instance
 How to handle installations for processing engine database and reporter database not having the same database username?
 Creating an AWR report
 Known Issues
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.