on 07-13-2009 2:36 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
check the sapce of tabelsapce.
check Disk status. is it offline or online
for sapce u can check it by T-code DB02.
also check the Temp Table space and undo tablespace. i think when u run some task these two tables doesn't have enough sapce to run or support that task so increase it and also check the autoextend parameter of all tablespaces.
Thanks
Presu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
On OS level:
- check permission of the datafile
- compare size of the datafile and size of filesystem (HP-UX Error)
- make sure that the filesystem has enough space
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
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
This indicates there is no more space is available on the disk. Please add more space.
Thanks,
Shambo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.