bb-roracle.ksh 🔗 link

user-3e5761c68b56@xymon.invalid> 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 Fri, Sep 10, 2010 at 9:14 AM, <user-d416b53ee243@xymon.invalid> wrote:

From: Vernon Everett <user-b3f8dacb72c8@xymon.invalid>
To: xymon at xymon.com
Date: Fri, 10 Sep 2010 21:14:34 +0800
Subject: Re: [xymon] bb-roracle.ksh
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 <user-3e5761c68b56@xymon.invalid> 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

Regards
    Vernon


On Fri, Sep 10, 2010 at 11:12 PM, Robert Herron <user-8b27ea4290da@xymon.invalid>wrote:

Here is my bb-roracle.ksh v2.20 that I modified to work with HP-UX's
KSH88 (/bin/ksh) shell.

Robert Herron
user-8b27ea4290da@xymon.invalid


On Fri, Sep 10, 2010 at 9:14 AM, <user-d416b53ee243@xymon.invalid> wrote:

From: Vernon Everett <user-b3f8dacb72c8@xymon.invalid>
To: xymon at xymon.com
Date: Fri, 10 Sep 2010 21:14:34 +0800
Subject: Re: [xymon] bb-roracle.ksh
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 <
user-3e5761c68b56@xymon.invalid> 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?

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

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.

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

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

°((( = (( ===°°° ((( ================================================

On 9/10/2010 11:12 AM, Robert Herron wrote:

Here is my bb-roracle.ksh v2.20 that I modified to work with HP-UX's
KSH88 (/bin/ksh) shell.

Robert Herron
user-8b27ea4290da@xymon.invalid


On Fri, Sep 10, 2010 at 9:14 AM, <user-d416b53ee243@xymon.invalid> wrote:

From: Vernon Everett <user-b3f8dacb72c8@xymon.invalid>
To: xymon at xymon.com
Date: Fri, 10 Sep 2010 21:14:34 +0800
Subject: Re: [xymon] bb-roracle.ksh
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 <user-3e5761c68b56@xymon.invalid> 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 14 October 2011 01:48, Ricardo Stella <user-a9f2fdfdbc44@xymon.invalid> wrote:

Hi,

Having a small problem with this... For some reason, it's not processing
the LISTENER check and on the log files I get:

/bin/sort: open failed: /usr/local/hobbit/client/tmp/LISTENER.23226: No
such file or directory
cat: /usr/local/hobbit/client/tmp/LISTENER.verbose.23226: No such file or
directory

Seems the files don't get created for some reason or another.  But then
also the temporary files are not being deleted either:

-rw-r--r-- 1 root root  1588 Oct 13 13:23
bb-roracle.ksh.22538.nnnn,YYYY,XXX-stat
-rw-r--r-- 1 root root  6336 Oct 13 13:23
bb-roracle.ksh.22538.nnnn,YYYY,XXX-stat2
-rw-r--r-- 1 root root  1588 Oct 13 13:28
bb-roracle.ksh.22883.nnnn,YYYY,XXX-stat
-rw-r--r-- 1 root root  6336 Oct 13 13:28
bb-roracle.ksh.22883.nnnn,YYYY,XXX-stat2
-rw-r--r-- 1 root root  1588 Oct 13 13:33
bb-roracle.ksh.23226.nnnn,YYYY,XXX-stat
-rw-r--r-- 1 root root  6336 Oct 13 13:33
bb-roracle.ksh.23226.nnnn,YYYY,XXX-stat2

I can reproduce what the scripts does by hand without a problem - no
permissions or anything, but seems like the file is not being created -
similarly, the others are not being deleted.

Any clues?

TIA.

  °(((  =  ((  ===°°°  ((( ================================================

On 9/10/2010 11:12 AM, Robert Herron wrote:

Here is my bb-roracle.ksh v2.20 that I modified to work with HP-UX's
KSH88 (/bin/ksh) shell.

On Fri, Sep 10, 2010 at 9:14 AM, <user-d416b53ee243@xymon.invalid> <user-d416b53ee243@xymon.invalid> wrote:

 From: Vernon Everett <user-b3f8dacb72c8@xymon.invalid> <user-b3f8dacb72c8@xymon.invalid>
To: xymon at xymon.com
Date: Fri, 10 Sep 2010 21:14:34 +0800
Subject: Re: [xymon] bb-roracle.ksh
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 <user-3e5761c68b56@xymon.invalid> <user-3e5761c68b56@xymon.invalid> 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