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

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_at_gmail.com>wrote:

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

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

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