Re: What tools do you use for healthchecking?
From: <matthias.hoys_at_gmail.com>
Date: Tue, 17 Feb 2009 08:25:16 -0800 (PST)
Message-ID: <019445dd-11e2-4095-8477-c0565fc521b8_at_33g2000yqm.googlegroups.com>
On Feb 17, 3:42 pm, Helma <helma.vi..._at_hotmail.com> wrote:
> On Feb 17, 12:26 pm, matthias.h..._at_gmail.com wrote:
>
>
>
> > On Feb 17, 11:47 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
> > > Hi,
>
> > > For the earlymorning check, I am working with self made scripts here
> > > that run overnight and check for things like space in the database,
> > > security, backup ran ok, duplicates to testenvironments,
> > > errorlogchecking etc.
>
> > > These scripts are a bit... wel... 20th century.. I am looking for
> > > tools that can check. For example, i am now looking at the healthcheck
> > > of TOAD, but that frog is more into developing (e.g. checking for
> > > unindexed foreign keys) than administration.
> > > Apart from Oracle, I am also looking for UNIX solutions.
>
> > > What do you use for this?
>
> > > regards,
> > > HV
>
> > What version of Oracle ? Have you tried the Enterprise Manager web
> > control (or Grid control) ?
>
> > Matthias- Hide quoted text -
>
> > - Show quoted text -
>
> oracle 9.2.08.
>
> So you're using webcontrol for that?
Date: Tue, 17 Feb 2009 08:25:16 -0800 (PST)
Message-ID: <019445dd-11e2-4095-8477-c0565fc521b8_at_33g2000yqm.googlegroups.com>
On Feb 17, 3:42 pm, Helma <helma.vi..._at_hotmail.com> wrote:
> On Feb 17, 12:26 pm, matthias.h..._at_gmail.com wrote:
>
>
>
> > On Feb 17, 11:47 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
> > > Hi,
>
> > > For the earlymorning check, I am working with self made scripts here
> > > that run overnight and check for things like space in the database,
> > > security, backup ran ok, duplicates to testenvironments,
> > > errorlogchecking etc.
>
> > > These scripts are a bit... wel... 20th century.. I am looking for
> > > tools that can check. For example, i am now looking at the healthcheck
> > > of TOAD, but that frog is more into developing (e.g. checking for
> > > unindexed foreign keys) than administration.
> > > Apart from Oracle, I am also looking for UNIX solutions.
>
> > > What do you use for this?
>
> > > regards,
> > > HV
>
> > What version of Oracle ? Have you tried the Enterprise Manager web
> > control (or Grid control) ?
>
> > Matthias- Hide quoted text -
>
> > - Show quoted text -
>
> oracle 9.2.08.
>
> So you're using webcontrol for that?
No, the database control doesn't exist for 9i.
You could use the full-blown Enterprise Manager. But then you need a
separate server to install it on, + the "intelligent" agent on your 9i
db server.
And you will need extra licenses for any of the management packs you
wish to use.
I would stay with your own scripts until you upgrade to 10g or 11g.
Matthias Received on Tue Feb 17 2009 - 10:25:16 CST