Skip to Content
avatar image
Former Member

ora-01654 error

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 07:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • avatar image
    Former Member
    Sep 21, 2010 at 06:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded