2 Replies Latest reply: Jan 12, 2013 1:41 PM by Karthik_ponn RSS

    ISSUES IN R12.1.1 UPGRADE

    Karthik_ponn
      Hi,

      We have been doing 11i to R12 upgrade in test instance, During the upgrade we had found some errors in the alert log and all adworkers are seem to be hanged and temporarily resources are not available.

      Process startup failed, error stack:
      Errors in file /fin-u10/oracle/R12/diag/rdbms/test/TEST/trace/TEST_psp0_21302.trc:
      ORA-27300: OS system dependent operation:fork failed with status: 11
      ORA-27301: OS failure message: Resource temporarily unavailable
      ORA-27302: failure occurred at: skgpspawn3
      Tue Jan 08 02:42:37 2013

      TNS-12535: TNS:operation timed out

      Fatal NI connect error 12170.
      ns secondary err code: 12606
      nt main err code: 0

      VERSION INFORMATION:
      TNS for Solaris: Version 11.2.0.3.0 - Production
      Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
      TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
      nt secondary err code: 0
      Time: 09-JAN-2013 06:22:16
      nt OS err code: 0
      Tracing not turned on.
      Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.6)(PORT=45816))
      Tns error struct:
      WARNING: inbound connection timed out (ORA-3136)
      ns main err code: 12535


      This is the Error we got in alert log.
      So we raised a SR. In support they asked to follow the document 392006.1 Ora-27300 OS system dependent operation fork failed with status 11. & Database Crashes With ORA-27300, ORA-27301, ORA-27302 On Solaris SPARC [ID 1333824.1]

      this is server config:
      ---------------------------------------
      Server Model     - M4000
      Platform     - Solaris[tm] OE (64-bit)
      OS Release     - Solaris 10 Update 9
      Kernel Patch     - 144488-12
      CPUs     - 4
      Cores     - 16
      CPU Threads     - 32
      Sockets     - 4
      Memory (GB) - 32
      Value of project.max-lwps - 2.1 GB

      FOR ADPATCH WE WILL GIVE 32 WORKERS.

      After gone through the above docs and the implemented the solution from the docs.Then we start the new upgrade, But again adpatch fails at the same place and the same error in alert log, So we continue with the SR and they asked to change the kernel pageable memory and

      root@host# /bin/ksh -f -c "ulimit -a"
      core file size (blocks, -c) unlimited
      data seg size (kbytes, -d) unlimited
      file size (blocks, -f) unlimited
      open files (-n) 256 to 65536
      pipe size (512 bytes, -p) 10
      stack size (kbytes, -s) 8192 to unlimited
      cpu time (seconds, -t) unlimited
      max user processes (-u) 60000
      virtual memory (kbytes, -v) unlimited
      After the above settings, we plan to restart Again from the backup. After restore we plan to run GATHER SCHEMA STATISTICS, when running STATISTICS,

      CPU STATS shows below 5% idle, USER 3.2% the KERNEL is taking the remaining resources. At that time, the forms window takes too much time to loading and opening slowly.

      Kindly Provide a solution as soon as possible.

      Thanks,
      Karthik
        • 1. Re: ISSUES IN R12.1.1 UPGRADE
          Hussein Sawwan-Oracle
          This is the Error we got in alert log.
          So we raised a SR. In support they asked to follow the document 392006.1 Ora-27300 OS system dependent operation fork failed with status 11. & Database Crashes With ORA-27300, ORA-27301, ORA-27302 On Solaris SPARC [ID 1333824.1]
          Please also review these docs.

          Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors [ID 579365.1]
          Instance Startup Fails With Error ORA-27154,ORA-27300,ORA-27301,ORA-27302 [ID 314179.1]
          Ora-27300 OS system dependent operation:fork failed with status: 11 [ID 392006.1]
          Database Crashes With ORA-04030 ORA-07445 ORA-27300 ORA-27301 ORA-27302 [ID 580552.1]
          Master Note: Troubleshooting Unix Resources [ID 1507742.1]
          FOR ADPATCH WE WILL GIVE 32 WORKERS.

          After gone through the above docs and the implemented the solution from the docs.Then we start the new upgrade, But again adpatch fails at the same place and the same error in alert log, So we continue with the SR and they asked to change the kernel pageable memory and

          root@host# /bin/ksh -f -c "ulimit -a"
          core file size (blocks, -c) unlimited
          data seg size (kbytes, -d) unlimited
          file size (blocks, -f) unlimited
          open files (-n) 256 to 65536
          pipe size (512 bytes, -p) 10
          stack size (kbytes, -s) 8192 to unlimited
          cpu time (seconds, -t) unlimited
          max user processes (-u) 60000
          virtual memory (kbytes, -v) unlimited
          After the above settings, we plan to restart Again from the backup. After restore we plan to run GATHER SCHEMA STATISTICS, when running STATISTICS,

          CPU STATS shows below 5% idle, USER 3.2% the KERNEL is taking the remaining resources. At that time, the forms window takes too much time to loading and opening slowly.

          Kindly Provide a solution as soon as possible.
          Do you meet all the requirements in these docs?

          Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Oracle Solaris on SPARC (64-bit) [ID 761568.1]
          Requirements for Installing Oracle 11gR2 RDBMS on Solaris 10 SPARC [ID 964976.1]

          Please follow the action plan suggested above by Oracle support and see it helps. If not, please update the SR and this post.

          Thanks,
          Hussein
          • 2. Re: ISSUES IN R12.1.1 UPGRADE
            Karthik_ponn
            Hi Hussein,

            Thanks for the update. I'll review the docs. Tomorrow i'll start the upgrade and let you know.

            Thanks,
            Karthik