连接数据库的时候老是自动断开连接,而且自动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