[xymon] bb-roracle.ksh

[Gore, David W]

> -----Original Message-----
> From: Buchan Milne
> Sent: Friday, September 17, 2010 08:30
> To: xymon at xymon.com
> Cc: Gore, David W
> Subject: Re: [xymon] bb-roracle.ksh
> 
> On Thursday, 16 September 2010 12:12:28 Gore, David W wrote:
> > > -----Original Message-----
> > > From: Buchan Milne [mailto:bgmilne at staff.telkomsa.net]
> > > Sent: Thursday, September 16, 2010 11:01
> > > To: xymon at xymon.com
> > > Cc: Gore, David W
> > > Subject: Re: [xymon] bb-roracle.ksh
> > >
> > > On Friday, 10 September 2010 13:48:29 Gore, David W wrote:
> > > > Has anybody ported this script to ksh93?  I made some changes to
get
> >
> > it
> >
> > > > half running but perhaps someone has done a more thorough and
> >
> > complete
> >
> > > > job who knows the differences between the older and newer Korn
> >
> > shells?
> >
> > > Have you looked at dbcheck.pl from hobbit-perl-cl (on
Sourceforge)?
> > >
> > > Regards,
> > > Buchan
> >
> > I had tried dbcheck.pl a few years ago and I think it appeared more
> > complicated and required database privileges that I did not have.
> > Perhaps I should revisit the script and see if I have much better
luck
> > the second time around.
> 
> You can quite easily disable checks that you don't want, or that
require
> privileges you don't have.
> 
> However, a quick look at the roracle.ksh script looks like it does
pretty
> much
> what dbcheck.pl does by default.
> 
> Regards,
> Buchan

I have started looking at dbcheck.pl and so far I am stuck on getting it
to work on a 4 node Oracle RAC.  I am just getting started though and I
am a bit ignorant on how tnsnames.ora works and I think that is the key.
I will let you know how it goes and if I have an questions.  I still
think it could be useful to have a ksh93 version of bb-roracle.ksh but I
can see why people like to do shell scripts in the original bourne shell
for portability.

~David