oracle数据库启动后自己停止，alert.log看不出问题，急求解决

[maweiliang111]

服务器环境是hp服务器，win2000操作系统，oracle 9.2数据库，每次启动后登录数据库查询都会提示ora-01033:oracle initializationg or shutdown in progress，查看alert.log也没有发现明显问题，贴上alert.log求解。

Mon Nov 18 12:24:30 2013
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=908
Mon Nov 18 12:25:30 2013
alter database open
Mon Nov 18 12:25:31 2013
Beginning crash recovery of 1 threads
Mon Nov 18 12:25:31 2013
Started redo scan
Mon Nov 18 12:25:33 2013
Completed redo scan
197865 redo blocks read, 17945 data blocks need recovery
Mon Nov 18 12:25:41 2013
Started recovery at
Thread 1: logseq 397404, block 15271, scn 0.0
Mon Nov 18 12:25:42 2013
Recovery of Online Redo Log: Thread 1 Group 2 Seq 397404 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ZASC\REDO02.LOG
Mon Nov 18 12:26:16 2013
alter database open
Mon Nov 18 12:26:16 2013
ORA-1154 signalled during: alter database open...
Mon Nov 18 12:30:30 2013
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=4616
Mon Nov 18 12:36:28 2013
Restarting dead background process QMN0
QMN0 started with pid=12, OS id=4964
Mon Nov 18 12:40:28 2013
alter database close
Mon Nov 18 12:40:28 2013
ORA-1109 signalled during: alter database close...
Mon Nov 18 12:40:39 2013
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 5
All dispatchers and shared servers shutdown
Mon Nov 18 12:40:43 2013
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon Nov 18 12:40:43 2013
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Nov 18 12:42:38 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 226492416
large_pool_size = 58720256
java_pool_size = 58720256
control_files = D:\oracle\oradata\zasc\CONTROL01.CTL, D:\oracle\oradata\zasc\CONTROL02.CTL, D:\oracle\oradata\zasc\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 1216348160
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = zasc
dispatchers = (PROTOCOL=TCP) (SERVICE=zascXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\zasc\bdump
user_dump_dest = D:\oracle\admin\zasc\udump
core_dump_dest = D:\oracle\admin\zasc\cdump
sort_area_size = 524288
db_name = zasc
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 104857600
aq_tm_processes = 1
PMON started with pid=2, OS id=4796
DBW0 started with pid=3, OS id=5332
LGWR started with pid=4, OS id=4984
CKPT started with pid=5, OS id=5200
SMON started with pid=6, OS id=5688
RECO started with pid=7, OS id=5868
CJQ0 started with pid=8, OS id=5236
QMN0 started with pid=9, OS id=6020
Mon Nov 18 12:42:41 2013
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Nov 18 12:48:43 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5240
Mon Nov 18 12:54:46 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5424
Mon Nov 18 12:57:22 2013

[惜分飞]

引用 2 楼 gioh0022 的回复:

版本问题 alter system set aq_tm_processes=0 scope=both;

aq_tm_processes 会导致重启 官方文档，mos哪里建议你把该参数设置为0？

[居然有人说长得比我帅]

You might be hit with bug 3248886 (CONTINOUS 'RESTARTING DEAD BACKGROUND PROCESS QMN0' MESSAGE IN ALERT.LOG)
If shutdown and startup does not work , please check for above BUG.

Workaround to bug 3248886

The workaround is to set aq_tm_processes=0 in the init.ora/spfile prior to startup. After startup
alter system set aq_tm_processes=n (original value-n)

https://forums.oracle.com/message/10533662

[居然有人说长得比我帅]

引用 3 楼 xifenfei 的回复:

[quote=引用 2 楼 gioh0022 的回复:] 版本问题 alter system set aq_tm_processes=0 scope=both;

aq_tm_processes 会导致重启 官方文档，mos哪里建议你把该参数设置为0？[/quote] https://forums.oracle.com/message/10533662

[惜分飞]

sqlplus "/ as sysdba"
startup mount;
oradebug setmypid
oradebug EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12
alter session set db_file_multiblocK_read_count=1;
oradebug TRACEFILE_NAME
alter database Open;

oradebug EVENT 10046 trace name context off

把生成的文件发我



---------------------------------------------------------------
QQ号：107644445
邮箱：[e-mail]
BLOG：http://www.xifenfei.com

[居然有人说长得比我帅]

版本问题 alter system set aq_tm_processes=0 scope=both;