Tag Archives: ora-604

ORA-1000导致的ORA-7445错误

客户10.2.0.1环境,出现了ORA-1000错误并导致了ORA-7445错误的产生。 Oracle的ORA-1000错误是个普通的问题,就是当前使用的游标值超过了OPEN_CURSOR初始化参数的值,而这个错误导致的ORA-7445错误还是第一次看到: Thu Oct 28 16:32:57 2010 Errors IN file /u01/app/oracle/admin/orcl/orcl/orcl_mmon_356528.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-00604: error occurred at recursive SQL level 2 ORA-01000: maximum OPEN cursors exceeded 在文档ORA-7445 Followed By ORA-1000 “MAXIMUM … Continue reading

Posted in BUG | Tagged , , , | Leave a comment

数据库异机恢复打开报错ORA-36961

客户在异机进行数据库的不完全恢复,用来导出被误删除的表,恢复完成后,打开数据库时出现了ORA-36961错误。 数据库版本为10.2.0.4 for HP-UX,打开数据库前台出现ORA-3113错误: SQL> startup Total System Global Area 4294967296 bytes Fixed SIZE 2073472 bytes Variable SIZE 805309568 bytes DATABASE Buffers 3472883712 bytes Redo Buffers 14700544 bytes DATABASE mounted. ORA-03113: end-of-file ON communication channel 在启动过程中,如果前台出现ORA-3113错误,那么后台多半是ORA-600或ORA-7445错误,检查告警日志,却发现出现了ORA-36961错误: Error IN executing triggers … Continue reading

Posted in ORACLE | Tagged , , , , , , , | Leave a comment

ORA-4031导致CJQ进程出现ORA-1003错误

客户数据库出现ORA-4031错误,随后出现了大量的ORA-1003和ORA-604错误。 数据库版本为10.2.0.3 RAC for HP-UX,详细的报错信息为: Mon Jul 16 15:30:30 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_2389.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable TO allocate 32 bytes OF shared memory ("shared … Continue reading

Posted in BUG | Tagged , , , , | Leave a comment

ORA-600(kgavsd_3)错误

客户9208环境出现ORA-600[kgavsd_3]错误。 错误信息为: Thu DEC 15 15:47:57 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_659472.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 2 ORA-03113: end-of-file ON communication channel ORA-03113: end-of-file ON … Continue reading

Posted in BUG | Tagged , , , , , , | Leave a comment