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

  • From: Adric Norris <landstander668@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 16 Feb 2011 08:01:44 -0600

On Wed, Feb 16, 2011 at 7:26 AM, Sreejith S Nair <
Sreejith.Sreekantan@xxxxxxxxxx> 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

Other related posts: