Oracle10g ERROR ORA-04030

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,
sitgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sitgAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.