Re: {bb} Remote Oracle Monitoring

[Robert Herron <robert.herron@gmail.com>]

In $BBHOME/etc/bb-roracle.def, change the LISTENER_CHECK and
SIDS_CHECK to N.  This should take care of most of the issues with no
local Oracle.  You will get one ORATAB files does not exist message
that you can safely ignore.

Note:  I've never run bb-roracle on a machine that doesn't have local
Oracle databases.  The once instance that monitors remote instances
also monitors some local databases as well.  It should work, though.


On Mon, 28 Mar 2005 14:18:36 -0600, Esquivel, Vicente <Esquivelv@uhd.edu> wrote:
> Thanks that helps!
> 
> Now as for the rest of the setup does it assume you want to check a
> localhost db?  I keep getting errors about the /etc/oratab and
> bb-roracle.ksh: The default ORACLE_HOME Directory doesn't exist.  I do not
> have an oracle instance running on my BB server I just want to monitor
> remote oracle instances.  Can anyone help?
> 
> Thanks
> Vince
> 
> -----Original Message-----
> From: owner-bb@bb4.com [mailto:owner-bb@bb4.com] On Behalf Of Robert Herron
> Sent: Monday, March 28, 2005 11:50 AM
> To: bb@bb4.com
> Subject: Re: {bb} Remote Oracle Monitoring
> 
> Yes, it is possible.  I have one unix system that monitors several remote
> (on Windows NT) databases and the ORADB is listed with the NT host's network
> tests (ping, etc) .
> 
> In the $BBHOME/etc/bb-roracle.ids file, the 6th column allows you to specify
> the host underwhich the results are reported.  Using your bb-host snippet,
> simply put st-hr1-DEVL and st-hr1-MODL in the appropriate column 6 of
> bb-roacle.ids.  For example:
> 
> -----------------------------
> #bb-roracle.ids
> #type       SID        userid  passwd   test      log-as-host
> REMOTE giddb     bb       pwd        aBEfjk   gissvr.domain.com
> 
> ------------------------------
> #bb-hosts
> 10.10.10.111      gissvr.domain.com
> 
> On Mon, 28 Mar 2005 10:47:31 -0600, Esquivel, Vicente <Esquivelv@uhd.edu>
> wrote:
> > I looked over the README and the config files, but I was wondering how
> > I get it to list under an existing entry on my bb-hosts.
> > Here is the example the script comes with:
> >  #
> > # THE BIG BROTHER HOSTS FILE Version:0.02 # # # Example oracle config
> > for 2 servers with 4 databases
> >
> > page Oracle Oracle-Status
> > group-only orasys|oradb
> > 168.168.8.140   st-hr1 # noconn
> > 168.168.8.140   st-hr1-DEVL # noconn
> > 168.168.8.140   st-hr1-MODL # noconn
> > 168.168.8.248   st-db7 # noconn
> >
> > I want to be able to do display it on existing entry and add a column
> > for the Roracle check with say the name of the database or just "oracle"
> >
> > 168.168.8.140   servername # ssh oracle
> >
> > Is this possible?
> >
> > Thanks
> > Vince
> >
> >
> > -----Original Message-----
> > From: owner-bb@bb4.com [mailto:owner-bb@bb4.com] On Behalf Of Robert
> > Herron
> > Sent: Monday, March 28, 2005 9:18 AM
> > To: bb@bb4.com
> > Subject: Re: {bb} Remote Oracle Monitoring
> >
> > Check out Roracle-2-6.tar.gz on www.deadcat.net.  It supports
> > monitoring remote instances and works quite well.
> >
> > On Mon, 28 Mar 2005 08:09:49 -0600, Esquivel, Vicente
> > <Esquivelv@uhd.edu>
> > wrote:
> > >
> > > Hello fellow Brothers,
> > >
> > > Can anyone tell me if there is an Oracle Remote monitoring script
> > > that they are using.  I want to monitor oracle instances that are
> > > running on other machines from my main bb server.
> > >
> > > Thanks everyone
> > > Vince
> > >
> > >
> > >
> > >
> >
> > --
> >
> > Robert Herron
> > robert.herron@gmail.com
> > --
> > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
> > To unsubscribe from this list, or to subscribe to the bb-digest list
> > send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
> > subscribe bb-digest in the BODY of the message.
> > --
> > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
> > To unsubscribe from this list, or to subscribe to the bb-digest list
> > send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
> > subscribe bb-digest in the BODY of the message.
> >
> 
> --
> 
> Robert Herron
> robert.herron@gmail.com
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
> To unsubscribe from this list, or to subscribe to the bb-digest list send
> e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or- subscribe
> bb-digest in the BODY of the message.
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
> To unsubscribe from this list, or to subscribe to the bb-digest list
> send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
> subscribe bb-digest in the BODY of the message.
> 


-- 


Robert Herron
robert.herron@gmail.com
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
To unsubscribe from this list, or to subscribe to the bb-digest list
send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
subscribe bb-digest in the BODY of the message.