Shulou(Shulou.com)05/31 Report--

This article mainly introduces Oracle how to query the current crs/has self-startup status, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Preface

We know that in some downtime test scenarios, it is necessary to artificially disable the self-startup of crs/has to prevent repeated restarts of the host from affecting the database cluster.

Using the crsctl disable/enable crs command, you can disable / enable the self-startup of crs, but there is no command to view the current self-startup status. Although the command can be executed repeatedly, it is worrying not to see that the actual state is always returned.

I tried several Oracle RAC versions in the Linux test environment:

Oracle RAC 10.2.0.5

Oracle RAC 11.2.0.4

Oracle RAC 12.1.0.2

Found that for Oracle RAC 10.2.0.5:

When using the root user crsctl disable/enable crs, what is changed is the value of this file:

10.2.0.5 [root@rac1-server ~] # / s01/oracle/product/10.2.0/crs_1/bin/crsctl disable crs [root@rac1-server ~] # more / etc/oracle/scls_scr/rac1-server/root/crsstart disable [root@rac1-server ~] # / s01/oracle/product/10.2.0/crs_1/bin/crsctl enable crs [root@rac1-server ~] # more / etc/oracle/scls_scr/rac1-server/root/crsstart enable

For Oracle RAC 11.2.0.4 and Oracle RAC 12.1.0.2:

When using the root user crsctl disable/enable crs, what is changed is the value of this file:

11.2.0.4 [root@db01 ~] # / opt/app/11.2.0/grid/bin/crsctl disable crsCRS-4621: Oracle High Availability Services autostart is disabled. [root@db01 ~] # more / etc/oracle/scls_scr/db01/root/ohasdstr disable [root@db01 ~] # / opt/app/11.2.0/grid/bin/crsctl enable crsCRS-4622: Oracle High Availability Services autostart is enabled. [root@db01 ~] # more / etc/oracle/scls _ scr/db01/root/ohasdstr enable--12.1.0.2 [root@oemapp1 ~] # / app/12.1.0.2/grid/bin/crsctl disable crsCRS-4621: Oracle High Availability Services autostart is disabled. [root@oemapp1 ~] # more / etc/oracle/scls_scr/oemapp1/root/ohasdstr disable [root@oemapp1 ~] # / app/12.1.0.2/grid/bin/crsctl enable crsCRS-4622: Oracle High Availability Services autostart is enabled. [root@oemapp1 ~ ] # more / etc/oracle/scls_scr/oemapp1/root/ohasdstr enable

Basically, it can be identified as version 10.2.0.5, which corresponds to the value of the crsstart file. Versions 11.2.0.4 and 12.1.0.2 both correspond to the file value of ohasdstr.

For mainstream small machine environments:

For AIX systems, it is no different from the configuration file path of Linux

For SUN Solaris and HP-UX, you need to note that the path to the configuration file is different (/ etc/oracle/.. -> / var/opt/oracle/..):

-- 10.2.0.5/var/opt/oracle/scls_scr/$hostname/root/crsstart--11.2.0.4/var/opt/oracle/scls_scr/$hostname/root/ohasdstr Thank you for reading this article carefully. I hope the article "how to query the current crs/has self-startup status of Oracle" shared by the editor will be helpful to you. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.