on 08-26-2010 8:11 AM
Hi,
here i am getting the bellow error when executing check db in db13. i already searched in net but i am not able to get right solution ,plz can any one help me.
Job started
Step 001 started (program RSDBAJOB, variant &0000000000426, user ID PIPBASIS)
Execute logical command BRCONNECT On host pagets
Parameters: -u / -jid CHECK20100826120341 -c -f check
BR0801I BRCONNECT 7.00 (48)
BR0280I BRCONNECT time stamp: 2010-08-26 12.05.11
BR0301E SQL error -27091 at location BrInitOraCreate-5, SQL statement:
'/* BRCONNECT AT PROF_CONN */ CREATE PFILE = '/oracle/PTS/102_64/dbs/sapPTS.ora' FROM SPFILE = '/oracle/PTS/102_64/dbs/spfilePTS
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Linux-x86_64 Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1
BR0303E Determination of Oracle version failed
BR0806I End of BRCONNECT processing: cedzedva.chk2010-08-26 12.05.11
BR0280I BRCONNECT time stamp: 2010-08-26 12.05.11
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
regards
subhani.
Hi,
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
As per the [SAP note 914177 - File system reiserfs Oracle parameter filesystemio_options|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=914177] this issue is caused by the file system that is used and by the init.ora parameter filesystemio_options = setall.
Have a look at that note.
Hope this will resolve ur issue.
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Subhani,
You can set your FILESYSTEMIO_OPTIONS='setall' as you may change it to FILESYSTEMIO_OPTIONS='asynch' for imporved performance. Just try to make it change to setall and run your job.
Also have a look at below note:
Note 546006 - Problems with Oracle due to operating system errors
all the best !
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.