Have you extra approach identifying oracle standalone ASM architecture?
Date: Wed, 16 Aug 2023 09:41:20 +0800
Message-ID: <CABpiuuQg5-jYf5FD-bKQ=PVAdBE0T9fTU2garOH0VUe=JToGpw_at_mail.gmail.com>
Hello my folks and friends,
A couple of day ago my customer's oracle database has encountered
frequently generating tracle file every minute and the oracle is standalone
ASM with 19.3, afterwards I've discovered this MoS article *Doc ID
2601897.1* -
*https://support.oracle.com/knowledge/Oracle%20Database%20Products/2601897_1.html*
<https://support.oracle.com/knowledge/Oracle%20Database%20Products/2601897_1.html>
and
have to disable checking view v$asm_ fot that oracle database from our
monitor software. But oracle said before 19.9 is able to reproduce this
issue and I thought it should be a bug.
Now I am eager to add identifying the architecture of oracle standalone ASM in our monitor software the following either one is my solution:
- checking v$asm_disk whether it has data or not and parameter cluster_database whether it is FALSE or TRUE;
- checking grid user if it exists or not from OS, ASM instance processes if they exists or not from OS, parameter cluster_database whether it is FALSE or TRUE;
Have you extra approach identifying oracle standalone ASM architecture?Our developer thought it is difficult to acquire info from OS but if using SQL with v$asm is possible to have side effect for the oracle database.
If another good ideas I'm very appreciated.
Best Regards
Quanwen Zhao
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 16 2023 - 03:41:20 CEST