db13 error while checking databse

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Varadharajan M,

here in initora.<sid> the file system option is set as fallows

" FILESYSTEMIO_OPTIONS = ASYNCH "

regards

subhani.

[Former Member]

Hi,

Try to set the Set the Oracle parameter FILESYSTEMIO_OPTIONS = NONE as mentioned in teh afore mentioned SAP note and then execute the CheckDB in DB13 once again.

Regards,

Varadharajan M

[Former Member]

hi,

can u help me how do i set that option.

regards

subhani

[Former Member]

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 !

[Former Member]

Hi,

Please check [OSS Note 914177 - File system reiserfs Oracle parameter filesystemio_options|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=914177], has the solution for your problem.

Thanks & Regards,

Sachin