問題之Process m000 died, see its trace file&ksvcreate: Process(m000) creation failed

環境：

ORACLE10.2.0.4

LINUX 5.4

ERROR:

Thu Jun 30 13:41:45 2011
Process m000 died, see its trace file
Thu Jun 30 13:41:45 2011
ksvcreate: Process(m000) creation failed
Thu Jun 30 13:42:22 2011

[@more@]

今天DEV環境的資料庫前臺反應不能進行連線，透過檢視ALTER檔案發現後臺報了許多：

Thu Jun 30 13:41:45 2011
Process m000 died, see its trace file
Thu Jun 30 13:41:45 2011
ksvcreate: Process(m000) creation failed
Thu Jun 30 13:42:22 2011

metalink給出的解釋是資源不足導致的問題，於是檢視：

select * from v$resource_limit;

1 processes 150 150 150 150

可以發現processes已經爆滿，於是kill掉幾個就OK了，最後修改processes引數問題解決！