ORA-00600 [kfioTranslateIO03][17090]

今天一同事打psu补丁后,数据库起不来。我试了一下单节点启动

SQL> startup
ORACLE instance started.

Total System Global Area 1.1758E+10 bytes
Fixed Size                  2239056 bytes
Variable Size            2013267376 bytes
Database Buffers         9663676416 bytes
Redo Buffers               79237120 bytes
ORA-03113: end-of-file on communication channel
Process ID: 9559
Session ID: 177 Serial number: 1

查看alert 日志:

ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/corebank_jy/corebank1/incident/incdir_48250/corebank1_ckpt_9890_i48250.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/corebank_jy/corebank1/trace/corebank1_ckpt_9890.trc  (incident=48251):
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/corebank_jy/corebank1/incident/incdir_48251/corebank1_ckpt_9890_i48251.trc
Dumping diagnostic data in directory=[cdmp_20170407113759], requested by (instance=1, osid=9890 (CKPT)), summary=[incident=48250].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 9890 
Dumping diagnostic data in directory=[cdmp_20170407113759], requested by (instance=1, osid=9890 (CKPT)), summary=[incident=48251].
PMON (ospid: 9819): terminating the instance due to error 469
System state dump requested by (instance=1, osid=9819 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/app/oracle/diag/rdbms/corebank_jy/corebank1/trace/corebank1_diag_9831.trc
Dumping diagnostic data in directory=[cdmp_20170407113800], requested by (instance=1, osid=9819 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 9819

一般遇到连接不上oracle ,我会检查bin/oracle权限
检查:oracle
ls -l oracle
grid:
-rwsr-s–x 1 grid oinstall 204400823 Nov 20 16:29 oracle

oracle:
-rwsr-s–x 1 oracle oinstall 232845330 Apr 7 10:56 oracle

权限都对。根据MOS ORA-00600 [kfioTranslateIO03] [17090] (文档 ID 1336846.1)

Solution #1] Group information for $RDBMS_HOME/bin/oracle should be changed to the group that can read/write to ASM devices. 

Please execute the following action plan from note 1084186.1.

$ su - grid
$ cd <Grid Home>/bin
$ ./setasmgidwrap o=<11.2 RDBMS Home>/bin/oracle

Solution #2]  Reinstall correct ASMlib that matches up to Linux version on the server.

Solution #3]  Change config.c entry to "asmadmin" and "relink all" as grid user after unlocking GRID home
                      See note 1536057.1 on how to unlock GRID home for relink all.

执行:
./setasmgidwrap o=/oracle/app/oracle/product/11.2.0/dbhome_1/bin/oracle

[grid@rifcdbs1 bin]$ srvctl start database -d corebank 
[grid@rifcdbs1 bin]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rifcdbs1                                     
               ONLINE  ONLINE       rifcdbs2                                     
ora.DATADG.dg
               OFFLINE OFFLINE      rifcdbs1                                     
               OFFLINE OFFLINE      rifcdbs2                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       rifcdbs1                                     
               ONLINE  ONLINE       rifcdbs2                                     
ora.OCR.dg
               ONLINE  ONLINE       rifcdbs1                                     
               ONLINE  ONLINE       rifcdbs2                                     
ora.asm
               ONLINE  ONLINE       rifcdbs1                 Started             
               ONLINE  ONLINE       rifcdbs2                 Started             
ora.gsd
               OFFLINE OFFLINE      rifcdbs1                                     
               OFFLINE OFFLINE      rifcdbs2                                     
ora.net1.network
               ONLINE  ONLINE       rifcdbs1                                     
               ONLINE  ONLINE       rifcdbs2                                     
ora.ons
               ONLINE  ONLINE       rifcdbs1                                     
               ONLINE  ONLINE       rifcdbs2                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rifcdbs1                                     
ora.corebank.db
      1        ONLINE  ONLINE       rifcdbs1                 Open,Readonly       
      2        ONLINE  ONLINE       rifcdbs2                 Open,Readonly       
ora.cvu
      1        ONLINE  ONLINE       rifcdbs1                                     
ora.oc4j
      1        ONLINE  ONLINE       rifcdbs1                                     
ora.rifcdbs1.vip
      1        ONLINE  ONLINE       rifcdbs1                                     
ora.rifcdbs2.vip
      1        ONLINE  ONLINE       rifcdbs2                                     
ora.scan1.vip
      1        ONLINE  ONLINE       rifcdbs1  

发表评论

电子邮件地址不会被公开。 必填项已用*标注