EBS R12.2.4 can not fork too many process

Beauty_and_dBest

    Hi ALL,

     

    EBS R12.2.4

    11gR2

    OL6.5

     

     

    Everyday once a day we encounter error  > can not fork too many process.

    Then we restart the instance  to resolve since the users can not login anymore.

     

    I checked the /etc/security/limits.conf and it was setup according to what the Oracle Notes.

     

    [root@dbs ~]# cd /etc/security/

    [root@dbs security]# cat limits.conf

    * hard nofile 65536

    * soft nofile 4096

    * hard nproc 16384

    * soft nproc 2047

    * hard stack 16384

    * soft stack 10240

     

    Are these parameters setting correct? Or are there conf files that overrides this?

     

    I also check /etc/security/limits.d  and I see two files.

     

    -rw-r--r--. 1 root root  192 Jan 29 14:35 90-nproc.conf

    -rw-r--r--. 1 root root 1059 Jan 29 14:39 oracle-ebs-server-R12-preinstall.conf

     

    And someone said that Oracle recommend  90-nproc.conf  to have  * soft nproc  set  to 32768 , is this correct?

     

    cat 90-nproc.conf

    # Default limit for number of user's processes to prevent

    # accidental fork bombs.

    # See rhbz #432903 for reasoning.

     

     

    *          soft    nproc     32768

    root       soft    nproc     unlimited

     

     

     

    Thanks all....

      • 1. Re: EBS R12.2.4 can not fork too many process
        Narsi M-Oracle

        Hello Jenna,

         

        Please run RDA report as per your environment.

         

        Please follow Metalink note 250262.1 (RDA 4 - Health Check / Validation Engine Guide), install and then run "Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86 and x86_64)" diagnostic test.

        Make sure you run it using the following syntax:

         

        rda.sh -T hcve

         

        Then select the options that corresponds to "Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86 and x86_64)" diagnostic test.

         

        It doesn't matter, if you're on 12.2.2/3/4/5. This is applicable for all releases of 12.2

         

        Regards,

        Narsi

        1 位用户发现它有用
        • 2. Re: EBS R12.2.4 can not fork too many process
          Beauty_and_dBest

          Thanks, I am checking the notes...brb

          • 3. Re: EBS R12.2.4 can not fork too many process
            Beauty_and_dBest

            Hi Narsi and ALL,

             

            What do I enter for the planned directory?

             

            Enter the HCVE rule set number or 0 to cancel the test

            Press Return to accept the default (0)

            > 21

             

            Performing HCVE checks ...

            Enter value for < Planned application tier installation directory >

            >

             

             

            The result is passing, then why still I get issues

             

            > /home/appprod/PROD

             

            Test "Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)" executed at 30-Jan-2016 19:46:51

             

            Test Results

            ~~~~~~~~~~~~

             

            ID     NAME                 RESULT  VALUE

            ====== ==================== ======= ==========================================

            A00100 OS Type              RECORD  OL6 64

            A00200 OS Certified?        PASSED  Adequate

            A01010 ApplTierDirectory    RECORD  /home/appprod/PROD

            A01020 A_T Valid?           PASSED  ATexists

            A01030 A_T Permissions OK?  PASSED  CorrectPerms

            A01040 A_T Disk Space       PASSED  OK

            A01400 Got Software Tools?  PASSED  tools_found

            A02030 Limit Processes      PASSED  Adequate

            A02050 Limit Descriptors    PASSED  Adequate

            A02100 ENV Variable Unset   SKIPPED Not SuSE Linux Enterprise 10 or SuSE ...

            A02210 Kernel Params OK?    FAILED  SHMMAXTooSmall

            A02240 NPTL Selected?       PASSED  NPTL is default

            A03010 Space in tmp         PASSED  Available

            A03050 Swap Space (MB)      RECORD  24127.98828125

            A03060 Swap Space?          PASSED  Available

            A03510 IP Address           RECORD  192.168.167.108

            A03530 Domain Name          RECORD  oracle.amti.com.ph

            A03540 /etc/hosts format    PASSED  Adequate IPv4 entry

            A03550 DNS Lookup           PASSED  Host correctly registered in DNS

            A03560 Net Service Access?  PASSED  PermOk

            A03570 Port 6000            PASSED  Free

            A03580 Port Range OK?       PASSED  RangeOK

            A03590 DNS Settings         PASSED  DNSOptionsOK

            A03600 SysNetw File         PASSED  SysNetOK

            A03610 NoNetwProf File      PASSED  OK

            A04301 RPM OL5/64 OK?       SKIPPED Not Oracle Linux 5 64-bit

            A04302 RPM OL6/64 OK?       PASSED  OL6/64rpmsOK

            A04303 RPM OL7/64 OK?       SKIPPED Not Oracle Linux 7 64-bit

            A04311 RPM RH5/64 OK?       SKIPPED Not Red Hat Enterprise Linux 5 64-bit

            A04312 RPM RH6/64 OK?       SKIPPED Not Red Hat Enterprise Linux 6 64-bit

            A04313 RPM RH7/64 OK?       SKIPPED Not Red Hat Enterprise Linux 7 64-bit

            A04321 RPM SLES10/64 OK?    SKIPPED Not SuSE Linux Enterprise 10 64-bit

            A04322 RPM SLES11/64 OK?    SKIPPED Not SuSE Linux Enterprise 11 64-bit

            Result file: output/collect/APPS_HCVE_A_EBS122_lin_res.htm

            • 4. Re: EBS R12.2.4 can not fork too many process
              Narsi M-Oracle

              You need to fix the issue with Kernel Parameters which has failed:

               

              Ensure you review "Kernel Settings" in "Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)" and rerun and check the report.

               

              If your APPS BASE is /u01, then your installation directory will be /u01/

               

               

              Regards,

              Narsi

              1 位用户发现它有用
              • 5. Re: EBS R12.2.4 can not fork too many process
                Beauty_and_dBest

                The Notes said:

                 

                kernel.shmmaxHalf the size of the physical memory (in bytes), and at least 42949672952

                 

                RDA said:

                =========================

                Rule A02210: Kernel Params OK?

                Description

                 

                 

                This rule verifies that the kernel parameters are set according to My Oracle Support document ID 1330701.1.

                Unmatched Actions

                 

                SHMMAXTooSmall == KernelOK

                 

                Default Action

                 

                    Result: FAILED

                    Value: SHMMAXTooSmall

                 

                The kernel parameters are not set according to the Oracle Applications Installation Guide Using Rapid Install Release 12.2 (12.2.0).

                Increase the kernel parameter SHMMAX to at least 12621271040.

                =========================

                 

                My actual setting is:  kernel.shmmax = 6000000000     *** which is greater than the default  minimum of 4G



                My question is, does this shmmax affects the too many fork process?

                • 6. Re: EBS R12.2.4 can not fork too many process
                  Narsi M-Oracle

                  What is the current setting on your machine.

                  cat /proc/meminfo  | grep -i MemTotal

                  (or)

                  free -m

                   

                  Regards,

                  Narsi

                  • 7. Re: EBS R12.2.4 can not fork too many process
                    Beauty_and_dBest

                    [root@dbs ~]# cat /proc/meminfo  | grep -i MemTotal

                    MemTotal:       24650920 kB

                     

                     

                     

                    My point is, my setting (6Gb) is above the default minimum 4Gb. I think it is not related to the fork issue?

                    I understand that the recommended is half the total physical memory or at least 4Gb

                     

                    The must be a parameter that overrides it?

                     

                    Thanks...

                    • 8. Re: EBS R12.2.4 can not fork too many process
                      Narsi M-Oracle

                      Hello Jenna,

                       

                      Set it to the value recommended by the RDA report.

                      As per my understanding, it should help.

                       

                      kernel.shmmax - Half the size of the physical memory (in bytes), and at least 4294967295

                      and RDA is recommending 1/2 the size which is 12GB as your mem is 24 GB.

                       

                      Regards,

                      Narsi

                      1 位用户发现它有用