How To Check Oracle ASM Instance

 

It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and the asm instance’s alert log file should be examined.

You can collect the necessary information by using the following script. With this information, you can observe whether everything is OK.

You must connect to the ASM instance and run the script. The script will produce an output of /tmp/asmdebug.our. You can change the location and name of this file from the spool line.

You can connect to the ASM instance as follows and run the script.

 

The script contents are as follows. You can run the following file by adding the below script into it.

/home/oracle/asmdebug.sql

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *