Category: Premium Content

Materialized View : OEM Monitoring and Alerting through Metric Extension( ME ), Incident Rule ( IR ) and Self Healing through Corrective Action( CA )

In previous posts, we have created following related posts to monitor FRA and auto backup archive logs:

  1. Create a Metric Extension (ME) to Monitor FRA Usage on OEM
  2. Create an Incident Rule for Metric Extension ( ME ) to Monitor FRA Used in OEM
  3. Use Corrective Action ( CA ) to Automate Archivelog Backup When FRA Usage is Over Threshold of Metric Extension ( ME ) in OEM

In this post, we will do the same thing for Materialized Views to monitor, alert and self heal the materialized views.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Pause and Resume Oracle Materialized View Refresh on Commit

A client wants to temporarily stop terabytes Oracle materialized views refresh for application issue diagnosing, and then resume the refresh without invalidating the materialized views.

SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Reinstall and Configure OEM Cloud Control 13c Central Agent 

For some reason, a client has to reinstall OEM central agents in a multi-OMS Oracle Enterprise Manager Cloud Control environment. Certainly the agent has been installed on the same server as the OMS.

First keep a record of the plugins deployed onto the agent already.

$emctl listplugins agent

Then uninstall the agent cleanly as per How to Deinstall OEM Agents in Oracle Enterprise Manager 13C

The next is to install the agent with required plugins deployed.

Now we need discover all WebLogic Domain targes based on the following instructions, and then all those targets will be monitored by the central agent.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

CRS-2878: Failed to restart resource ‘ora.net1.network’ CRS-2769: Unable to failover resource ‘ora.net1.network’

The following messages appear in alert.log:

...
..
.
2021-10-26 6:34:11.701 [CRSD(56455)]CRS-2878: Failed to restart resource 'ora.net1.network'
2021-10-26 6:34:11.705 [CRSD(56455)]CRS-2769: Unable to failover resource 'ora.net1.network'.
2021-10-26 6:34:11.807 [CRSD(56455)]CRS-2878: Failed to restart resource 'ora.net1.network'
2021-10-26 6:34:11.880 [CRSD(56455)]CRS-2769: Unable to failover resource 'ora.net1.network'.
...
..
.

In the mean time, there are other resources failure from scan listeners, VIPs and local listeners, etc.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Check Oracle Database Table and Index Fragmentation

The following posts demonstrated how to check fragmentations in PostgreSQL:
How to Identify Fragmentation in PostgreSQL RDS
Code to Report Table Index Schema or Database Fragmentation in PostgreSQL

This post will show how to check table and index fragmentations in Oracle database.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe