This discussion is archived
2 Replies Latest reply: Jan 12, 2013 11:41 AM by Karthik_ponn RSS

ISSUES IN R12.1.1 UPGRADE

Karthik_ponn Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi Hussein,

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

    Thanks,
    Karthik

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points