We are performing patching and SUM has prompted to create a tablespace. We tried to create tablespace from brtools we got below error,
ORA-19502: write error on file "/oracle/SID/sapdata4/sr3750x_1/sr3750x.data1", block number 271360 (block size=8192)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: 4294967295
Additional information: 1048576
-----------------------------------------
But we could see files are created inside oracle/SID/sapdata4 but not datafiles and no tablespace.
We tried to execute the create query from sql and got below error.
SQL> create tablespace PSAPSR3750X extent management local autoallocate segment space management auto datafile '/oracle/SID/sapdata4/sr3750x_1/sr3750x.data1' size 32700M autoextend on next 20M maxsize 32700M;
create tablespace PSAPSR3750X extent management local autoallocate segment space management auto datafile '/oracle/SID/sapdata4/sr3750x_1/sr3750x.data1' size 32700M autoextend on next 20M maxsize 32700M
*
ERROR at line 1:
ORA-19502: write error on file "/oracle/SID/sapdata4/sr3750x_1/sr3750x.data1",
block number 271360 (block size=8192)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: 4294967295
Additional information: 1048576
Thank you,
Liz