oracle数据库错误代码27102,Linux 下数据库oracle出现ORA-27102错误的解决办法

Linux 下数据库oracle出现ORA-27102错误的解决办法

[日期：2007-09-24]

来源：Linux公社

作者：Linuxidc

[字体：大 中 小]

三、查看系统参数，发现kernel.shmmax=16777216 太小，于是将其设置为2G

[Oracle@CCN-BJ-4-573 dbs]$ more /etc/sysctl.conf

# Kernel sysctl configuration file for Red Hat Linux

#

# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and

# sysctl.conf(5) for more details.

# Controls IP packet forwarding

net.ipv4.ip_forward = 0

# Controls source route verification

net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing

net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel

kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.

# Useful for debugging multi-threaded applications.

kernel.core_uses_pid = 1

# add for squid program

# Increase the tcp-time-wait buckets pool size

net.ipv4.tcp_max_tw_buckets = 1800000

net.ipv4.tcp_max_syn_backlog = 8192

#2nd try

kernel.msgmnb=8192

kernel.msgmni=40

kernel.msgmax=8192

kernel.shmall=2097152

kernel.shmmni=32

kernel.shmmax=16777216

# end of squid

~

[oracle@CCN-BJ-4-573 dbs]$ exit

logout

[root@CCN-BJ-4-573 ~]# vi /etc/sysctl.conf

# Kernel sysctl configuration file for Red Hat Linux

#

# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and

# sysctl.conf(5) for more details.

# Controls IP packet forwarding

net.ipv4.ip_forward = 0

# Controls source route verification

net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing

net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel

kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.

# Useful for debugging multi-threaded applications.

kernel.core_uses_pid = 1

# add for squid program

# Increase the tcp-time-wait buckets pool size

net.ipv4.tcp_max_tw_buckets = 1800000

net.ipv4.tcp_max_syn_backlog = 8192

#2nd try

kernel.msgmnb=8192

kernel.msgmni=40

kernel.msgmax=8192

kernel.shmall=2097152

kernel.shmmni=32

kernel.shmmax=2147483648

#kernel.shmmax=16777216

# end of squid

~

~

~

"/etc/sysctl.conf" 35L, 918C written

使参数生效

[root@CCN-BJ-4-573 ~]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_max_tw_buckets = 1800000

net.ipv4.tcp_max_syn_backlog = 8192

kernel.msgmnb = 8192

kernel.msgmni = 40

kernel.msgmax = 8192

kernel.shmall = 2097152

kernel.shmmni = 32

kernel.shmmax = 2147483648

最后数据库成功启动。