ORACLE Error 01114

[Former Member]

Hi All,

SAP is working on our dev environment for some conversion and perfroming some tasks.They got BELOW ERROR.

Data Base error Text ......:"ORA_01114: I0 Error writing Block to file 408

(Block #241160)#ORA27072:fILE I/O error#HPUX-ia64 error:28: NO space left

on device #additional information:4# additional information:241160 #additional information: -1#ORA01114 IO erro writing block to

Triggering SQL STATEMENT .......:"FETCH NEXT"

Internal call code .........:'[DBDS/NEW DSQL]"

Please analyze and let me know what went wrong and how to rectify the error.

Thanks in advance for the help,

Regards,

Raj

[Former Member · Accepted solution]

Data Base error Text ......:"ORA_01114: I0 Error writing Block to file 408

Make sure your drive/partition is online/accessible and has enough space.

[Former Member · Accepted solution]

Hi Manoj,

I have added 45 GB to PSAPTEMP as reocmmended by SAP people and i have taken offline backup and set DB to no archive log mode as recommended by SAP.How can i know whether enough sapce is there are not ,Is it at os level or DB level and any command to check space and to increase please let me know.

Mode is online

Thanks for all your help,

Regards,

Raj

[Former Member · Accepted solution]

read SAP notes:

Note 659946 - FAQ: Temporary tablespaces

Note 546006 - Problems with Oracle due to operating system errors

Note 583861 - UNIX: Errors due to Oracle executable

[Former Member · Accepted solution]

You can use DB02 / BRtools for space check and at OS level simply use windows explorer or du/bdf etc in case of Unix. Make sure these drives and partitions are accessible at OS level.

[anindya_bose · Accepted solution]

drop and recreate your temp tablespace.

procedure: create a new temp tablespace, make this as the default temp tablespace and drop the old one (in 9i , drop tablespace temp including contents and datafiles).

Link below can help you in dropping and recreating temp tablespace.

http://www.orafaq.com/forum/t/81733/0/

Best Regards

Anindya

Edited by: Anindya Bose on Jul 14, 2009 10:50 AM