on 04-29-2010 3:29 PM
Hi There
We have SAP BW 3.5 on AIX 5.3 TL10. Oracle is 9i (9.2.0.7). Our users are facing problems with Cost calculation job on cubes.
The job got failed with below error
Database error 1115 at FET access to table /BI0/03538
> ORA-01115: IO error reading block from file 48 (block #
> 1144987)#ORA-01110: data file 48:
> '/oracle//sapdata11/.data35.dbf'#ORA-27091: skgfqio:
> unable to queue I/O#ORA-27072: skgfdisp: I/O error#IBM AIX
> RISC System/6000 Error: 5: I/O error
-
Database error text........: "ORA-01115: IO error reading block from file 2
(block # 214041)#ORA-01110: data file 2:
'/oracle//sapdata4/_1/.data1'#ORA-27091: skgfqio: unable to queue
I/O#ORA-27072: skgfdisp: I/O error#IBM AIX RISC System/6000 Error: 5: I/O
error"
Internal call code.........: "[RSQL/READ/RSSDBATCH ]"
More Info:
Checked alert log, no errors in alert log. checked datafiles status and everything is perfect!! The errors are appearing in SAP application logs only
Is it due to any patches missing on AIX/oracle?
Any idea guys? Looks like some oracle/AIX error?
Hello Shrinath,
please post the following content.
shell> aioo -a
Maybe you have reached the maximum number of asynchronous I/O requests.
For example in our SAP environments the following parameters are set
shell> aioo -a
minservers = 8
maxservers = 400
maxreqs = 1228
fsfastpath = 1
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
> we have already set the maximum values for aio
> Maximum number of REQUESTS 4096
That is not the maximum by far ... please try the following settings and monitor your system again.
shell> aioo -o maxreqs=16384
shell> chdev -l aio0 -a maxreqs=16384 -P
shell> aioo -a (to verify the settings)
After making that settings you have to restart your oracle database.
By the way .. all that stuff is also mentioned in metalink note #559697.1
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.