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@xxxxxxxxxx>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@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 ==============================