11g 报错 ora-27102: out of memory linux error: 22: invalid argument
没事装了个11g玩，安装软件dbca建库使用一切正常。今天启动发现报错
[oracle@oel54db11gr2 dbs]$ sqlplus / as sysdba
sql*plus: release 11.2.0.1.0 production on thu nov 22 20:07:45 2012
copyright (c) 1982, 2009, oracle. all rights reserved.
connected to an idle instance.
sql> startup
ora-27102: out of memory
linux error: 22: invalid argument
处理流程如下：
1、查看数据库内存大小
[oracle@oel54db11gr2 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
[oracle@oel54db11gr2 dbs]$ ls
hc_dbua0.dat init.ora orapworcl peshm_orcl_0
hc_orcl.dat lkorcl peshm_dbua0_0 spfileorcl.ora
[oracle@oel54db11gr2 dbs]$ cat spfileorcl.ora
c挌m盈/cc6porcl.__db_cache_size=205520896
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__oracle_base='/u01/app/oracle'#oracle_base set from environment
orcl.__pga_aggregate_target=218103808
orcl.__sga_target=322961408
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=100663296
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/occ/racle/oradata/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(protocol=tcp) (service=orclxdb)'
*.memory_target=541065216
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='exclusive'
*.undo_tablespace='undotbs1'
2、切换到root用户，，查看内核内存大小
[oracle@oel54db11gr2 ~]$ su -
password:
[root@oel54db11gr2 ~]# vi /etc/sysctl.conf
# kernel sysctl configuration file for oracle enterprise 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 = 2
# 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 =322961408
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 1048576
/etc/sysctl.conf 44l, 1265c written