ORA-01403: no data found
Hello,
Could anyone help, I am stumped.
I am having problem opening my database, though it is mounted. Here is the error message:
ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced
In the alert log, it says ORA-01403: no data found
Here is my initfile:
db_block_size=8192
db_cache_size=32m
db_file_multiblock_read_count=16
open_cursors=300
db_domain=com
db_name=personal
background_dump_dest=/opt/oracle/admin/personal/bdump
core_dump_dest=/opt/oracle/admin/personal/cdump
timed_statistics=TRUE
user_dump_dest=/opt/oracle/admin/personal/udump
control_files=("/opt/oracle/oradata/personal/control01.ctl", "/opt/oracle/oradata/personal/control02.ctl", "/opt/oracle/oradata/personal/control03.ctl")
instance_name=personal
job_queue_processes=10
dispatchers="(PROTOCOL=TCP) (SERVICE=personalXDB)"
aq_tm_processes=1
compatible=9.2.0.0.0
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
java_pool_size=64m
large_pool_size=16m
shared_pool_size=80m
processes=50
fast_start_mttr_target=300
#remote_login_passwordfile=EXCLUSIVE
remote_login_passwordfile=NONE
pga_aggregate_target=24m
sort_area_size=1048576
max_dump_file_size=10240
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
#undo_tablespace=lkPERSONAL
++++++++++++++++++
Here is trace file:
Dump file /opt/oracle/admin/personal/udump/test_ora_2906.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name: Linux
Node name: localhost.localdomain
Release: 2.4.20-24.9spk2
Version: #1 Wed Dec 3 01:45:44 UTC 2003
Machine: i586
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 2906, image: oracle@localhost.localdomain (TNS V1-V3)
*** SESSION ID:(9.3) 2004-06-23 23:26:53.574
Thread checkpoint rba:0x00001c.00000002.0010 scn:0x0000.00085d99
On-disk rba:0x00001c.00000031.0000 scn:0x0000.00085dcc
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x00001c.00000003.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 23Kb in 3.78s => 0.00 Mb/sec
Longest record: 0Kb, moves: 0/64 (0%)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 17/17 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 94/111 = 0.8
----------------------------------------------
*** 2004-06-23 23:26:57.522
KCRA: start recovery claims for 17 data blocks
*** 2004-06-23 23:26:57.555
KCRA: buffers claimed = 17/17, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 17/17 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 111/111 = 1.0
----------------------------------------------
ORA-01403: no data found