Tag Archives: startup

ORA-600(KSSRMP2)错误

Posted on 2012/07/20 by yangtingkun

客户的Oracle 10.1.0.4环境碰到这个错误。 详细错误信息为： Wed DEC 14 21:10:27 2005 Errors IN file /oracle/admin/ocrl/bdump/ocrl_smon_160060.trc: ORA-00600: internal error code, arguments: [KSSRMP2], [0x1102F0128], [0], [0], [], [], [], [] ORA-01157: cannot identify/LOCK DATA file 201 – see DBWR trace file ORA-01110: DATA file 201: … 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