RE: {bb} Remote Oracle Monitoring

["Larry.Barber@usda.gov" <Larry.Barber@usda.gov>]

I assume you are installing this on some kind of Linux? I have been
trying to do the same thing, and saw this same error. The root cause of
this problem, and others you will run into, is that most Linus distros
don't ship with a real ksh, but an imitation called the "public domain
ksh", which has several limitation that the real ksh doesn't have. It
doesn't do floating point, and at least some versions have a bug that
treats the inside of a while loop as a separate scope. This latter
"feature" is what is probably causing your problem below, it is
"forgetting" the name of the host. The "filename" should be something
like hostname.testname. I installed a real ksh from the
http://www.kornshell.com/ site and most of the problems went away. I'm
still not running perfectly, but I don't know if the problem is with the
script or the database. 

Thanks,
Larry Barber

On Mon, 2005-03-28 at 17:01 -0600, Esquivelv@uhd.edu wrote:
> I am seeing this error now...can anyone shed some light into what I
> need to 
> be looking for?
> 
> Mon Mar 28 16:58:39 2005 bbd INVALID FILENAME IN status
> MESSAGE: .oradb 
> 
> Thanks everyone 
> Vince 
>  
> 
> -----Original Message----- 
> From: owner-bb@bb4.com [mailto:owner-bb@bb4.com] On Behalf Of
> Esquivel, 
> Vicente 
> Sent: Monday, March 28, 2005 2:19 PM 
> To: 'bb@bb4.com' 
> Subject: RE: {bb} Remote Oracle Monitoring
> 
> 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. 
> -- 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-
> = 
> 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.