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 laterInformation in this document applies to any platform.
Purpose
- 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 |