Database Administration (MOSC)

MOSC Banner

Using X$DBGALERTEXT to monitor alert log in RAC (19.19)

Hello

We have a 2 node 19.19.0.0.0 RAC database and we are trying to use the X$DBGALERTEXT but when we query it it seems it only reports for the instance we are connected to as it is showing the messages only for INST_ID 1 or 2 whichever instance we are connected to

This means we will need to run this monitor / alert process on both nodes instead of just one

Can someone shed some light into it and share your feedback and guidance as to how you are using the X$DBGALERTEXT to monitor for alert log errors in a RAC environment?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center