Skip to Content
0
Former Member
Sep 10, 2007 at 05:37 PM

SQL error 1115 occurred when accessing program

306 Views

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