DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-27300: OS system dependent operation:fork failed with status: 11

  1. #1
    Join Date
    Aug 2002
    Posts
    56

    ORA-27300: OS system dependent operation:fork failed with status: 11

    I have a 10g R2 database on Sun Solaris 5.10 with 4 cpu 4Gb mem. I am getting the following error. Any help is appreciated:

    Wed Dec 6 01:50:25 2006
    Errors in file /d02/oracle/proddb/10.2.0/admin/PROD_rdcuxsrv191/bdump/prod_psp0_521.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
    Wed Dec 6 01:50:26 2006
    Process J000 died, see its trace file
    Wed Dec 6 01:50:27 2006
    kkjcre1p: unable to spawn jobq slave process
    Wed Dec 6 01:50:27 2006
    Errors in file /d02/oracle/proddb/10.2.0/admin/PROD_rdcuxsrv191/bdump/prod_cjq0_541.trc:
    Wed Dec 6 01:58:47 2006
    Process startup failed, error stack:

    Below is the output from /etc/system:

    * USI100fd_start (do not remove)
    set hme:hme_adv_100T4_cap = 0
    set hme:hme_adv_100fdx_cap = 1
    set hme:hme_adv_100hdx_cap = 0
    set hme:hme_adv_10fdx_cap = 0
    set hme:hme_adv_10hdx_cap = 0
    set hme:hme_adv_autoneg_cap = 0
    * USI100fd_end (do not remove)
    * Attempt to prevent and log stack-smashing attacks
    set noexec_user_stack = 1
    set noexec_user_stack_log = 1
    * Begin MDD root info (do not edit)
    rootdev:/pseudo/md@0:0,1,blk
    * End MDD root info (do not edit)
    * For 2-disk systems, it is recommended to uncomment
    * the line below to disable the boot quorom rule
    * set md:mirrored_root_flag=1
    * improve resync speed at the expense of application i/o
    set md_mirror:md_resync_bufsz=2048
    set sys:coredumpsize=0
    set c2audit:audit_load = 1
    set nfssrv:nfs_portmon=1
    set shmsys:shminfo_shmmax=3294967296
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=1024
    set shmsys:shminfo_shmseg=128
    ##set semsys:seminfo_semmap=64
    set semsys:seminfo_semmni=15680
    set semsys:seminfo_semmns=31360
    ##set semsys:seminfo_semmnu=1600
    ##set semsys:seminfo_semmsl=256
    set semsys:seminfo_semopm=110
    set semsys:seminfo_semume=900
    set semsys:seminfo_semvmx=32767
    set semsys:seminfo_semaem=16384
    set rlim_fd_max=65536
    set rlim_fd_cur=65536
    set default_stksize=65536
    set lwp_default_stksize=65536
    set rpcmod:svc_default_stksize=65536
    set maxuprc=2048
    set semsys:seminfo_semmsl=2048
    set semsys:seminfo_semmap=1000
    set semsys:seminfo_semmnu=3200

    Below is the trace file contents
    Dump file /d02/oracle/proddb/10.2.0/admin/PROD_rdcuxsrv191/bdump/prod_psp0_521.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /d02/oracle/proddb/10.2.0
    System name: SunOS
    Node name: rdcuxsrv191
    Release: 5.10
    Version: Generic_118833-17
    Machine: sun4u
    Instance name: PROD
    Redo thread mounted by this instance: 1
    Oracle process number: 3
    Unix process pid: 521, image: oracle@rdcuxsrv191 (PSP0)

    *** SERVICE NAME:(SYS$BACKGROUND) 2006-12-06 01:50:24.418
    *** SESSION ID:(1199.1) 2006-12-06 01:50:24.418
    *** 2006-12-06 01:50:24.418
    Process startup failed, error stack:
    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
    *** 2006-12-06 01:58:47.818
    Process startup failed, error stack:
    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
    *** 2006-12-06 01:59:25.943
    Process startup failed, error stack:
    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


    Processes parameter is set at 1000 at db level

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Hmmm.. unix is not able to fork. A typical memory shortage problem. try reducing memory parameters.check for any other processes running (other than oracle processes.)


    PS: Also looks like you have hit the bug 3411021. Lookup in metalink.
    Last edited by simply_dba; 12-07-2006 at 12:42 AM.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Try reducing the processes parameter 1000 is high i think.

    regards
    Hrishy
    Last edited by hrishy; 12-07-2006 at 01:26 AM.

  4. #4
    Join Date
    Aug 2002
    Posts
    56
    Thanks for the quick response. I will try both the suggestions
    When in doubt ...go to the basics!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width