Re: Database startup showing ORA-00942: table or view does not exist in trace
Date: Wed, 16 Feb 2011 17:10:51 +0200
Message-ID: <AANLkTi=yhm5rSm1nVyVFVmBd3vzOg7+4khS9U=VXH+8u_at_mail.gmail.com>
Or if you want to know which statement fails (trying to access which object), then either enable SQL trace systemwide (in spfile) and startup or do this:
STARTUP NOMOUNT;
ALTER SESSION SET EVENTS '942 trace name errorstack level 3';
ALTER SYSTEM SET EVENTS '942 trace name errorstack level 3';
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN;
This should dump the errorstack with current SQL statement (and PL/SQL line
info if in plsql call) whenever an ORA-942 happens...
Once you've figured this out, I'd bounce the instance to get rid of this event. There's a tricky thing with alter *system* set events - it applies to all new sessions logging on and these sessions will keep this event enabled, even if you later issue an alter system to disable events... In fact, "alter system set events" just modifies the instance event array (template for new sessions logging on), not any existing sessions...
-- Tanel Poder http://tech.e2sn.com http://blog.tanelpoder.com On Wed, Feb 16, 2011 at 4:44 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:Received on Wed Feb 16 2011 - 09:10:51 CST
> 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_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