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

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 18 Feb 2011 17:54:27 +0530
Message-ID: <AANLkTi=2UohJ0ZBy1ojd0nrwzjH4dDMhsTtzrV+LLSQU_at_mail.gmail.com>



if system tablespace and datafiles are not corrupted then either it can be an accident due to casual approch towards development box and restrict the access of sys user even development databases or take regualr backup of development database
take the help of oracle, some docs says dropping and re-creating is the only solution.

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 Fri Feb 18 2011 - 06:24:27 CST

Original text of this message