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?
~David Gore
See attached. I don't recall what version of ksh I was using for this one, but I do recall it worked on the Sol8 and Sol10 default ksh. (The default version doesn't support most of the string manipulation commands, which makes me think it's the older version)
It did require two additional config files. One, defined the tests to perform, and the other defined your list of databases. Then you also had to make sure your tnsnames was available. Instead of trying to set the path, I used to symbolically link it into the ~/client/etc/ directory.
Give it a whirl, and see how you go. Sorry I can't be more specific, but it's been some time since I last did database monitoring.
Regards Vernon
On Fri, Sep 10, 2010 at 8:48 PM, Gore, David W < david.gore at verizonbusiness.com> 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?
~David Gore
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
-----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.
Thank you Vernon and Robert for sending me some updates on bb-roracle.ksh but unfortunately they are not quite what I am looking for. I should have been more specific. I am looking for an updated bb-roracle.ksh that is compatible with Redhat 5.x and the OSes use of what appears to be ksh93.
bb-roracle.ksh uses typeset and local syntaxes that do not appear to be completely compatible with the newer ksh and their may be more subtle differences that I have not discovered yet. I will try dbcheck.pl again and if that does not suit my needs I will probably google for a ksh88 to ksh93 migration guide.
Thanks all,
~David
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
-----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
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
participants (3)
-
bgmilne＠staff.telkomsa.net
-
david.gore＠verizonbusiness.com
-
everett.vernon＠gmail.com