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最好也改一下。