Re: Oracle Profile Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 19 Jul 2005 18:04:11 -0700
Message-ID: <1121821461.855982@yasure>

Sybrand Bakker wrote:
> On 19 Jul 2005 10:02:51 -0700, amerar_at_iwc.net wrote:
>
>

>>What is so hard to understand about that?  There must be a way to
>>detect that, in batch mode, and deal with it, without having everything
>>hang or abort.......

>
>
> You are barking at the wrong tree. If this a production system, the
> system shouldn't be shutdown at random intervals.
> Either it is not a production system, or you need to develop a special
> stupidity alert system.
> Other than that you might consider to set up replication between the
> non-production system and your production system. Replication is
> implemented in the form of pl/sql jobs, and they will be resubmitted
> when they fail.
> And, no, we're not going to help you out with setting that up.
> It is quite evident you think you know everything better and can
> manage databases by using sellotape all over the place.
> Both you and the incompetent administrators of the non-production site
> could better reconsider their career, or be prepared to get fired
> sooner or later.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

To: amerar_at_iwc.net

Sybrand said it ... but I'd like to reinforce it. Production systems are ONLY shut down when absolutely forced by failure condition or a need to perform a patch that can not be done on a live system. From my standpoint it is an embarrasement if a production system comes down more than once a year and even then only for scheduled maintenance.

What you are describing to us is either inaccurate, my first presumption, or an abomination. Either way the solution is the same. The connection should NEVER fail and a production system should never go down. And if it does, for whatever cause, diagnose the cause of the failure and then address by shining a very bright light on the source.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Jul 19 2005 - 20:04:11 CDT