Re: so get a load of this - venting on support

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 2 Nov 2011 08:02:35 -0500
Message-ID: <CAJvnOJYWZHVjUFW_iioffZRGpR5bB0aBPiCJ3OngvFMrRj9OYw_at_mail.gmail.com>

Niall-
Startup Upgrade incantation? I like that phraseology.

In the past have been accused of sacrificing a goat at midnight on my keyboard myself. Now your developers are going to accuse you of casting spells on the computer...

On Tue, Nov 1, 2011 at 5:19 PM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:

> Presumably a la Note 370366.1? If so I'd be wondering what the
> improper entries were, how they got there and if there was an
> alternative (like removing the invalid entries). Now that note is
> suspiciously lacking version numbers, which given the advent of FAST
> DUAL in 10g might be somewhat problematic. They should however really
> point you at How to Recreate Dual Table (Doc ID 1163714.1) for this
> issue since this has the correct (IIRC) startup upgrade incantation!.
> Assuming that this is a fair summary of your problem I'd definitely
> give the feedback on what happened and how the response could have
> been improved (or indeed made to be accurate!). Is this by any chance
> a much upgraded database?
>
> On Tue, Nov 1, 2011 at 6:32 PM, <TESTAJ3_at_nationwide.com> wrote:
> >
> > Content-Type: text/plain; charset="US-ASCII"
> > a SR is opened due to an issue with dbms_metadata.get_ddl.
> >
> > Solution: drop and recreate sys.dual,
> >
> > so the junior DBA does as said and now can't recreate due to ORA-1775
> > looping chain of synonyms. I'm biting my tongue to not give support a
> > real piece of my mind, oh and this was to an escalated individual.
> >
> > He comes and sees me to get it fixed, google comes to rescue on how to
> fix
> > it but geez support, REALLY, DROP DUAL????
> >
> > joe
> >
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 02 2011 - 08:02:35 CDT