p_manage_17 ends with "ORA-12549" and segmentation fault
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
I am testing parallel indexing on our test server. I have gotten to the point where I am running p_manage_17 and after running about 27 hours I received the following error::
Wed Nov 7 15:28:02 PST 2007
Process number : 2
Cycle : 9
Start loop : 015657097
End loop : 017614233
Wed Nov 7 15:28:02 PST 2007
retrieve get index - 015657097
Oracle error: handle_connection
ORA-12549: TNS:operating system resource quota exceeded
1 START READING AT 15:28:06
Segmentation Fault
Wed Nov 7 15:28:09 PST 2007
FAILURE Wed Nov 7 15:28:09 PST 2007 ==================
step 1
Cycle: 9
b_manage_17_a: Retrieve Failure
Job Suspended !!!
=======================================================
Exiting due to job suspension.
end
Resolution:
From Jerry, to site:
The "oerr" command for 12549 shows this:
>>oerr ora 12549
12549, 00000, "TNS:operating system resource quota exceeded"
// *Cause: The current user has exceeded the allotted resource assigned in the
// operating system.
// *Action: Acquire more operating system resource, or perform a different
// function.
It seems that the system resources involved are Memory (RAM) and Swap space.
The $data_scratch/p_manage_17.cycles file shows that the z01's were processed successfully through 015657096. I suggest that you restart p_manage_17, specifying 015657097 as the "From ACC Sequence".
From site, to Jerry:
We reduced the number of processes from 4 to 2, and it ran OK. Four is the total number of processors we have on our test server. It seems after running the original 27 hours it somehow needed those resources.
From now on we think we will leave at least one processor free. Luckily, our production machine has 16 processors.
- Article last edited: 10/8/2013