Short post on a issue faced by me, while starting up a cloned database
SQL> startup nomount ORA-24323: value not allowed ORA-27146: post/wait initialization failed
This database environment was cloned and was being started for first time after cloning. Running hcve scripts on system indicated that OS kernel parameters were adequately sized.
SHMMNI set to 1000 is adequate SHMSEG set to 120 is adequate SEMMNI set to 700 is adequate SEMMNS set to 2000 is adequate MAX_THREAD_PROC set to 256 is adequate NFLOCKS set to 1450 is adequate
My Oracle Support articles suggested this issue is related to semaphores setting. As settings were correct, I attempted to start instance by commenting processes parameter in init.ora (setting was 1000). This time database started.
I modified the processes parameter back to 1000 and attempted to restart the Database. It started again!! I am clueless on why it initially failed and then started with same setting. Does anyone have any reasoning for this behavior?