在oracle 12c的使用中,遇到ora-07445: 出现异常错误: 核心转储 [ktuhistrecusegcrtmain()+1173]的错误,通过10046分析是在查询cdef$表的时候异常,导致数据库无法正常open,通过recover database,然后open成功,怀疑是oracle 12c bug,但是mos中未查询到相关记录,
在oracle 12c的使用中,遇到ora-07445: 出现异常错误: 核心转储 [ktuhistrecusegcrtmain()+1173]的错误,通过10046分析是在查询cdef$表的时候异常,导致数据库无法正常open,通过recover database,然后open成功,怀疑是oracle 12c bug,但是mos中未查询到相关记录,后续不知道是否会出现相关文档说明该问题.
数据库版本
banner con_id-------------------------------------------------------------------------------- ----------oracle database 12c enterprise edition release 12.1.0.1.0 - 64bit production 0pl/sql release 12.1.0.1.0 - production 0core 12.1.0.1.0 production 0tns for 64-bit windows: version 12.1.0.1.0 - production 0nlsrtl version 12.1.0.1.0 - production 0
oracle 12c启动报错
idle> startuporacle 例程已经启动。total system global area 400846848 bytesfixed size 2440024 bytesvariable size 281019560 bytesdatabase buffers 109051904 bytesredo buffers 8335360 bytes数据库装载完毕。ora-03113: 通信通道的文件结尾进程 id: 5972会话 id: 242 序列号: 3
alert日志报ora-07445: 出现异常错误: 核心转储 [ktuhistrecusegcrtmain()+1173]错
sun mar 30 22:35:22 2014smon: enabling cache recoverysun mar 30 22:35:23 2014exception [type: access_violation, unable_to_read] [addr:0x6060] [pc:0x140808585, ktuhistrecusegcrtmain()+1173]errors in file e:\app\xifenfei\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_ora_5192.trc (incident=45790):ora-07445: 出现异常错误: 核心转储 [ktuhistrecusegcrtmain()+1173] [access_violation] [addr:0x6060] [pc:0x140808585] [unable_to_read] []incident details in: e:\app\xifenfei\diag\rdbms\xifenfei\xifenfei\incident\incdir_45790\xifenfei_ora_5192_i45790.trcuse adrci or support workbench to package the incident.see note 411.1 at my oracle support for error and packaging details.sun mar 30 22:35:28 2014instance critical process (pid: 22, ospid: 5192) died unexpectedlypmon (ospid: 8420): terminating the instance due to error 12752
恢复数据库
idle> recover database;完成介质恢复。idle> alter database open;数据库已更改。
ora-07445 [access_violation] [unable_to_read] []记录一次数据库异常导致ipc未释放案例ora-07445[dbgrmqmqpk_query_pick_key()+0f88]oracle 12c 控制文件异常恢复ora-00600[kcratr_nab_less_than_odr]故障解决使用bbed解决ora-00600[2662]oracle 12c redo异常恢复测试—打上patch恢复完全因asm sga_target设置不当导致11gr2 rac无法正常启动 原文地址：oracle 12c ora-07445[ktuhistrecusegcrtmain()+1173], 感谢原作者分享。