azure云 ORA-00600: internal error code, arguments问题解决

1,alert日志报错如下

Tue Feb 23 09:43:37 2016
Errors in file /oracle/app/oracle/diag/rdbms/powerdes/powerdes/trace/powerdes_dbw0_49724.trc  (incident=87281):
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/powerdes/powerdes/incident/incdir_87281/powerdes_dbw0_49724_i87281.trc
Errors in file /oracle/app/oracle/diag/rdbms/powerdes/powerdes/trace/powerdes_cjq0_49830.trc:
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Trace dumping is performing id=[cdmp_20160223094338]
Errors in file /oracle/app/oracle/diag/rdbms/powerdes/powerdes/trace/powerdes_j000_54120.trc  (incident=87354):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/powerdes/powerdes/incident/incdir_87354/powerdes_j000_54120_i87354.trc
opidrv aborting process J000 ospid (54120) as a result of ORA-603
Errors in file /oracle/app/oracle/diag/rdbms/powerdes/powerdes/trace/powerdes_dbw0_49724.trc:
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
DBW0 (ospid: 49724): terminating the instance due to error 471
Tue Feb 23 09:44:13 2016
Instance terminated by DBW0, pid = 49724

2,trace日志

DUMP REDO
 Opcodes *.*
 DBAs (file#, block#):
 (3, 3744) .
 SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
 **NOTE: Only Dumping Redo less then 12 hours**
 Times: 02/22/2016 21:43:41 thru eternity

3,尝试启动

SQL> startup
ORACLE instance started.

Total System Global Area 1453092864 bytes
Fixed Size		    2213416 bytes
Variable Size		 1107298776 bytes
Database Buffers	  335544320 bytes
Redo Buffers		    8036352 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 38920
Session ID: 1 Serial number: 5


SQL> 

4,解决方案,加大db_recovery_file_dest_size

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1453092864 bytes
Fixed Size		    2213416 bytes
Variable Size		 1107298776 bytes
Database Buffers	  335544320 bytes
Redo Buffers		    8036352 bytes
Database mounted.
SQL> alter system set db_recovery_file_dest_size=12000M SCOPE=BOTH ;

System altered.

SQL> 
SQL> startup
ORACLE instance started.

Total System Global Area 1453092864 bytes
Fixed Size		    2213416 bytes
Variable Size		 1107298776 bytes
Database Buffers	  335544320 bytes
Redo Buffers		    8036352 bytes
Database mounted.
Database opened.
SQL> 
SQL> 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值