bb-roracle.ksh

Hi David

Apologies, but I thought you had come right.
Here is my ksh instance, renamed to txt and zipped.
Hopefully corporate rules allow you to do something useful :-)

Buchan - although dbcheck.pl might be great, it's in perl, so I can't hack
with it.
(Yes, I know, I should learn perl, but I just haven't got there yet)
We all try and work within our comfort zones, which is probably why David
wants the ksh script.

Cheers
   Vernon


On Fri, Sep 17, 2010 at 9:12 PM, Gore, David W <
user-3e5761c68b56@xymon.invalid> wrote:

-----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:user-9b139aff4dec@xymon.invalid]
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 user-0e253b709301@xymon.invalid 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