数据库一打开就报Ora-01092这个错误！
alert.log：
System parameters with non-default values:
processes = 315
shared_pool_size = 400000000
large_pool_size = 614400
java_pool_size = 32768
control_files = d:\oracle\oradata\ora90\control01.ctl, d:\oracle\oradata\ora90\control02.ctl, d:\oracle\oradata\ora90\control03.ctl
db_block_buffers = 177500
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = FALSE
distributed_transactions = 500
instance_name = ora90
service_names = ora90
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = ora90
open_cursors = 300
ifile = d:\oracle\admin\Ora90\pfile\init.ora
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = d:\oracle\admin\ora90\bdump
user_dump_dest = d:\oracle\admin\ora90\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Fri Sep 01 09:23:13 2006
alter database mount
Fri Sep 01 09:23:17 2006
Successful mount of redo thread 1, with mount id 2520370053.
Fri Sep 01 09:23:17 2006
Database mounted in Exclusive Mode.
Completed: alter database mount
Fri Sep 01 09:23:17 2006
alter database open
Beginning crash recovery of 1 threads
Fri Sep 01 09:23:18 2006
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 25446 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORA90\REDO03.LOG
Fri Sep 01 09:23:18 2006
Thread recovery: finish rolling forward thread 1
Thread recovery: 6 data blocks read, 6 data blocks written, 18 redo blocks read
Crash recovery completed successfully
Fri Sep 01 09:23:18 2006
Thread 1 advanced to log sequence 25447
Thread 1 opened at log sequence 25447
Current log# 1 seq# 25447 mem# 0: D:\ORACLE\ORADATA\ORA90\REDO01.LOG
Successful open of redo thread 1.
Fri Sep 01 09:23:18 2006
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Sep 01 09:23:19 2006
Completed: alter database open
Fri Sep 01 09:23:19 2006
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 2600
PMON Trace File：
Dump file d:\oracle\admin\ora90\bdump\ora90PMON.TRC
Fri Sep 01 09:01:03 2006
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: ora90
Redo thread mounted by this instance: 1
Oracle process number: 2
Windows thread id: 1320, image: ORACLE.EXE
*** 2006-09-01 09:01:03.625
*** SESSION ID
1.1) 2006-09-01 09:01:03.625
error 474 detected in background process
Dump file d:\oracle\admin\ora90\bdump\ora90PMON.TRC
Fri Sep 01 09:04:08 2006
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: ora90
Redo thread mounted by this instance: 1
Oracle process number: 2
Windows thread id: 2032, image: ORACLE.EXE
*** 2006-09-01 09:04:08.375
*** SESSION ID
1.1) 2006-09-01 09:04:08.375
error 474 detected in background process
Dump file d:\oracle\admin\ora90\bdump\ora90PMON.TRC
Fri Sep 01 09:14:25 2006
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: ora90
Redo thread mounted by this instance: 1
Oracle process number: 2
Windows thread id: 2480, image: ORACLE.EXE
*** SESSION ID
1.1) 2006-09-01 09:14:25.453
error 474 detected in background process
Dump file d:\oracle\admin\ora90\bdump\ora90PMON.TRC
Fri Sep 01 09:23:19 2006
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: ora90
Redo thread mounted by this instance: 1
Oracle process number: 2
Windows thread id: 2600, image: ORACLE.EXE
*** SESSION ID
1.1) 2006-09-01 09:23:19.921
error 474 detected in background process
|
