We are getting the next error in the first time of some action, for example I try to change the password of user in the transaction SU01 and when try to save I get the dump, then try again to save and it works. Whit other transactions happens the same case, the first time gets the dump but if you try again it works fine.
ERROR:
Database error text........: "ORA-01115: IO error reading block from file 21
(block # 388580)#ORA-01110: data file 21:
'/oracle/DES/sapdata3/des620_3/des620.data3'#ORA-27091: skgfqio: unable to
queue I/O#ORA-27072: skgfdisp: I/O error#IBM AIX RISC System/6000 Error: 1:
Not owner"
Triggering SQL statement...: "SAPMH5A0 "
Internal call code.........: "[REPO/*/OPBR/LOAD/SAPMH5A0 ]"
We already run a Filesystem check in the server (in the filesystem /oracle/DES/sapdata3) without errors, the Symetrix Storage do not send errors in the disks, the server log do not show errors about disk.
We already run the DBVerify Utility without errors:
orades> dbv file=/oracle/DES/sapdata3/des620_1/des620.data1 blocksize=8192
DBVERIFY: Release 9.2.0.7.0 - Production on Fri Sep 7 23:22:15 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /oracle/DES/sapdata3/des620_1/des620.data1
DBVERIFY - Verification complete
Total Pages Examined : 409600
Total Pages Processed (Data) : 144161
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 97689
Total Pages Failing (Index): 0
Total Pages Processed (Other): 139897
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 27853
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 3143690702 (0.3143690702)
orades> dbv file=/oracle/DES/sapdata3/des620_2/des620.data2 blocksize=8192
DBVERIFY: Release 9.2.0.7.0 - Production on Fri Sep 7 23:23:03 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /oracle/DES/sapdata3/des620_2/des620.data2
DBVERIFY - Verification complete
Total Pages Examined : 409600
Total Pages Processed (Data) : 137543
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 94393
Total Pages Failing (Index): 0
Total Pages Processed (Other): 149152
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 28512
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 3143690708 (0.3143690708)
orades> Pdbv file=/oracle/DES/sapdata3/des620_3/des620.data3 blocksize=8192
ksh: Pdbv: not found.
orades> dbv file=/oracle/DES/sapdata3/des620_3/des620.data3 blocksize=8192
DBVERIFY: Release 9.2.0.7.0 - Production on Fri Sep 7 23:23:59 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /oracle/DES/sapdata3/des620_3/des620.data3
DBVERIFY - Verification complete
Total Pages Examined : 396800
Total Pages Processed (Data) : 139971
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 108430
Total Pages Failing (Index): 0
Total Pages Processed (Other): 123679
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 24720
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 3143690575 (0.3143690575)
orades> dbv file=/oracle/DES/sapdata3/des620_4/des620.data4 blocksize=8192
DBVERIFY: Release 9.2.0.7.0 - Production on Fri Sep 7 23:25:28 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /oracle/DES/sapdata3/des620_4/des620.data4
DBVERIFY - Verification complete
Total Pages Examined : 407040
Total Pages Processed (Data) : 146300
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 101438
Total Pages Failing (Index): 0
Total Pages Processed (Other): 122017
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 37285
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 3143690708 (0.3143690708)
orades> dbv file=/oracle/DES/sapdata3/des620_5/des620.data5 blocksize=8192
DBVERIFY: Release 9.2.0.7.0 - Production on Fri Sep 7 23:29:15 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /oracle/DES/sapdata3/des620_5/des620.data5
DBVERIFY - Verification complete
Total Pages Examined : 409600
Total Pages Processed (Data) : 142166
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 108776
Total Pages Failing (Index): 0
Total Pages Processed (Other): 121853
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 36805
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 3143690574 (0.3143690574)
Best Regards.
Reynaldo Rebolledo