After server restart, start the oracle, normal boot, but even the database later tip:
ORA - 27102: out of memory
Linux - x86_64 Error: 12: always the allocate memory
Additional information: 1
Additional information: 950272
Additional information: 8

Restart is suggesting, baidu during the day, all have tried, still won't do,

The normal boot:
SQL> Startup
ORACLE instance started.

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

SQL> Show parameter sga

The NAME, TYPE, VALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Lock_sga Boolean FALSE
Pre_page_sga Boolean FALSE
Sga_max_size big integer 12864 m
Sga_target big integer 0
SQL> Show parameter mem

The NAME, TYPE, VALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Hi_shared_memory_address integer 0
Memory_max_target big integer 12864 m
Memory_target big integer 12864 m
Shared_memory_address integer 0
SQL> Select the name of bytes/1024/1024 from v $sgainfo;

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

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

12 rows selected.


Show the parameter process

SQL> Show the parameter process

The 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
The processes int

Show parameter sessions
SQL> Show parameter sessions

The 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 2 free Shared buff/cache available
Mem: 32012 1210 11554 18188 19247 12244
Swap: 0 0 0

The/etc/sysctl. Conf configuration
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
The kernel. The sysrq=1
The kernel, shmmax=27487790694
The kernel. Shmall=8388608
Fs. File - Max=6815744
Fs. Aio - Max - nr=1048576
The 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

To quote even when not on the tip:
SQL> Startup
ORA - 27102: out of memory
Linux - x86_64 Error: 12: always the allocate memory
Additional information: 1
Additional information: 950272
Additional information: 8

CodePudding user response:

View the current shmmax and configuring shmall, cat/proc/sys/kernel/shmmax cat/proc/sys/shmall

CodePudding user response:

The kernel. Shmall this parameter is too small, check it

CodePudding user response:

The/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
The kernel. The sysrq=1
The kernel, shmmax=27487790694
The kernel. Shmall=8388608
Fs. File - Max=6815744
Fs. Aio - Max - nr=1048576
The 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

CodePudding user response:

Suddenly found that should be a swap,/root @ izbp17jczc2lr53jvde5flz ~ # free -m
Total 2 free Shared buff/cache available
nullnullnullnullnullnullnull