Expdp reports ORA-04030outofprocessmemory Error

Operating System: AIX6.1Oracle database version: 11.1.0.7.01, when using expdp export, reported ORA-04030: outofprocessmemorywhentryingto & nb ..

Operating System: AIX6.1Oracle database version: 11.1.0.7.01, when using expdp export, reported ORA-04030: outofprocessmemorywhentryingto & nb ..

Operating System: AIX 6.1
Oracle Database Version: 11.1.0.7.0
1. when exporting with expdp, the error "ORA-04030: out of process memory when trying to allocate 120048 bytes" is reported,
The details are as follows:

ORA-39082: Object type ALTER_PROCEDURE: "INDEXAPP ". "PA_INDEX_PORTAL_UV_D" created with compilation warningsProcessing object type SCHEMA_EXPORT/VIEW/VIEWORA-39082: Object type VIEW: "INDEXAPP ". "TA_CONTENT_AUDIT_USER_D" created with compilation warningsProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS # ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW01" prematurely terminatedORA-31671: Worker process DW01 had an unhandled exception. ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap, kuxLpxAlloc) ORA-06512: at "SYS. KUPW $ WORKER ", line 1602ORA-06512: at line 2

2. Run ulimit-a as an oracle user. there are limits on the memory used by the user process, as shown below:

$ Ulimit-atime (seconds) unlimitedfile (blocks) unlimiteddata (kbytes) 256000 stack (kbytes) 256000 memory (kbytes) 256000 coredump (blocks) unlimitednofiles (descriptors) 2000 threads (per process) unlimitedprocesses (per user) unlimited

3. Switch to root and add the following content to the/etc/security/limits file (-1 indicates no restriction ):

Oracle: data =-1stack_hard =-1 stack =-1rss =-1 core =-1 nofiles =-1

4. view the/etc/security/limits file after the added content:

$ Su-rootroot's Password: # cat/etc/security/limits ** Sizes are in multiples of 512 byte blocks, CPU time is in seconds ** fsize-soft file size in blocks * core-soft core file size in blocks * cpu-soft per process CPU time limit in seconds * data-soft data segment size in blocks * stack-soft stack segment size in blocks * rss-soft real memory usage in blocks * nofiles-soft file descriptor limit * fsize_hard-hard file size in blocks * core_hard-hard core file size in blocks * cpu_hard-hard per process CPU time limit in seconds * data_hard-hard data segment size in blocks * stack_hard-hard stack segment size in blocks * rss_hard-hard real memory usage in blocks * nofiles_hard-hard file descriptor limit ** The following table contains the default hard values if the * hard values are not explicitly defined: ** AttributeValue * =============================== * fsize_hard set to fsize * cpu_hardset to cpu * core_hard-1 * data_hard-1 * stack_hard8388608 * rss_hard-1 * nofiles_hard-1 ** NOTE: A value of-1 implies "unlimited" * default: fsize =-1 core =-1cpu =-1 data = 512000rss = 512000 stack = 512000 nofiles = 2000 root: data =-1stack_hard =-1 stack =-1rss =-1 core =-1 nofiles =-1 oracle: data =-1stack_hard =-1 stack =-1rss =-1 core =-1 nofiles =-1 daemon: bin: sys: adm: uucp: guest: nobody: lpd: pconsole: stack_hard = 131072 data = 1280000data_hard = 1280000 esaadmin: stack = 393216stack_hard = 393216

5. Switch to the oracle user and run ulimit-a. The result is as follows:

# Su-oracle $ ulimit-atime (seconds) unlimitedfile (blocks) unlimiteddata (kbytes) unlimitedstack (kbytes) limit (blocks) unlimitednofiles (descriptors) limit (per process) unlimitedprocesses (per user) unlimited

6. Execute expdp export again and the same error is still reported.
7. After the operating system is restarted, the parameter takes effect and no error is reported for export.

This article is from the "yangyang Youqing" blog. Be sure to keep this source