Problém 26:
Jelikož vyšla nová verze Grid Controlu, rozhodl jsem se ji vyzkoušet. O problémech s upgradem jsem již psal, ale co by vás moho zarazit je náhle zobrazování chyby ORA-7445.
Řešení:
Ono v podstatě máte, jen jedno řešení a to požádat Oracle product support o backport. Já to tedy zkusil a
uvidíme jak se věci pohnou, ale prý bude daný bug zafixován ve verzi 12.1, která má vyjít někdy v roce 2011.O chybě pojednává Note 1115493.1: ORA-7445 [kokscold()+849] from Job Queue Process Running SQL Analyze.Kde se jedná po bug 9594372: TB:X:ORA-07445:[KOKSCOLD()+786] IN SQL ANALYZE.A řešením by měl být patch 9594372, který ale není k dispozici..
Trasovací soubor:
Name——–=== ODM Data Collection ===From emrep_j003_16143_i9085.trc:—————————————–*** 2010-06-06 18:05:58.348*** SESSION ID:(419.8534) 2010-06-06 18:05:58.348*** CLIENT ID:() 2010-06-06 18:05:58.348*** SERVICE NAME:(SYS$USERS) 2010-06-06 18:05:58.348*** MODULE NAME:(DBMS_SCHEDULER) 2010-06-06 18:05:58.348*** ACTION NAME:(ORA$AT_SQ_SQL_SW_142) 2010-06-06 18:05:58.348Dump continued from file: /opt/oracle/diag/rdbms/emrep/emrep/trace/emrep_j003_16143.trcORA-07445: exception encountered: core dump [kokscold()+640] [SIGSEGV] [ADDR:0x34] [PC:0x8D3DA9C] [Address not mapped to object] []…*** 2010-06-06 18:05:58.353dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)—– Current SQL Statement for this session (sql_id=04qwh3d67n0sb) —–/* SQL Analyze(419,1) */ MERGE INTO MGMT_ARU_PATCH_RECOMMENDATIONS p USING (SELECT :1 as patch_guid, :2 as PATCH_TYPE, :3 as BUG_ID, :4 as REQUEST_ID, :5 as PLATFORM_ID, :6 as PRODUCT_ID, :7 as RELEASE_ID , :8 as LANGUAGE_ID, :9 as CLASSIFICATION_ID, :10 as PLATFORM, :11 as PRODUCT,…