Re: Have you extra approach identifying oracle standalone ASM architecture？

 Hi Quanwen,

Have you extra approach identifying oracle standalone ASM architecture？Our
> developer thought it is difficult to acquire info from OS
>

Check local_only in /etc/oracle/ocr.loc (Linux). It is false for a cluster and true for Oracle Restart.
Various Oracle tools use the same method (DBCA, and localconfig to name a few).

Thanks,
*Mikhail Velikikh*

On Wed, 16 Aug 2023 at 02:43, Quanwen Zhao <quanwenzhao_at_gmail.com> wrote:

> 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