物理DATAGUARD库上的KSVCREATE: PROCESS(M000)

大部分内容转至中国编程网，自己整理了下，

朋友遇到物理备库出现了ALTER DATABASE OPEN Thu Nov 10 10:38:12 2011 SMON: enabling cache recovery Thu Nov 10 10:38:12 2011 Opening with internal Resource Manager plan where NUMA PG = 1, CPUs = 32 Physical standby database opened for read only access. Completed: ALTER DATABASE OPEN Thu Nov 10 10:38:13 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:38:45 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:39:48 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:40:30 2011 Primary database is in MAXIMUM PERFORMANCE mode RFS[31]: Successfully opened standby log 7: '/dev/rlvbuslog141' Thu Nov 10 10:40:51 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:41:51 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:42:51 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:43:54 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:44:54 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:45:57 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:46:57 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:47:35 2011 Primary database is in MAXIMUM PERFORMANCE mode RFS[61]: Successfully opened standby log 11: '/dev/rlvbuslog241' Thu Nov 10 10:48:00 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:49:03 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:50:06 2011 ksvcreate: Process(m000) creation failed Thu Nov 10 10:50:36 2011 在网上找到这个，还蛮一致，留下参考： ksvcreate: Process(m000) creation failed， 网上各位大侠分析的原因可能有： 1、因为归档日志把磁盘写满导致MMON进程挂掉，然后awr报表不能自动收集的情况：http://zhang41082.itpub.net/post/7167/369161，这次看来还是这个awr的问题了。  2、因为process参数设置太小导致不能创建新的进程，此数据库是一个dataguard，没有人会连上来的，而且process设置为600，ps -ef|wc -l返回的结果也只有不到160，看来不是这个问题了。 3、关键在这里：在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/22907091/viewspace-712856/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22907091/viewspace-712856/