ORA-27146 Errors while starting up Database

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?

Leave a Reply