oracle 12c ora 00600,ORACLE 12C ORA-07445[ktuHistRecUsegCrtMain()+1173]

在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 0

PL/SQL Release 12.1.0.1.0 - Production 0

CORE 12.1.0.1.0 Production 0

TNS for 64-bit Windows: Version 12.1.0.1.0 - Production 0

NLSRTL Version 12.1.0.1.0 - Production 0

oracle 12c启动报错

idle> startup

ORACLE 例程已经启动。

Total System Global Area 400846848 bytes

Fixed Size 2440024 bytes

Variable Size 281019560 bytes

Database Buffers 109051904 bytes

Redo Buffers 8335360 bytes

数据库装载完毕。

ORA-03113: 通信通道的文件结尾

进程 ID: 5972

会话 ID: 242 序列号: 3

alert日志报ORA-07445: 出现异常错误: 核心转储 [ktuHistRecUsegCrtMain()+1173]错

Sun Mar 30 22:35:22 2014

SMON: enabling cache recovery

Sun Mar 30 22:35:23 2014

Exception [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.trc

Use 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 2014

Instance Critical Process (pid: 22, ospid: 5192) died unexpectedly

PMON (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无法正常启动