昨天一个生产系统,暂时有1个节点运行,结果超过了最到PROCESSES 数,出现如下错误
环境:AIX5.3ML03+Oracle 10.2.0.2 RAC
[@more@]alert.log 出现如下错误
Process P045 died, see its trace file
Process P045 died, see its trace file
Process P045 died, see its trace file
Process P045 died, see its trace file
testdb2_ora_1089710.trc
/oracle/app/oracle/admin/testdb/bdump/testdb2_ora_1089710.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /oracle/app/oracle/product/10.2.0
System name: AIX
Node name: testserver
Release: 3
Version: 5
Machine: 00CE489B4C00
Instance name: testdb2
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 1089710, image: oracle@testserver
Died during process startup with error 20 (seq=1155)
OPIRIP: Uncaught error 20. Error stack:
ORA-00020: maximum number of processes (350) exceeded