首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

连接数据库的时候老是自动断开连接,而且自动shutdown,下面是alter日志,该怎么解决

2012-04-19 
连接数据库的时候老是自动断开连接,而且自动shutdown,下面是alter日志replication_dependency_tracking tu

连接数据库的时候老是自动断开连接,而且自动shutdown,下面是alter日志
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=9994
Mon Apr 9 20:47:23 2012
ORACLE Instance ezhou (pid = 8) - Error 600 encountered while recovering transaction (6, 13).
Mon Apr 9 20:47:23 2012
Errors in file /u01/app/oracle/admin/ezhou/bdump/ezhou_smon_9978.trc:
ORA-00600: internal error code, arguments: [25027], [1], [155941611], [], [], [], [], []
Mon Apr 9 20:47:24 2012
db_recovery_file_dest_size of 2048 MB is 78.59% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Apr 9 20:47:24 2012
Completed: ALTER DATABASE OPEN


[解决办法]
ORA-00600: internal error code, arguments: [25027], [1], [155941611], [], [], [], [], []
Mon Apr 9 21:07:29 2012
Errors in file /u01/app/oracle/admin/ezhou/bdump/ezhou_pmon_9966.trc:

600错误很棘手,分析下具体的TRAC文件
[解决办法]
db_recovery_file_dest_size of 2048 MB is 78.59% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
这个信息看起来挺关键。。。
[解决办法]
从日志看来,是在做事务回滚时遇到了BUG,可以将事务回滚屏蔽掉,然后从TRACE文件中找到有问题的对象,并DROP掉。

SQL code
        connect / as sysdba        alter system set events '10513 trace name context forever, level 2';        shutdown immediate        startup 

热点排行