Re: Oracle Fix Scripts

In article <8f99j0$gs2$1_at_galaxy.us.dell.com>,   "Carlos A. Gonzalez" <carlos_a_gonzalez_at_us.dell.com> wrote:
> Gentlemen:
>
> There are a large amount of Oracle databases in production (Over 300)
 at my
> place of employment.
>
> We use DBVision to monitor all of these databases.
>
> There is lot of notifications (paging, e-mail) by DBVision on behalf
 of the
> databases.
>
> We have been requested to implement fixes for a great number of this
 paging.
>
> Let me explain - Management here want to automate the responses by
 the DBAs
> so for a given notification and kick in a cript that
> will fix the particular problem.
>
> I need some help please - point me to a site or vendor or .... that
 have a
> list of sccripts to fix problems in a database
>
> Thanks
>
> Carlos
>
To automate the response to a problem requires that you first understand the problem and can formulate the proper response. To apply one response to a problem accross a set of databases will require that the database environments be very standardized as in the same arch directory, backup directory, datafile naming conventions, and so on exist depending on the exact problems being encountered.

May I suggest that before you try this: that you analyze the list of problem pages and try to group the pages into common problems then address the cause of the problem and not the response. Once you have reduced the number of pages then you will have a much better change to analyze what remains and determine a logical cource of action.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.