Home  >  Article  >  Database  >  ORA-00600: internal error code, arguments: [opifal.1]

ORA-00600: internal error code, arguments: [opifal.1]

WBOY
WBOYOriginal
2016-06-07 17:33:49989browse

Oracle版本:10.2.0.2 并做已做data guard,最近在主库oracle alert日志发现,最近半个月,几乎每天都会产生一次ora 600错误

Oracle版本:10.2.0.2 并做已做data guard
操作系统:linux rhat 5.6 x64

最近在主库oracle alert日志发现,最近半个月,几乎每天都会产生一次ora 600错误,如下:
Errors in file/oracle/admin/hycrm/bdump/hycrm_s000_27823.trc:
ORA-00600: internal error code, arguments: [opifal.1], [], [], [],[], [], [], []

备库的alert日志有
Errors in file/oracle/admin/hycrm/bdump/hycrm_mrp0_8323.trc:
ORA-16099: internal error ORA-00600 occurred at standbydatabase


查看主备的tnsnames.ora的dg配置如下:
hycrm =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.110.23)(PORT =1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME =hycrm)
    )
  )
hycrm_std =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.110.24)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
      (SID= hycrm)
    )
  )

发现主库连接串中缺少(SERVER =DEDICATED),添加后,跟踪观察,ora 600错误消失。
此错误应该和专有模式连接有关系。

相关阅读:

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏,或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn