Tag Archives: SHUTDOWN

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

Posted on 2012/11/19 by yangtingkun

很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，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)错误

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

Posted on 2012/06/01 by yangtingkun

客户数据库在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导致数据库的损坏

Posted on 2012/04/10 by yangtingkun

Oracle不推荐修改隐含参数，尤其是对于你不了解的隐含参数，修改的后果可能很严重。 比如如果设置了_DISABLE_LOGGING参数为TRUE： _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 … Continue reading →

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

ORA-7445(kcsgrsn)错误

Posted on 2012/01/28 by yangtingkun

告警日志中出现这个错误。 错误信息如下： 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