Archive for 六月 23rd, 2009

ksvcreate: Process(m000) creation failed

星期二, 六月 23rd, 2009
文档ID:418553.1
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
 
References
Bug 5583049 - 'KSVCREATE: PROCESS(M000) CREATION FAILED' AFTER STANDBY OPEN RO MULTIPLE TIMES