sitg
asked on
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\a dmin\books db\bdump\b ooksdb_j00 0_72312.tr c:
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\a dmin\books db\bdump\b ooksdb_j00 0_72312.tr c:
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\a dmin\books db\bdump\b ooksdb_j00 1_73236.tr c:
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:buf fer)
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\a dmin\books db\bdump\b ooksdb_j00 1_73236.tr c:
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:buf fer)
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\a dmin\books db\bdump\b ooksdb_q00 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_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\a dmin\books db\bdump\b ooksdb_psp 0_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\a dmin\books db\bdump\b ooksdb_cjq 0_6260.trc :
With Regards,
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\a
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\a
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\a
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:buf
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\a
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:buf
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
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\a
With Regards,
I'd revise the specification of the server, what is the spec by the way?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks