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

Greets !
Wouldn't a properly maintained 'oratab' file answer the question in a comprehensive fashion?

A single instance HAS installation should have an entry for '+ASM'.

A RAC instance with a CRS installation should have an entry for '+ASM[1...99]' (assuming you don't have any 100 node or larger clusters) and are indeed using ASM for your shared storage requirement.

Checking for running processes such as PMON via the 'ps -ef | grep pmon' command at the OS level can tell you whether or not an ASM instance is running, but not if one SHOULD be running.

Merely the existence of an OS user named 'grid' is not evidence of whether or not ASM is configured and should be running. Someone could have created a user named grid for another purpose like monitoring or managing print queues. They also could have installed the infrastructure layer using the same user as the oracle database binaries (typically user oracle,) or another username.

The installation of the HAS infrastructure IS a requirement for ASM. But that requirement is NOT bidirectional.

Just because the HAS stack has been installed, does NOT indicate ASM instance has been configured. You can certainly install the HAS stack merely for its high availability features, such as monitoring instances and restarting in the event of instance crashes. Your databases could surely utilize local files stems, or even NFS.

If anything stated is inaccurate I am counting on the list to let us know.

Doug

On Tue, Aug 15, 2023, 6:42 PM 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