On May 11, 1:13 pm, Valentin Minzatu <valentinminz..._at_yahoo.com>
wrote:
> 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.
I found the Metalink note for the above script. Note: 259301.1.
Received on Fri May 11 2007 - 13:18:49 CDT
