ORA-01092: ORACLE instance terminated. Disconnection forced [message #74017] |
Wed, 25 August 2004 03:06 |
Pramod
Messages: 18 Registered: April 1999
|
Junior Member |
|
|
hi,
while starting the oracle 9i database i'm getting the following error
Database mounted
ORA-01092: ORACLE instance terminated. Disconnection forced
I looked at the trace file and here is what it says::
Dump file c:oracleadminpramodudumppramod_ora_2256.trc
Wed Aug 25 16:05:52 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: pramod
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 2256, image: ORACLE.EXE
*** SESSION ID:(9.3) 2004-08-25 16:05:52.000
Thread checkpoint rba:0x000012.00000002.0010 scn:0x0000.000a80de
On-disk rba:0x000012.0000003e.0000 scn:0x0000.000a811b
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x000012.00000003.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 144Kb/sec => 289 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/523 (0%)
----------------------------------------------
*** 2004-08-25 16:05:52.000
KCRA: start recovery claims for 86 data blocks
*** 2004-08-25 16:05:52.000
KCRA: buffers claimed = 86/86, eliminated = 0
ORA-00942: table or view does not exist
can anyone help me on this
regards
pramod
|
|
|