服務器重啟后，啟動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
uj5u.com熱心網友回復：
查看當前的shmmax和shmall配置,cat /proc/sys/kernel/shmmax cat /proc/sys/shmalluj5u.com熱心網友回復：
kernel.shmall 這個引數過小原因，檢查一下uj5u.com熱心網友回復：
/etc/sysctl.confnet.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
uj5u.com熱心網友回復：
突然發現 應該是swap問題，[root@izbp17jczc2lr53jvde5flz ~]# free -mtotal used free shared buff/cache available
Mem: 32012 1210 11554 18188 19247 12244
Swap: 0 0 0
uj5u.com熱心網友回復：
已經好了，swap的問題轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/22922.html
標籤：基礎和管理
上一篇：EXP操作的日志