An example of troubleshooting ORA-04030 errors

An example of troubleshooting ORA-04030 errors

The customer said that an error was found in the database background as follows:

Errors in file/Oracle/bkjia/saptrace/diag/rdbms/bkjia/incident/incdir_183218/bkjia_j003_8103_i183218.trc:
ORA-04030: out of process memory when trying to allocate 1052696 bytes (pga heap, log read buffer)
ORA-07445: exception encountered: core dump [kgdsdst () + 16] [SIGSEGV] [ADDR: 0xFFFFFFFF7FFB4634] [PC: 0x1081A1C90] [Address not mapped to object] []
 
When viewing, there were no statements found. Check the system restrictions as follows:

Root @ bkjia # ulimit-
Core file size (blocks,-c) unlimited
Data seg size (kbytes,-d) unlimited
File size (blocks,-f) unlimited
Open File (-n) 256
Pipe size (512 bytes,-p) 10
Stack size (kbytes,-s) 8192
Cpu time (seconds,-t) unlimited
Max user processes (-u) 29995
Virtual memory (kbytes,-v) unlimited

At the same time, the error indicates Address not mapped to object, and there may be insufficient swap partitions.

Next, the following error is reported:

Errors in file/oracle/bkjia/saptrace/diag/rdbms/bkjia/trace/bkjia_psp0_27454.trc:
ORA-27300: OS system dependent operation: fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

According to the official website introduction:

Cause

This issue is mainly caused by lack of memory/swap. Checking the memory configuration on the server, we have found the following
 

According to the comprehensive analysis, 04030 errors are reported, and 27302 and 27301 errors are reported respectively. According to the error message, on the one hand, the session fails to be created, and on the other hand, the ing address cannot be found, so it is suspected that it is related to the swap partition.

--------------------------------------------------------------------------------

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

--------------------------------------------------------------------------------
 
The database is installed on solaris11 and the check is as follows:

Root @ bkjia # swap-h-l
Swapfile dev swaplo blocks free
/Dev/zvol/dsk/rpool/swap 285, 2 8 K 4.0G 4.0G

The swap partition is only 4 GB, and the physical memory is 40 GB, which is obviously too small. It should be caused by this problem.

The solution is to expand the swap partition, and the adjustment method of solaris11 has changed. Different Versions of earlier versions

Root @ bkjia :~ # Zfs set volsize = 30g rpool/swap

Check the adjustment result:

Root @ bkjia # swap-h-l
Swapfile dev swaplo blocks free
/Dev/zvol/dsk/rpool/swap 285, 2 8 K 4.0G 4.0G
/Dev/zvol/dsk/rpool/swap 285, 2 4.0G 26G 26G

After the adjustment is complete, continue tracing. After a few weeks, no error is reported!