ORACLE 参数和Unix Kernal关系

processes设置过大，就开不了ORACLE了.
ORA-27303: additional information: invalid shared ctx
ORA-27146 : post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates

改小点就能开了.
虽然semmns已经设了1024了,看来还要加,查了一下参数和Kernel参数的关系.

db_block_buffers            shmmax
db_files (maxdatafiles)     nfile, maxfiles
large_pool_size             shmmax
log_buffer                  shmmax
processes                   nproc, semmsl, semmns
shared_pool_size            shmmax

Common Unix Kernel Parameter Definitions
The following Kernel Parameters tend to be generic across most Unix platforms:

maxfiles - Soft file limit per process.
maxuprc - Maximum number of simultaneous user processes per userid.
nfile - Maximum number of simultaneously open files systemwide at any given time.
nproc - Maximum number of processes that can exist simultaneously in the system.
shmmax - The maximum size(in bytes) of a single shared memory segment.
shmmin - The minimum size(in bytes) of a single shared memory segment.
shmmni - The number of shared memory identifiers.
shmseg - The maximum number of shared memory segments that can be attached by a process.
semmns - The number of semaphores in the system.
semmni - The number of semaphore set identifiers in the system; determines the number of semaphore sets that can be created at any one time.
semmsl - The maximum number of sempahores that can be in one semaphore set. It should be same size as maximum number of Oracle processes.

最容易出错的是semmns太小， Solaris也比HP-UNIX容易暴掉。

原来semmns=1024, 可以开一个R12,2个9i,一个10g， 再看9i就不行了， 变2048，一切正常， semmsl最好也改一下。