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 < david.gore at verizonbusiness.com> 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: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
To unsubscribe from the xymon list, send an e-mail to xymon-unsubscribe at xymon.com