aiosp2() Error: failure in usdspn()

[latifa]

Hi Erman,

I try to apply the foolowing patch: 24353308_F while I ma getting the following error:

aiosp2() Error: failure in usdspn()

Contents of error buffer are:
"usdsop cannot create a new process

Cause: usdsop encountered an error creating a new process. [Reason].

Action: Check that your system had enough resources to start a new process. Contact your system administrator to obtain more resou (RE"

What could be missing resources which lead to this error message ?
How can I repair it.

Regards,
Latifa

[ErmanArslansOracleBlog]

Is this a Windows env?

If it is UNIX/LINUX, please check the following:

1)is your env setting correct?
2)is your OS limits configured properly? (max process, max file etc..)


A reference issue: AUTOINSTALL FAILS WITH APP-0907 USDSOP CANNOT CREATE NEW PROCESS RESOURCES (Doc ID 1022980.6)

[latifa]

--> It's Unix environemnt
--> 1) the system is set correctly I think.
--> 2) ulimit -a
core file size          (blocks, -c) unlimited
data seg size           (kbytes, -d) unlimited
file size               (blocks, -f) unlimited
open files                      (-n) 65536
pipe size            (512 bytes, -p) 10
stack size              (kbytes, -s) 65536
cpu time               (seconds, -t) unlimited
max user processes              (-u) 32773
virtual memory          (kbytes, -v) unlimited

3) In the alert.log:

Memory Notification: Library Cache Object loaded into SGA
Heap size 189809K exceeds notification threshold (51200K)
Details in trace file ...../DBOFINF1_ora_17254.trc

In This trace file:
NamespaceDump:
    Child Cursor:  Heap0=6ac3c7d20 Heap6=10000006699a9380 Heap0 Load Time=03-26-2018 10:57:21 Heap6 Load Time=03-26-2018 10:57:21 kgskupdbalance:  time_used[214245362] greater than threshold[30000000] current_consumed_cpu_time[501017797] exec_start_consumed_time[286772435]exec_start_elapsed_time[17702130975217].

--> Do you think that there is a problem when it says : greater than threshold...


4) The system closed my session and the adop aborted:
===============================================================

Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
Server_name       master     APPLY           ABANDONED       2018/03/26 10:51:40  2018/03/26 11:29:28  0:37:48
                           CLEANUP         NOT STARTED

--> may I do a cleanup and retry applying the patch with less workers (10 instead of 40 by default) ?

Thank you in advance for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

I think you are hitting -> Temporary shortage of UNIX-System resources, i.e. The UNIX-System
hit the maximum number of User-Processes..

Increase the OS limit and retry.
Especially the max number of process..
I think this error is caused by OS..

[latifa]

Hi Erman,

I retried applying the patch with: abandon=yes and workers=5 (instead of 40) and it works :)

I continue patching. Thank you for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

So yes.. then it was really a "Temporary shortage" :)

Anyways, you may analyze it further (from the OS perspective), ofcourse if the issue will reoccur in the future.. For now, you are good ..