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

From: Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>
Date: Wed, 16 Feb 2011 18:56:08 +0530
Message-ID: <OF11FA4692.F97FE193-ON65257839.0049AE77-65257839.0049CAE7_at_ibsplc.com>

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

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

Received on Wed Feb 16 2011 - 07:26:08 CST