oracle数据库shutdown不了,数据库shutdown之后无法启动的问题

> less /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

# Controls the use of TCP syncookies

net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes

kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue

kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes

kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages

kernel.shmall = 4294967296

### DBA REQUEST FOR ORACLE11 ###

kernel.shmmni = 4096

kernel.sem = 256 32000 100 500

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_max = 4194394

net.core.wmem_max = 1048576

net.core.rmem_default = 262144

net.core.wmem_default = 262144

fs.aio-max-nr = 3145728

但是查看当前的进程数,也才不到10000,离32000还远呢。

查看了一下其他的库的process情况,终于明白了。

原有的5台,有4台process都是5000,一台是3000,一共就是23000

新加的4台,process都是3000,一共就是12000

加起来还真是超了。也难怪新加的第3个数据库实例没有问题,23000+9000=32000,刚好占完了,一点都没剩下。

和部门协调了一下,原有的5台process平时测试用不了那么多,3000多process已经足够了。

就调整了一下,再次重启就没有问题了。

> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed Apr 16 15:05:37 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1.1742E+10 bytes

Fixed Size                  2251264 bytes

Variable Size            5234492928 bytes

Database Buffers         6492782592 bytes

Redo Buffers               12193792 bytes

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值