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

hi

or

startup nomount
alter system set "_system_trig_enabled=false";
alter database open.

I agree with the diagnosis BTW.

On Wed, Feb 16, 2011 at 2:01 PM, Adric Norris <landstander668@xxxxxxxxx>wrote:

>  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
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: