We help IT Professionals succeed at work.

Oracle10g ERROR ORA-04030

sitg
sitg asked
on
Hi ,

I am facing error in the alert log file given below. After this error I was not able to login to the Database .
It was saying Protocol adapter Error. Finally i stop N start the Instance Service. Now its working, Please provide your recommendations.

Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_j000_72312.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

Fri Jan 25 15:02:09 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_j000_72312.trc:
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

Fri Jan 25 15:03:34 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_j001_73236.trc:
ORA-12012: error on auto execute of job 1
ORA-04030: out of process memory when trying to allocate 8148 bytes (kxs-heap-w,qesaQBInit:buffer)
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 48
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 936
ORA-06512: at line 1

Fri Jan 25 15:03:34 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_j001_73236.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 16092 bytes (pga heap,kgh stack)
ORA-12012: error on auto execute of job 1
ORA-04030: out of process memory when trying to allocate 8148 bytes (kxs-heap-w,qesaQBInit:buffer)
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 48
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 936
ORA-06512: at line 1

Fri Jan 25 15:04:01 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_q000_6392.trc:
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)

Fri Jan 25 15:04:37 2008
Process startup failed, error stack:
Fri Jan 25 15:04:38 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:04:38 2008
Process q002 died, see its trace file
Fri Jan 25 15:04:38 2008
ksvcreate: Process(q002) creation failed
Fri Jan 25 15:38:23 2008
Process startup failed, error stack:
Fri Jan 25 15:38:23 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:38:24 2008
Process J001 died, see its trace file
Fri Jan 25 15:38:24 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:38:24 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

Fri Jan 25 15:38:29 2008
Process startup failed, error stack:
Fri Jan 25 15:38:29 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:38:30 2008
Process J001 died, see its trace file
Fri Jan 25 15:38:30 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:38:30 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

Fri Jan 25 15:38:35 2008
Process startup failed, error stack:
Fri Jan 25 15:38:35 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:38:36 2008
Process J001 died, see its trace file
Fri Jan 25 15:38:36 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:38:36 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

Fri Jan 25 15:38:41 2008
Process startup failed, error stack:
Fri Jan 25 15:38:41 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:38:42 2008
Process J001 died, see its trace file
Fri Jan 25 15:38:42 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:38:42 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

Fri Jan 25 15:38:42 2008
Process startup failed, error stack:
Fri Jan 25 15:38:42 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:38:43 2008
Process J001 died, see its trace file
Fri Jan 25 15:38:43 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:38:43 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

Fri Jan 25 15:38:43 2008
Process startup failed, error stack:
Fri Jan 25 15:38:43 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:38:44 2008
Process J001 died, see its trace file
Fri Jan 25 15:38:44 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:38:44 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

Fri Jan 25 15:38:49 2008
Process startup failed, error stack:
Fri Jan 25 15:38:49 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_psp0_6232.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Fri Jan 25 15:39:01 2008
Process J001 died, see its trace file
Fri Jan 25 15:39:01 2008
kkjcre1p: unable to spawn jobq slave process
Fri Jan 25 15:39:01 2008
Errors in file c:\oracle\product\10.2.0\admin\booksdb\bdump\booksdb_cjq0_6260.trc:

With Regards,
Comment
Watch Question

I'd revise the specification of the server, what is the spec by the way?
Top Expert 2005
Commented:
Without seeing the trace files, I'd say you are out of memory on the machine.  

Author

Commented:
thanks