Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I tell if RAC is running?

Re: How can I tell if RAC is running?

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 11 May 2007 10:13:33 -0700
Message-ID: <1178903613.163999.144820@w5g2000hsg.googlegroups.com>


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
node02

(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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US