Have you extra approach identifying oracle standalone ASM architecture?

From: Quanwen Zhao <quanwenzhao_at_gmail.com>
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-l
Received on Wed Aug 16 2023 - 03:41:20 CEST

Original text of this message