google了半天,发现很多都是说因为process参数设置太小导致不能创建新的进程,此数据库是一个dataguard,没有人会连上来的,而且process设置为600,ps -ef|wc -l返回的结果也只有不到160,看来不是这个问题了。在metalink中,终于看到这又是一个bug,就是说如果物理的DATAGUARD经过多次OPEN READONLY之后,就会产生这个问题,晕,而且描述的版本正好是我的版本:10.2.0.2,这个bug要到11G才能修复。此bug描述如下:
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2 to 10.2
This problem can occur on any platform.
Symptoms
Switching a Physical Standby Database multiple to READ ONLY Mode will report the following Errors in the ALERT.LOG:
ksvcreate: Process(m000) creation failed
Changes
Switch Physical Standby from READ ONLY to apply and back to READ ONLY.
Cause
The Cause of this Problem has been identified in Bug 5583049.
Solution
There are two Workarounds available:
Restart the Instance..
or
Disable ADDM - Should be re-enabled if Standby takes up the Primary Role
* Set SGA_TARGET=0 and set shared_pool_size, db_cache_size, etc if using
Automatic SGA Memory Management (ASMM)
* Set STATISTICS_LEVEL=BASIC to disable statistics gathering
最后重启实例后,问题解决。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25016/viewspace-1000209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25016/viewspace-1000209/