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

Thank you so much, everybody!

Douglas, you're absolutely right. grid user is commonly conventional to be created on OS but not must to do this.

Mikhail, the method checking local_only in /etc/oracle/ocr.loc (Linux) is very cool, yes, it's real to identify Oracle standalone ASM or RAC architecture.

Best Regards
Quanwen Zhao

Mikhail Velikikh <mvelikikh_at_gmail.com> 于2023年8月16日周三 23:25写道：

> 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