Tag Archives: SHUTDOWN

关闭数据库出现PMON failed to acquire latch信息

很常见的一个信息,以前并没有太在意,不过即使是这种异常信息,Oracle也认为是bug。 关闭数据库时,信息如下: Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started WITH pid=28, OS id=1294500 Tue Aug 16 … Continue reading

Posted in BUG | Tagged , | Leave a comment

ORA-600(kfioUnidentify01)错误

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(2658)错误

客户数据库在SHUTDOWN的过程中执行了取消操作,导致了ORA-600错误。 数据库版本为10.2.0.4 RAC for HP-UX,详细错误信息为: Thu Oct 22 15:05:14 2009 Shutting down instance: further logons disabled Thu Oct 22 15:05:15 2009 Stopping background process QMNC Thu Oct 22 15:05:15 2009 Stopping background process CJQ0 Thu Oct 22 15:05:17 2009 Stopping … Continue reading

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

隐含参数_DISABLE_LOGGING导致数据库的损坏

Oracle不推荐修改隐含参数,尤其是对于你不了解的隐含参数,修改的后果可能很严重。 比如如果设置了_DISABLE_LOGGING参数为TRUE: _disable_logging = TRUE 那么启动数据库后进行任何的操作,在关闭数据库后,就会发现数据库出现了损坏: SQL> ALTER system checkpoint; System altered. SQL> shutdown abort ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 6.2268E+10 bytes Fixed SIZE 2243512 bytes Variable SIZE 4160750664 bytes DATABASE Buffers … Continue reading

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

ORA-7445(kcsgrsn)错误

告警日志中出现这个错误。 错误信息如下: Thu DEC 23 01:00:02 2010 Starting background process EMN0 EMN0 started WITH pid=290, OS id=21705 Thu DEC 23 01:00:02 2010 Shutting down instance: further logons disabled Thu DEC 23 01:00:10 2010 Stopping background process QMNC Thu DEC 23 … Continue reading

Posted in BUG | Tagged , , | 1 Comment