Re: How can I tell if RAC is running?

On May 11, 1:05 pm, Mladen Gogala <mgogala.SPAM..._at_not-at-verizon.net> wrote:
> On Fri, 11 May 2007 10:00:40 -0700, Valentin Minzatu wrote:
> > Mladen, there is a new utility called crs_stat2 or along those lines
> > which display the data above in a tabular format.
>
> Why would I need it?
>
> --http://www.mladen-gogala.com

In RAC with many services you'll have scroll up and down through the list, while with that you get something like below:

HA Resource                                   Target     State
-----------                                   ------     -----
ora.node01.ASM1.asm                      ONLINE     ONLINE on node01
ora.node01.LISTENER_node01.lsnr     ONLINE     ONLINE on node01
ora.node01.gsd                           ONLINE     ONLINE on node01
ora.node01.ons                           ONLINE     ONLINE on node01
ora.node01.vip                           ONLINE     ONLINE on node01
ora.node02.ASM2.asm                      ONLINE     ONLINE on node02
ora.node02.LISTENER_node02.lsnr     ONLINE     ONLINE on node02
ora.node02.gsd                           ONLINE     ONLINE on node02
ora.node02.ons                           ONLINE     ONLINE on node02
ora.node02.vip                           ONLINE     ONLINE on node02
ora.racdb.Service1.cs                     ONLINE     ONLINE on node01
ora.racdb.Service1.qator1.sa              ONLINE     ONLINE on node02
ora.racdb.Service1.qator1.srv             ONLINE     ONLINE on node01
ora.racdb.Service2.cs                     ONLINE     ONLINE on node01
ora.racdb.Service2.qator1.sa              ONLINE     ONLINE on node02
ora.racdb.Service2.qator1.srv             ONLINE     ONLINE on node01
ora.racdb.Service3.cs                  ONLINE     ONLINE on node02
ora.racdb.Service3.qator2.sa           ONLINE     ONLINE on node01
ora.racdb.Service3.qator2.srv          ONLINE     ONLINE on node02
ora.racdb.Service4.cs                        ONLINE     ONLINE on
node02
ora.racdb.Service4.qator1.srv                ONLINE     ONLINE on
node01
ora.racdb.Service4.qator2.srv                ONLINE     ONLINE on
node02
ora.racdb.Service5.cs                    ONLINE     ONLINE on node02
ora.racdb.Service5.qator1.srv            ONLINE     ONLINE on node01
ora.racdb.Service5.qator2.srv            ONLINE     ONLINE on node02
ora.racdb.Service6.cs                            ONLINE     ONLINE on
node01
ora.racdb.Service6.qator1.sa                     ONLINE     ONLINE on
node02
ora.racdb.Service6.qator1.srv                    ONLINE     ONLINE on
node01
ora.racdb.Service7.cs                     ONLINE     ONLINE on node02
ora.racdb.Service7.qator2.sa              ONLINE     ONLINE on node01
ora.racdb.Service7.qator2.srv             ONLINE     ONLINE on node02
ora.racdb.Service8.cs                   ONLINE     ONLINE on node01
ora.racdb.Service8.qator1.sa            ONLINE     ONLINE on node02
ora.racdb.Service8.qator1.srv           ONLINE     ONLINE on node01
ora.racdb.db                                ONLINE     ONLINE on
node02
ora.racdb.qator1.inst                       ONLINE     ONLINE on
node01
ora.racdb.qator2.inst                       ONLINE     ONLINE on

(this is the output of the script for R1 - for obvious reasons I changed the real data)

It is much easier to see the status of each service than running crs_stat. Received on Fri May 11 2007 - 12:13:33 CDT