1 Reply Latest reply on Apr 7, 2016 10:43 PM by Bashar.

    usdsop cannot create a new process  in ORACLE R12 while patching

    Noname123

      I am facing performance issue while applying a pre-requistie of patch (21271187).  In fact, the process is hung when applying.
      I tried to search here and there to solve the issue but I couldn't find an answer.  Hence, asking here.

       

       

      After few jobs are completed the patch , I had performance issue and got hung, and the patch failed and displayed the following output (so I had to quit the adworkers ) :

       

      ************************************************BEGINNING OF OUTPUT********************************************************

       

       

      There are now 87 jobs remaining (current phase=A0):

          60 running, 27 ready to run and 0 waiting.

       

       

      Assigned: file XLIFFImporter.class on worker 61 for product fnd username APPLSYS.

      Assigned: file XLIFFImporter.class on worker 62 for product fnd username APPLSYS.

      Assigned: file XLIFFImporter.class on worker 63 for product fnd username APPLSYS.

      Assigned: file XLIFFImporter.class on worker 64 for product fnd username APPLSYS.

       

       

      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"

       

      ***********************************************************END OF OUTPUT*********************************************************************

       

      It says that I don't have enough resource to start a new process .  Contact your system admin to obtain more resource...
      Unfortunately, I don't have sys admin, and I should do that even though I have no clue as to how I should approach the problem,  So kindly, guide

      me to the solution to optimize the performance and do the patch successfully.

       


      Here are some information you might ask (if you need other info, please don't hesitate to ask me) :

       

      Memory info:

      $ cat /proc/meminfo

      MemTotal:       32974200 kB

      MemFree:         2768396 kB

      Buffers:          651700 kB

      Cached:         24328332 kB

      SwapCached:         9000 kB

      Active:         16616444 kB

      Inactive:       12049424 kB

      Active(anon):    5212488 kB

      Inactive(anon):   479252 kB

      Active(file):   11403956 kB

      Inactive(file): 11570172 kB

      Unevictable:       20108 kB

      Mlocked:            7844 kB

      SwapTotal:      34812848 kB

      SwapFree:       34648264 kB

      Dirty:               584 kB

      Writeback:             0 kB

      AnonPages:       3697680 kB

      Mapped:          1762164 kB

      Shmem:           2003768 kB

      Slab:             783356 kB

      SReclaimable:     638388 kB

      SUnreclaim:       144968 kB

      KernelStack:       17856 kB

      PageTables:       311220 kB

      NFS_Unstable:          0 kB

      Bounce:                0 kB

      WritebackTmp:          0 kB

      CommitLimit:    51299948 kB

      Committed_AS:   16432416 kB

      VmallocTotal:   34359738367 kB

      VmallocUsed:      345368 kB

      VmallocChunk:   34342619972 kB

      HardwareCorrupted:     0 kB

      AnonHugePages:   1558528 kB

      HugePages_Total:       0

      HugePages_Free:        0

      HugePages_Rsvd:        0

      HugePages_Surp:        0

      Hugepagesize:       2048 kB

      DirectMap4k:        7852 kB

      DirectMap2M:     3102720 kB

      DirectMap1G:    30408704 kB

       

       

       

       

      Cpu info:

      $cat /proc/cpuinfo

      processor       : 31

      vendor_id       : GenuineIntel

      cpu family      : 6

      model           : 45

      model name      : Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz

      stepping        : 7

      cpu MHz         : 2699.803

      cache size      : 20480 KB

      physical id     : 1

      siblings        : 16

      core id         : 7

      cpu cores       : 8

      apicid          : 47

      initial apicid  : 47

      fpu             : yes

      fpu_exception   : yes

      cpuid level     : 13

      wp              : yes

      flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm dca sse4_1 sse4_2 x2apic popcnt aes xsave avx lahf_lm ida arat epb xsaveopt pln pts dts tpr_shadow vnmi flexpriority ept vpid

      bogomips        : 5399.26

      clflush size    : 64

      cache_alignment : 64

      address sizes   : 46 bits physical, 48 bits virtual

      power management:

       

       

       

       

       

      These are some cpu-related information from the database:

      SQL> show parameter cpu

       

       

      NAME                                 TYPE        VALUE

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

      cpu_count                            integer     32

      parallel_threads_per_cpu             integer     2

      resource_manager_cpu_allocation      integer     32

       

       

       

       

      These are the sga information

      SQL> select * from v$sga;

      NAME                      VALUE

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

      Fixed Size              2230072

      Variable Size         922749128

      Database Buffers     1191182336

      Redo Buffers           21725184

       

       

       

       

       

       

      Some other information:

      SQL> show parameter server

      NAME                                 TYPE        VALUE

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

      fal_server                           string

      gcs_server_processes                 integer     0

      max_shared_servers                   integer

      parallel_max_servers                 integer     8

      parallel_min_servers                 integer     0

      parallel_server                      boolean     FALSE

      parallel_server_instances            integer     1

      parallel_servers_target              integer     8

      rdbms_server_dn                      string

      sec_return_server_release_banner     boolean     FALSE

      shared_server_sessions               integer

      shared_servers                       integer     0

      smtp_out_server                      string

       

       

       

      I am looking forward your suggestions.  Your help would be much appreciated.

      Thanks in advanced.