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

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Wed, 16 Feb 2011 19:18:28 +0530
Message-ID: <AANLkTikG+=YVohdBmiph6gWUQxMfJNYe8eaB9+TWEi0N_at_mail.gmail.com>

primafacie..check all the datafiles with dbv, especially system tablespace's datafiles..thanks..subodh

On 16 February 2011 18:56, Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>wrote:

> Hi Friends,
>
>
> SunOS 5.10 Generic_137112-06 i86pc i386 i86pc , 64 Bit
> Oracle 10.2.0.1.0
>
> While I am doing a startup, getting following error.
>
> *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*
>
>
> The alert log shows the following
>
> Errors in file /applns/oracle/admin/CTSD1/udump/ctsd1_ora_11486.trc:
> ORA-00942: table or view does not exist
> Error 942 happened during db open, shutting down database
> USER: terminating instance due to error 942
> Instance terminated by USER, pid = 11486
> ORA-1092 signalled during: ALTER DATABASE OPEN...
>
> A look at the trace file shows this
>
> /applns/oracle/admin/CTSD1/udump/ctsd1_ora_11486.trc
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
> ORACLE_HOME = /applns/oracle
> System name: SunOS
> Node name: N890
> Release: 5.10
> Version: Generic_137112-06
> Machine: i86pc
> Instance name: CTSD1
> Redo thread mounted by this instance: 1
> Oracle process number: 23
> Unix process pid: 11486, image: oracle_at_N890 (TNS V1-V3)
>
> *** SERVICE NAME:() 2011-02-16 19:24:50.188
> *** SESSION ID:(325.3) 2011-02-16 19:24:50.188
> Successfully allocated 3 recovery slaves
> Using 367 overflow buffers per recovery slave
> Thread 1 checkpoint: logseq 45929, block 2, scn 310788795
> cache-low rba: logseq 45929, block 3
> on-disk rba: logseq 45929, block 52, scn 310788832
> start recovery at logseq 45929, block 3, scn 0
> ----- Redo read statistics for thread 1 -----
> Read rate (ASYNC): 24Kb in 0.31s = 0.08 Mb/sec
> Total physical reads: 4096Kb
> Longest record: 0Kb, moves: 0/61 (0%)
> Longest LWN: 16Kb, moves: 0/3 (0%), moved: 0Mb
> Last redo scn: 0x0000.128642df (310788831)
> ----------------------------------------------
> ----- Recovery Hash Table Statistics ---------
> Hash table buckets = 32768
> Longest hash chain = 1
> Average hash chain = 4/4 = 1.0
> Max compares per lookup = 1
> Avg compares per lookup = 117/121 = 1.0
> ----------------------------------------------
> *** 2011-02-16 19:24:50.515
> KCRA: start recovery claims for 4 data blocks
> *** 2011-02-16 19:24:50.515
> KCRA: blocks processed = 4/4, claimed = 4, eliminated = 0
> *** 2011-02-16 19:24:50.516
> Recovery of Online Redo Log: Thread 1 Group 1 Seq 45929 Reading mem 0
> ----- Recovery Hash Table Statistics ---------
> Hash table buckets = 32768
> Longest hash chain = 1
> Average hash chain = 4/4 = 1.0
> Max compares per lookup = 1
> Avg compares per lookup = 121/121 = 1.0
> ----------------------------------------------
> ORA-00942: table or view does not exist
>
> I have searched MOS and Google, but didn;'t get any relevant results.
>
> Also flushed my shared_pool as mentioned in (
> http://www.tanelpoder.com/files/oracle_rowcache.pdf) after mount and
> started , still no luck
>
> Any help is appreciated
>
> Thanks
> SSN
>
> Thank You,
>
> Kind Regards,
> Sreejith Nair
>
>
>
>
>
>
>
> DISCLAIMER:
>
> "The information in this e-mail and any attachment is intended only for the
> person to whom it is addressed and may contain confidential and/or
> privileged material. If you have received this e-mail in error, kindly
> contact the sender and destroy all copies of the original communication. IBS
> makes no warranty, express or implied, nor guarantees the accuracy, adequacy
> or completeness of the information contained in this email or any attachment
> and is not liable for any errors, defects, omissions, viruses or for
> resultant loss or damage, if any, direct or indirect."
>
>
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

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

Received on Wed Feb 16 2011 - 07:48:28 CST