oracle 启动提示ORA-27102: out of memory Linux-x86_64 Cannot allocate memory

[yaowen_2008]

服务器重启后，启动oracle ，正常启动，但是过一会再连数据库的时候都提示：
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 950272
Additional information: 8

重启也是这提示了。百度了白天，各种都尝试了，还是不行。

正常启动的：
SQL> startup
ORACLE instance started.

Total System Global Area 1.3429E+10 bytes
Fixed Size 2217992 bytes
Variable Size 6845106168 bytes
Database Buffers 6576668672 bytes
Redo Buffers 4661248 bytes
Database mounted.
Database opened.

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 12864M
sga_target big integer 0
SQL> show parameter mem

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 12864M
memory_target big integer 12864M
shared_memory_address integer 0
SQL> select name,bytes/1024/1024 from v$sgainfo;

NAME BYTES/1024/1024
-------------------------------- ---------------
Fixed SGA Size 2.115242
Redo Buffers 4.4453125
Buffer Cache Size 6272
Shared Pool Size 1216
Large Pool Size 64
Java Pool Size 64
Streams Pool Size 0
Shared IO Pool Size 0
Granule Size 64
Maximum SGA Size 12806.5625
Startup overhead in Shared Pool 640

NAME BYTES/1024/1024
-------------------------------- ---------------
Free SGA Memory Available 5184

12 rows selected.


show parameter process

SQL> show parameter process

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes int

show parameter sessions
SQL> show parameter sessions

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 4528
shared_server_sessions integer

[root@izbp17jczc2lr53jvde5flz ~]# free -m
total used free shared buff/cache available
Mem: 32012 1210 11554 18188 19247 12244
Swap: 0 0 0

/etc/sysctl.conf 的配置
net.ipv4.tcp_max_tw_buckets = 5000
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_max_syn_backlog = 1024
net.ipv4.tcp_synack_retries = 2
kernel.sysrq=1
kernel.shmmax=27487790694
kernel.shmall=8388608
fs.file-max=6815744
fs.aio-max-nr=1048576
kernel.shmmni=4096
kernel.sem=1010 230280 1010 228
net.ipv4.ip_local_port_range=1024 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576

报连不上的时候提示：
SQL> startup
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 950272
Additional information: 8

[Rotel-刘志东]

查看当前的shmmax和shmall配置,cat /proc/sys/kernel/shmmax cat /proc/sys/shmall

[Rotel-刘志东]

kernel.shmall 这个参数过小原因，检查一下

[lcy_0218]

@yaowen_2008 请教大佬 我现在也遇到了这个问题

[lcy_0218]

@yaowen_2008 你好 请问你具体怎么解决的

[yaowen_2008]

已经好了，swap的问题

[yaowen_2008]

/etc/sysctl.conf

net.ipv4.tcp_max_tw_buckets = 5000
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_max_syn_backlog = 1024
net.ipv4.tcp_synack_retries = 2
kernel.sysrq=1
kernel.shmmax=27487790694
kernel.shmall=8388608
fs.file-max=6815744
fs.aio-max-nr=1048576
kernel.shmmni=4096
kernel.sem=1010 230280 1010 228
net.ipv4.ip_local_port_range=1024 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576

[yaowen_2008]

突然发现 应该是swap问题，[root@izbp17jczc2lr53jvde5flz ~]# free -m
total used free shared buff/cache available
Mem: 32012 1210 11554 18188 19247 12244
Swap: 0 0 0

[B)_Qiong]

引用 6 楼 yaowen_2008 的回复:

已经好了，swap的问题

请问是如何解决的呢？我的问题好像和你的一样