ORACLE 参数和Unix Kernal关系
来源:互联网 发布:精通qt4编程 高清pdf 编辑:程序博客网 时间:2024/05/16 09:20
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最好也改一下。
- ORACLE 参数和Unix Kernal关系
- Linux和Unix关系
- oracle三对内存参数间关系之4sga_参数和memory_参数这两类上下级层次参数间的关系
- oracle三对内存参数间关系之6pga_aggrate_target参数和memory_参数这两类上下级层次参数间的关系
- Oracle sessions,processes 和 transactions 参数 关系 说明
- oracle启动数据库和参数文件的关系
- oracle 10g中db_recovery_file_dest和log_archive_dest参数的关系
- Linux和Unix的关系
- linux和unix的关系
- Linux和Unix的关系
- Linux和unix的关系
- LINUX和UNIX的关系是什么?
- UNIX 是啥?!和Linux什么关系?
- linux kernal中list_head的移植和使用
- oracle三对内存参数间关系之5AMM启动和关闭两种情况下pga自动管理涉及的一对参数间的关系探讨
- oracle三对内存参数间关系之3AMM启动和关闭两种情况下ASMM机制涉及的一对参数间的关系探讨
- oracle 存储和关系结构
- oracle表和段关系
- int 和 String 互相转换的多种方法~老忘,这里记录一下
- java反射技术(2)
- IT企业过冬应该注重增收、节支、提效
- OEMAddressTable介绍
- tdd介绍
- ORACLE 参数和Unix Kernal关系
- XML与数据库
- Linux Command Line Encryption
- wine中文支持设置
- string和int间的类型转换
- PHP+Mysql二级动态联动菜单
- mysql注入时的注释处理
- Visual C#中用WMI获取远程计算机信息
- codebehind与codefile