ORA-12805: parallel query server died unexpectedly
AdixMay 17 2010 — edited May 17 2010Hello
i have get this error again and again at certain time when i tried to insert data in table like insert into(col1, col2....) select col1,..... from. i get the following error in alter log
Here is alter Log
*{ORA-07445: exception encountered: core dump [skgmrf_alloc()+1021] [ACCESS_VIOLATION] [ADDR:0x31F4C0000] [PC:0x820CABF] [UNABLE_TO_WRITE] []*
Incident details in: E:\APP\TAHMAD\diag\rdbms\orcl\orcl\incident\incdir_76288\orcl_p004_1552_i76288.trc
Sun May 16 03:31:36 2010
Errors in file E:\APP\TAHMAD\diag\rdbms\orcl\orcl\trace\orcl_p005_4668.trc (incident=76296):
*ORA-07445: exception encountered: core dump [skgmrf_alloc()+1021] [ACCESS_VIOLATION] [ADDR:0x2DF460000] [PC:0x820CABF] [UNABLE_TO_WRITE] []*
Incident details in: E:\APP\TAHMAD\diag\rdbms\orcl\orcl\incident\incdir_76296\orcl_p005_4668_i76296.trc
Sun May 16 03:31:37 2010
Errors in file E:\APP\TAHMAD\diag\rdbms\orcl\orcl\trace\orcl_p006_4944.trc (incident=76303):
*ORA-07445: exception encountered: core dump [skgmrf_alloc()+1021] [ACCESS_VIOLATION] [ADDR:0x2BF430000] [PC:0x820CABF] [UNABLE_TO_WRITE] []*
Incident details in: E:\APP\TAHMAD\diag\rdbms\orcl\orcl\incident\incdir_76303\orcl_p006_4944_i76303.trc
Sun May 16 03:31:41 2010
Errors in file E:\APP\TAHMAD\diag\rdbms\orcl\orcl\trace\orcl_p007_4684.trc (incident=76311):
*ORA-07445: exception encountered: core dump [skgmrf_alloc()+1021] [ACCESS_VIOLATION] [ADDR:0x2FF490000] [PC:0x820CABF] [UNABLE_TO_WRITE] []*
Incident details in: E:\APP\TAHMAD\diag\rdbms\orcl\orcl\incident\incdir_76311\orcl_p007_4684_i76311.trc
*}*
When i look into trace file same sql statement which mentioned above shown there. there lot of memory dump available which unable to understand. i have 11g with latest critical patch on windows server2003. plz help how to solve this problem. every thing is fine couple of days ago. Any suggestion