Oracle Database Discussions

Hi ,

Running Oracle DB(10.2.0) Server on Solaris 10. the server refused connections for 5 minutes yesterday and I checked logs through EM webpage :

Found following : Alert.log

Feb 5, 2009 9:39:15 PM
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Trace File: /u01/app/oracle/admin/devee/bdump/devee_psp0_28194.trc

Feb 5, 2009 8:14:41 PM
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Trace File: /u01/app/oracle/admin/devee/bdump/devee_psp0_28194.trc

, I connected solaris 10 using ssh and checked processes, one of the user process was taking around 8G memory.

also one of oracle process is defunct :

ps -auxwww | grep 7714 --
oracle 7714 0.0 0.0 0 0 Z 0:00 <defunct>

ptree--
28192 ora_pmon_devee
28194 ora_psp0_devee
7714 <defunct>
28196 ora_mman_devee

I killed the user process and then it freed up the memory but oracle process is defunct , I don't know if it is related to this issue at all.

cat /u01/app/oracle/admin/devee/bdump/devee_psp0_28194.trc

/u01/app/oracle/admin/devee/bdump/devee_psp0_28194.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/Db_1
System name: SunOS
Node name: abc.abc.com
Release: 5.10
Version: Generic_118833-24
Machine: sun4u
Instance name: devee
Redo thread mounted by this instance: 1
Oracle process number: 3
Unix process pid: 28194, image: oracle@abc.abc.com (PSP0)

*** SERVICE NAME:(SYS$BACKGROUND) 2009-02-05 20:14:41.719
*** SESSION ID:(169.1) 2009-02-05 20:14:41.719
*** 2009-02-05 20:14:41.719
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2009-02-05 20:15:07.770
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: skgpspawn5
*** 2009-02-05 21:39:15.391
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3


but I would like to avoid future occurances, I don't think we here have oracle support, so writing in forums,


Can anyone please help regarding this issue and defunct oracle process?

Thanks