Monitoring Oracle standby databases in Applications Manager
- Do we support Oracle Standby Database monitoring?
- Yes, we do.
- How to connect to the Standby/Standalone Oracle database which is in MOUNTED mode?
- To connect to an Oracle database in STANDBY MOUNTED or normal MOUNTED mode, you must use the sysdba user (Ref Oracle doc).
- Note that some metrics will not be available because certain views cannot be queried when the database is in mounted state.
- How to check the database mode?
Connect the Oracle DB and execute the following query.
- select OPEN_MODE from v$database
- Which metrics will not be monitored if the database is in MOUNTED mode?
- The following metrics will not be monitored for a MOUNTED database since some views can't be executed in MOUNTED database :
- Overview Tab: Tablespaces with least free bytes, Database Status, Database Size, Free Space, Invalid/Unusable Index Count, Oracle DB Links, Invalid Objects, Invalid/Unusable Indexes.
- Tablespace Tab: Tablespace Details, Tablespace Status, Performance of Data Files, Objects Approaching MAX Extents.
- Session Tab: Users.
- Rollback & Corrupted Blocks Tab: Rollback Segment, Blocks Corrupted.
- Lock Tab: Sessions under lock/Session holding locks, Sessions waiting for a lock, Lock Statistics.
- Jobs & Backup Tab: Scheduled Jobs Details, Running Backup Jobs Count.
- Attached below is the Overview page screenshot of the STANDBY database. Highlighted details will not be monitored in STANDBY MOUNTED database.
New to ADSelfService Plus?
Related Articles
How to import certificates for monitoring Oracle database with SSL authentication?
For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...Discrepancy with Oracle DB Tablespace information shown in Applications Manager
By default, Oracle DB Tablespace statistics is calculated along with its auto-extensible size in Applications Manager. If you want to calculate Tablespace statistics without considering the Auto Extend option, navigate to Settings -> Performance ...Monitoring Capacity Entitlement in Applications Manager
Applications Manager is equipped to monitor processor capacity entitlement issues. To measure the average entitlement value during peak production times with a higher workload, you can use the following command: lparstat 1 20 > /tmp/apm_physc.txt && ...Self monitor Applications Manager using Real User Monitoring
We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...ManageEngine Applications Manager High Availability setup with dual database (MySQL).
Apart from the Failover setup, which uses a single database and dual Application Server, we also support a failover with dual database and Application Server. Failover support requires you to configure Applications Manager Secondary (Standby server) ...