早晨检查Alert日志,发现下列错误:
Fri Jun 19 08:24:43 2009
Process q001 died, see its trace file
Fri Jun 19 08:24:43 2009
ksvcreate: Process(q001) creation failed
在日志没有提示日志文件的名称。分析q001是属于QMNC进程的任务,所以找qmnc的日志,在bdump中果然存在data_qmnc_3815000.trc。
/oracle/admin/data/bdump/data_qmnc_3815000.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0
System name: AIX
Node name: ibm5703
Release: 3
Version: 5
Machine: 00C4956D4C00
Instance name: data
Redo thread mounted by this instance: 1
Oracle process number: 36
Unix process pid: 3815000, image: oracle@ibm5703