大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说150 opening binary mode data_bad central directory offset,希望您对编程的造诣更进一步.
alert日志报错：
2019-11-18T07:15:12.704938+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB111/trace/SIBCYB111_ora_83111.trc (incident=803537) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [kdlrci_get_inline_data], [8], [3], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB111/incident/incdir_803537/SIBCYB111_ora_83111_i803537.trc
以下内容来自MOS Bug 28450914:
DIAGNOSTIC ANALYSIS
===================
- below error is received in an 12.2 upgraded database from 11.2.0.4
ORA-600: internal error code, arguments: [kdlrci_get_inline_data], [30],
[3], [], [], [], [], [], [], [], [], []
- the CDB env is in use
- the error is seen when select on CDB_FEATURE_USAGE_STATISTICS
WITH
pdbs AS (SELECT con_id, name
FROM v$containers WHERE con_id != 2)
SELECT p.NAME, DBID, C.NAME, VERSION, DETECTED_USAGES,
TOTAL_SAMPLES, CURRENTLY_USED,
to_char(FIRST_USAGE_DATE,"YYYY-MM-DD HH24:MI:SS") FIRST_USAGE,
to_char(LAST_USAGE_DATE,"YYYY-MM-DD HH24:MI:SS") LAST_USAGE,
AUX_COUNT,
to_char(LAST_SAMPLE_DATE,"YYYY-MM-DD HH24:MI:SS") LAST_SAMPLE,
LAST_SAMPLE_PERIOD,
replace((nvl(TO_CHAR(REGEXP_REPLACE(substr(FEATURE_INFO,0,4000),"[^!@/.,;:<>#
$%&()_=[:alnum:][:blank:]]")),"")),"|","#") FEATURE_DETAIL
FROM CDB_FEATURE_USAGE_STATISTICS C, pdbs p
where version in
( select max(version) from CDB_FEATURE_USAGE_STATISTICS
where con_id = p.con_id )
AND C.con_id = p.con_id
AND DETECTED_USAGES > 0
AND rownum < 9000
- if the PDBs are stopped samestatement is not trigering any error
- we managed to have the error reproduced in house with a copy of customer DB
- I have creted the undo again but the error is still present
- same explain plan is seen when PDS are closed and open and error still
present. when PDBS are opened and failing statement is executed PX is in use
but disable it at session level and still error is present
- no additional details in the 10046 trace
代码100分
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/10928.html
