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