Tag Archives: PMON

ORA-600(kffmXpGet)错误

Posted on 2012/07/10 by yangtingkun

第一次碰到Exadata上的bug。 数据库环境Exadata V2-2，数据库版本为11.2.0.2，错误信息为： Wed Apr 25 11:32:35 2012 Errors IN file /u01/app/oracle/diag/rdbms/ods/orcl2/trace/orcl2_ora_9495.trc (incident=304808): ORA-00600: internal error code, arguments: [kffmXpGet], [145], [69784], [], [], [], [], [], [], [], [], [] ORA-03135: connection lost contact Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_304808/orcl2_ora_9495_i304808.trc USE ADRCI … Continue reading →

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

ORA-7445(kssdct)和ORA-7445(kssdch)错误

Posted on 2012/06/17 by yangtingkun

Oracle 10.2.0.5数据库出现这两个ORA-7445错误后，导致实例CRASH。 很严重的问题，这个错误会直接导致实例的CRASH，而作为Oracle的10.2的最终版出现这个的错误不太应该。 错误信息为： Mon Oct 31 12:13:21 CST 2011 Errors IN file /u01/oracle/admin/orcl/udump/orcl_ora_23475.trc: ORA-07445: exception encountered: core dump [kssdct()+94] [SIGSEGV] [Address NOT mapped TO object] [0x000026D1B] [] [] Mon Oct 31 12:13:24 CST 2011 Errors IN file /u01/oracle/admin/orcl/bdump/orcl_pmon_29355.trc: ORA-07445: … Continue reading →

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

ORA-600(16480)错误

Posted on 2012/06/14 by yangtingkun

告警日志出现ORA-600 [16480]错误。 数据库版本为10.2.0.4 RAC，详细错误信息为： Mon Mar 12 23:41:27 2012 PMON failed TO acquire latch, see PMON dump Mon Mar 12 23:41:54 2012 Errors IN file /home/oracle/admin/orcl/bdump/orcl2_s004_942128.trc: ORA-00600: internal error code, arguments: [16480], [111], [0x70000080A1A5248], [], [], [], [], [] Mon … Continue reading →

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

ORA-600(kfioUnidentify01)错误

Posted on 2012/06/10 by yangtingkun

Oracle 10.2.0.4 RAC环境的ASM出现这个错误。 错误信息为： Mon Sep 19 18:06:01 2011 Shutting down instance: further logons disabled Mon Sep 19 18:06:01 2011 Shutting down instance (immediate) License high water mark = 10 Mon Sep 19 18:06:01 2011 ERROR: diskgroup DATA was NOT … Continue reading →

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

ORA-600(17175)错误

Posted on 2012/05/31 by yangtingkun

又是一个导致实例崩溃的BUG。 数据库版本10.2.0.4 RAC for Hp-UX 11.31，在出现这个错误的同时还出现了ORA-601的错误： Wed DEC 1 01:57:55 2010 Errors IN file /u01/app/oracle/admin/orcl2/bdump/orcl21_pmon_3250.trc: ORA-00600: internal error code, arguments: [17175], [255], [], [], [], [], [], [] ORA-00601: cleanup LOCK conflict Wed DEC 1 01:57:57 2010 Trace dumping IS … Continue reading →

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

ORA-7445(dbgrlWriteAlertDetail_int)和ORA-4030导致实例崩溃

Posted on 2012/05/13 by yangtingkun

客户11.2.0.2 RAC for Solaris 10 sparc单实例出现ORA-7445和ORA-4030操作，导致实例崩溃。 这个错误比较严重： 2012-05-04 02:02:26.403000 +08:00 Archived Log entry 949 added FOR thread 1 SEQUENCE 518 ID 0x70a64e83 dest 1: Archived Log entry 950 added FOR thread 1 SEQUENCE 519 ID 0x70a64e83 dest 1: Thread 1 … Continue reading →

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

中止进程导致系统HANG住

Posted on 2012/03/07 by yangtingkun

以前在11g上碰到过一次类似的情况，由于ALTER SYSTEM KILL SESSION导致资源被完全占用，在一段时间内数据库处于HANG住状态。这次又碰到类似的问题。 简单描述一下问题产生的环境，用户在进行测试，在很短的时间内连续启动了多个应用服务器，导致大量的并发进程同时连接到数据库中，致使数据库服务器CPU利用率一下冲到100%。 由于数据库的这种状态，用户决定中止一些进程来释放服务器上的资源。但是通过kill -9和alter system kill session杀掉大量的会话后，数据库服务器反而处于HANG死状态，这时连sqlplus / as sysdba都无非正常登录。 于是用户继续通过kill -9清除所有非本地连接，到最后所有连接到数据库的非本地连接已经完全被杀掉，而服务器上的CPU资源已经下降，只有Oracle的PMON进程占用了单CPU的50%左右，其他CPU完全空闲。可是此时数据库仍然无非正常登录。 此时只能通过sqlplus –prelim “/ as sysdba”方式登录，然后利用oradebug执行systemstate的dump，查看导致数据库HANG死的原因。 检查SYSTEMSTATE的DUMP文件，发现PMON进程和大量的DEAD进程都在经历library cache: mutex X等待事件。而整个DUMP文件中library cache: mutex X等待事件出现了3000多次。这个等待事件是不正常的。 查询MOS发现果然是bug：Bug 9312879 “library cache: mutex x” waits after killing sessions / PMON slow … Continue reading →

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

ORA-600(KGHALO4)错误

Posted on 2012/01/03 by yangtingkun

客户数据库频繁出现这个错误。 详细的错误信息为： Sat DEC 31 21:26:23 2011 Errors IN file /opt/app/oracle/admin/ynwcdma/bdump/ynwcdma_pmon_5510.trc: ORA-00600: 内部错误代码, 参数: [KGHALO4], [0xC0000003E80CD060], [], [], [], [], [], [] Error occured while spawning process CJQ0; error = 600 Sat DEC 31 21:26:25 2011 Errors IN file /opt/app/oracle/admin/ynwcdma/bdump/ynwcdma_pmon_5510.trc: … Continue reading →

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

由于472错误实例异常关闭

Posted on 2011/12/12 by yangtingkun

客户数据库实例异常关闭，告警日志出现472错误。 错误信息如下： Fri DEC 9 10:04:45 2011 USER: terminating instance due TO error 472 Instance TERMINATED BY USER, pid = 4993Fri Dec 9 10:04:45 2011 USER: terminating instance due to error 472 Instance terminated by USER, pid = 4993 Oracle对应的ORA-472错误信息为： … Continue reading →

Posted in ORACLE | Tagged , | Leave a comment