-----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