Unable to extend tablespace.

[Former Member]

Dear Guru's,

When i try to extend PSAPUNDO tablespace, faced the following error.

BR0370I Directory /oracle/WIQ/sapreorg/seekobzp created

BR0280I BRSPACE time stamp: 2010-10-25 16.53.22

BR0301E SQL error -1587 at location BrCtlCopy-1, SQL statement:

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/WIQ/sapreorg/seekobzp/cntrlWIQ.old''

ORA-01587: error during control file backup file copy

ORA-27091: unable to queue I/O

ORA-27072: File I/O error

IBM AIX RISC System/6000 Error: 25: Not a typewriter

Additional information: 7

Additional information: 643

Additional information: 98304

BR0320E Copying of control file to /oracle/WIQ/sapreorg/seekobzp/cntrlWIQ.old failed

BR0280I BRSPACE time stamp: 2010-10-25 16.53.22

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

BR1008I End of BRSPACE processing: seekobzp.tse 2010-10-25 16.53.22

BR0280I BRSPACE time stamp: 2010-10-25 16.53.22

BR1007I BRSPACE terminated with errors

Later on when i tried with any other tablespace, i get the following error.

Error log is as follows..

BR0280I BRSPACE time stamp: 2010-10-25 17.50.05

BR0370I Directory /oracle/WIQ/sapreorg/seekohac created

BR0280I BRSPACE time stamp: 2010-10-25 17.50.06

BR0301E SQL error -1587 at location BrCtlCopy-1, SQL statement:

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/WIQ/sapreorg/seekohac/cntrlWIQ.old''

ORA-01587: error during control file backup file copy

ORA-27091: unable to queue I/O

ORA-27072: File I/O error

IBM AIX RISC System/6000 Error: 25: Not a typewriter

Additional information: 7

Additional information: 643

Additional information: 57344

BR0320E Copying of control file to /oracle/WIQ/sapreorg/seekohac/cntrlWIQ.old failed

BR0280I BRSPACE time stamp: 2010-10-25 17.50.06

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

BR1008I End of BRSPACE processing: seekohac.tse 2010-10-25 17.50.06

BR0280I BRSPACE time stamp: 2010-10-25 17.50.06

BR1007I BRSPACE terminated with errors

Please help..

[former_member524429]

Hi,

ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 25: Not a typewriter

OS release level ?

Oracle Release ?

Along with the above suggestions, Make sure that You have applied the required IBM AIX Fixes respective to OS release level ( as per SAP Note 977410) and required Oracle Intreme Patches/Patchset (as per SAP Note 980152).

Also an error ORA-27091: unable to queue I/O may points to low value of maxreqs parameter (asynchronous I/O parameter) as per [Oracle Metalink 559697.1|https://support.oracle.com:443/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(from=BOOKMARK&bmDocTitle=ORA-01115%20ORA-01110%20ORA-27091%20ORA-27072%20Error:%205:%20I/O%20error&bmDocDsrc=KB&bmDocType=PROBLEM&bmDocID=559697.1&viewingMode=1143))].

Regards,

Bhavik G. Shroff

[former_member204746]

IBM AIX RISC System/6000 Error: 25: Not a typewriter

Have you installed a typewriter?

Seriously, check umask, it should be set at 022

also, check permission of these directories:

/oracle

/oracle/WIQ

/oracle/WIQ/sapreorg

[Former Member]

First, which userID you are using to extend your database?

You must use ora<SID> userID and what is the permission for below directory.

/oracle/WIQ/sapreorg

also do you have freespace on this directory?