on 09-21-2010 7:28 AM
Hi all,
We are getting this following short dump in our system.
ora-01654 unable to extend index sapsr3.d010inc~1 by 8192 in the tablespace psapsr3701.
When i checked in the db02 the tablespace was having sufficient space.I tried to add another data file to it.
I was getting the below error then.
ORA-01119: error in creating database file
'/oracle/DS3/sapdata1/sr3701_9/sr3701.data9'
ORA-27040: file create error, unable to create file
Could someone help us in understanding the issue.Thanks.
Hi,
ORA-01119: error in creating database file
'/oracle/DS3/sapdata1/sr3701_9/sr3701.data9'
ORA-27040: file create error, unable to create file
The issue seems to be because of permission. Make sure that u have required permission for the file system '/oracle/DS3/sapdata<n>'.
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Eventhough u seem to have enough space at the OS, the actual disk space might have been occupied if the datafiles are set to auto extend. Try to turn off the auto extend so that u can gain some space at the OS level. Then try to extend the tablespace by adding a new datafile.
Steps to turn off the auto extend.
Login to the server as ora<SID>
Execute BRTools
2 - Space Management
5 - Alter data file
c - cont
c - cont
4 - Turn off autoextend
Select the datafile for which u want to turn off the tablespace by entering the corresponding number(for example 1).
c - cont
c - cont
Repeat the steps mentioned above till u gain space at the OS level.
Hope this will resolve ur issue.
Regards,
Varadharajan M
Hi,
Whenever a new datafile is added with autoextend "ON", a file will be generated with the size specified and not the max size. But some space (specified for the next extend) will also be occupied at the OS level but that will not be visible(meaning, u could see free space at the OS level but actually it was occupied by the datafiles) and when the entire disk space is occupied, u will not be able to add a new datafile or the DB will not be able to extend the existing datafiles eventhough there seems to be some free space available at the OS level.
Hope this clarifies.
Mark this thread as answered as ur issue got resolved.
Dear Ambarish,
Please give environment details.
Did you tried anything else than mentioned above post? May be try a quick restart of DB should work ..
Regards
Shailesh Mamidwar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.