Tag Archives: ora-604

ORA-1000导致的ORA-7445错误

Posted on 2012/11/14 by yangtingkun

客户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 exceededThu Oct 28 16:32:57 2010 Errors … Continue reading →

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

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

Posted on 2012/08/19 by yangtingkun

客户在异机进行数据库的不完全恢复，用来导出被误删除的表，恢复完成后，打开数据库时出现了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 channelSQL> startup Total System Global Area … Continue reading →

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

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

Posted on 2012/07/17 by yangtingkun

客户数据库出现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)错误

Posted on 2012/05/05 by yangtingkun

客户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