安装Oracle 10g Release 2 ---在Linux(Cent OS 4.7上)的准备工作(3)
来源:百度文库 编辑:神马文学网 时间:2024/05/10 16:41:34
Configuring Kernel Parameters---------------------------------------------------------------------------------------------------------------------------Note: The kernel parameter and shell limit values shown in the following section are recommended values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. Refer to your operating system documentation for more information about tuning kernel parameters.----------------------------------------------------------------------------------------------------------------------------Verify that the kernel parameters shown in the following table are set to values greater than or equal to the recommended value shown. The procedure following the table describes how to verify and set the values.=======================================================Parameter Value File
semmsl 250 /proc/sys/kernel/sem
semmns 32000
semopm 100semmni 128............................................................................................................................................................................................shmall 2097152 /proc/sys/kernel/shmall.............................................................................................................................................................................................shmmax Half the size of physical memory (in bytes) /proc/sys/kernel/shmmax.............................................................................................................................................................................................shmmni 4096 /proc/sys/kernel/shmmni..............................................................................................................................................................................................file-max 65536 /proc/sys/fs/file-max..............................................................................................................................................................................................ip_local_port_range Minimum:1024 Maximum: 65000 /proc/sys/net/ipv4/ip_local_port_range..............................................................................................................................................................................................rmem_default 1048576 /proc/sys/net/core/rmem_default...............................................................................................................................................................................................rmem_max 1048576 /proc/sys/net/core/rmem_max...............................................................................................................................................................................................wmem_default 262144 /proc/sys/net/core/wmem_default................................................................................................................................................................................................wmem_max 262144 /proc/sys/net/core/wmem_max=============================================================Note: If the current value for any parameter is higher than the value listed in this table, then do not change the value of that parameter. To view the current value specified for these kernel parameters, and to change them if necessary:
1. Enter the commands shown in the following table to view the current values of the kernel parameters:Note: Make a note of the current values and identify any values that you must change.====================================Parameter Command--------------------------------------------------------------------semmsl, semmns, # /sbin/sysctl -a | grep sem
semopm, and semmni This command displays the value of the semaphore parameters in the order listed. ......................................................................................................shmall, shmmax, and shmmni # /sbin/sysctl -a | grep shm This command displays the details of the shared memory segment sizes.........................................................................................................file-max # /sbin/sysctl -a | grep file-max
This command displays the maximum number of file handles.........................................................................................................ip_local_port_range # /sbin/sysctl -a | grep ip_local_port_range
This command displays a range of port numbers.........................................................................................................rmem_default # /sbin/sysctl -a | grep rmem_default.........................................................................................................rmem_max # /sbin/sysctl -a | grep rmem_max.........................................................................................................wmem_default # /sbin/sysctl -a | grep wmem_default.........................................................................................................wmem_max # /sbin/sysctl -a | grep wmem_max.........................................................................................................2. If the value of any kernel parameter is different from the recommended value,then complete the following procedure:
Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:--------------------------------Note:Include lines only for the kernel parameter values that you want to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the recommended value, then specify the larger value.------------------------------------------------kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144-------------------------------------------------------By specifying the values in the /etc/sysctl.conf file, they persist when you restart the system.----->sysctl -p这个命令在这里可以有效果吗,待验证。
semmsl 250 /proc/sys/kernel/sem
semmns 32000
semopm 100semmni 128............................................................................................................................................................................................shmall 2097152 /proc/sys/kernel/shmall.............................................................................................................................................................................................shmmax Half the size of physical memory (in bytes) /proc/sys/kernel/shmmax.............................................................................................................................................................................................shmmni 4096 /proc/sys/kernel/shmmni..............................................................................................................................................................................................file-max 65536 /proc/sys/fs/file-max..............................................................................................................................................................................................ip_local_port_range Minimum:1024 Maximum: 65000 /proc/sys/net/ipv4/ip_local_port_range..............................................................................................................................................................................................rmem_default 1048576 /proc/sys/net/core/rmem_default...............................................................................................................................................................................................rmem_max 1048576 /proc/sys/net/core/rmem_max...............................................................................................................................................................................................wmem_default 262144 /proc/sys/net/core/wmem_default................................................................................................................................................................................................wmem_max 262144 /proc/sys/net/core/wmem_max=============================================================Note: If the current value for any parameter is higher than the value listed in this table, then do not change the value of that parameter. To view the current value specified for these kernel parameters, and to change them if necessary:
1. Enter the commands shown in the following table to view the current values of the kernel parameters:Note: Make a note of the current values and identify any values that you must change.====================================Parameter Command--------------------------------------------------------------------semmsl, semmns, # /sbin/sysctl -a | grep sem
semopm, and semmni This command displays the value of the semaphore parameters in the order listed. ......................................................................................................shmall, shmmax, and shmmni # /sbin/sysctl -a | grep shm This command displays the details of the shared memory segment sizes.........................................................................................................file-max # /sbin/sysctl -a | grep file-max
This command displays the maximum number of file handles.........................................................................................................ip_local_port_range # /sbin/sysctl -a | grep ip_local_port_range
This command displays a range of port numbers.........................................................................................................rmem_default # /sbin/sysctl -a | grep rmem_default.........................................................................................................rmem_max # /sbin/sysctl -a | grep rmem_max.........................................................................................................wmem_default # /sbin/sysctl -a | grep wmem_default.........................................................................................................wmem_max # /sbin/sysctl -a | grep wmem_max.........................................................................................................2. If the value of any kernel parameter is different from the recommended value,then complete the following procedure:
Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:--------------------------------Note:Include lines only for the kernel parameter values that you want to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the recommended value, then specify the larger value.------------------------------------------------kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144-------------------------------------------------------By specifying the values in the /etc/sysctl.conf file, they persist when you restart the system.----->sysctl -p这个命令在这里可以有效果吗,待验证。
安装Oracle 10g Release 2 ---在Linux(Cent OS 4.7上)的准备工作(3)
安装Oracle10g Release 2 ---在Linux(Cent OS 4.7上)的准备工作(2)
安装Oracle10g Release 2 ---在Linux(Cent OS 4.7上)的准备工作
Installing Oracle RAC 10g Release 2 on Linux x86
Oracle 10g 在Linux 5安装错误记录
Linux安装 在Redhat9上安装Oracle 9.2
Oracle 8i在GNU/Linux上的安装笔记 (笔记 by 车东)
linux 下 oracle常用命令(安装linux下11g)的相关文章推荐 - - Ja...
linux 下 oracle常用命令(安装linux下11g)的相关文章推荐 - - Ja...
【格志】 在IPOD Video 30G上安装Linux
ORACLE 10g 安装教程
ORACLE 10g 安装教程
VonGates 學習筆記 : HOWTO--如何在10g不支持的Linux版本安装10g
Ruby 在 Linux 上的安装
新手入门:Oracle 10G服务器安装图解
新手入门:Oracle 10G服务器安装图解
ORACLE 10g 安装教程[图文]
使用 2VMware Server 在 Oracle Enterprise Linux 上安...
linux 下安装Oracle
LINUX上安装Weblogic与Apache,oracle集成 - 李宇宙
Vmware server1.0 Linux As4 Oracle 10g RAC
Windows下安装Oracle 10g网络配置检查未执行的问题
详述Oracle 11g简体中文版的安装过程及图解
Windows下ORACLE 10g安装与操作图解