Linux下Oracle系统参数设置-优快云博客

本文详细介绍了Oracle数据库的性能优化配置，包括内存管理、文件限制、网络配置等，并针对Oracle用户权限进行了详细设置，确保系统稳定高效运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

cat /proc/sys/vm/pagecache

/etc/sysctl.conf

grep SwapTotal /proc/meminfo

cat /proc/sys/fs/file-max
cat /proc/sys/fs/file-nr

ethtool eth0

rpm -q libaio libaio-devel

ldd $ORACLE_HOME/bin/oracle | grep libaio

nm $ORACLE_HOME/bin/oracle | grep io_getevent

# /etc/sysctl.conf file
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 = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

# /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

# /etc/profile

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

# Disable response to broadcasts.
# You don't want yourself becoming a Smurf amplifier.
net.ipv4.icmp_echo_ignore_broadcasts = 1
# enable route verification on all interfaces
net.ipv4.conf.all.rp_filter = 1
# enable ipV6 forwarding
#net.ipv6.conf.all.forwarding = 1
kernel.shmall = 2097152
kernel.shmmax = 3294967296
kernel.shmmni = 4096
kernel.sem = 1250 32000 100 128
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default =4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
~
/etc/security/limits.conf

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

rpm -qa ora*
orarun-1.9-21.15
# rpm -e orarun-1.9-21.15

rpm -qa sap*
sapinit-2.0.1-1.10
# rpm -e sapinit-2.0.1-1.10

parse-metadata

linux-nl0r:/ # find / -name parse-metadata -print
/usr/lib64/zmd/parse-metadata

ps -elf | grep mount

/etc/init.d/novell-zmd status
/etc/init.d/novell-zmd stop
chkconfig novell-zmd off