Re: Database startup showing ORA-00942: table or view does not exist in trace

From: Adric Norris <landstander668_at_gmail.com>
Date: Wed, 16 Feb 2011 08:01:44 -0600
Message-ID: <AANLkTikQSkVeXby-bDy5j9JHWonoNH+DcrNgiYkuwmo6_at_mail.gmail.com>

On Wed, Feb 16, 2011 at 7:26 AM, Sreejith S Nair < Sreejith.Sreekantan_at_ibsplc.com> wrote:

> *SQL startup;*
> *ORACLE instance started.*
>
> *Total System Global Area 3221225472 bytes*
> *Fixed Size 2122544 bytes*
> *Variable Size 410819792 bytes*
> *Database Buffers 2801795072 bytes*
> *Redo Buffers 6488064 bytes*
> *Database mounted.*
> *ORA-01092: ORACLE instance terminated. Disconnection forced*
>

Any chance there's a buggy "on startup" trigger generating this error? If memory serves, you should able to do a "startup upgrade" (which suppresses such triggers) in this case.

-- 
"I'm too sexy for my code." -Awk Sed Fred

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

Received on Wed Feb 16 2011 - 08:01:44 CST