Skip to Content
avatar image
Former Member

Not Enough space to extend tablespace

Dear All,

I am unable to extend the tablespace, i get the following error when i try to extend the tablespace using BRtools.

Error "

-


BR1049W Not enough free space in /oracle/QAS/sapdata/sapdata4/sr3_21 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 10859.463 MB

BR1049W Not enough free space in /oracle/QAS/sapdata/sapdata4/sr3_21 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 33199.463 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRSPACE time stamp: 2011-04-09 12.55.10

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRSPACE time stamp: 2011-04-09 12.55.14

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2011-04-09 12.55.14

BR1091I Next data file can be specified now

BR0675I Do you want to perform this action?

BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

n

BR0280I BRSPACE time stamp: 2011-04-09 12.55.16

BR0257I Your reply: 'n'

BR0678I The action will be skipped...

BR0280I BRSPACE time stamp: 2011-04-09 12.55.16

BR0370I Directory /oracle/QAS/sapdata/sapreorg/sefpxusk created

BR0280I BRSPACE time stamp: 2011-04-09 12.55.16

BR0301E SQL error -1580 at location BrCtlCopy-1, SQL statement:

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/QAS/sapdata/sapreorg/sefpxusk/cntrlQAS.old''

ORA-01580: error creating control backup file /oracle/QAS/sapdata/sapreorg/sefpxusk/cntrlQAS.old

ORA-27040: file create error, unable to create file

Solaris-AMD64 Error: 13: Permission denied

BR0320E Copying of control file to /oracle/QAS/sapdata/sapreorg/sefpxusk/cntrlQAS.old failed

BR0280I BRSPACE time stamp: 2011-04-09 12.55.16

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

BR1008I End of BRSPACE processing: sefpxusk.tse 2011-04-09 12.55.16

BR0280I BRSPACE time stamp: 2011-04-09 12.55.16

BR1007I BRSPACE terminated with errors

-


TableSpace sizes

1 - PSAPSR3 20/20 71413760 99.99 10688 204800000

2 - PSAPSR3700 20/20 48537600 0.00 48536320 204800000

3 - PSAPSR3701 4/0 65024000 81.68 11913280 65024000

4 - PSAPSR3DB 3/3 5120000 18.80 4157440 30720000

5 - PSAPSR3USR 1/1 40960 5.31 38784 10240000

6 - PSAPTEMP 1/1 2048000 0.00 2048000 10240000

7 - PSAPUNDO 1/1 9256960 0.00 9256896 10240000

8 - SYSAUX 1/1 307200 94.81 15936 10240000

9 - SYSTEM 1/1 983040 98.62 13568 10240000

pls assist.

Thanks,

Irfan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 09, 2011 at 10:58 AM

    Hi Irfan,

    This means there is not enough space on Disk. Free up some space or extend file system size.

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 09, 2011 at 11:10 AM

    And to verify correct permissions of executable user and folder

    check note 546006 and 651351.

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 09, 2011 at 08:45 PM

    Hi

    Check this thread : Error in Add Data File by using Extend Table Space

    Login as root and execute

    #cd /sapmnt/SID/exe/

    #./saproot.sh SID

    Also check the free diskspace.

    Regards

    Edited by: VijayIngle on Apr 9, 2011 10:46 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 10, 2011 at 05:09 PM

    Hi Irfan,

    Your directory:

    /oracle/QAS/sapdata/sapdata4/

    Shall be expanded, or you may want to put the extension to another directory with enough freespace.

    Regarding with the permission error, a workaround is to allow write for everybody on /oracle/QAS/sapdata/sapreorg/sefpxusk/

    chmod g+w /oracle/QAS/sapdata/sapreorg/sefpxusk/

    chmod o+w /oracle/QAS/sapdata/sapreorg/sefpxusk/

    But in my opinion, those command shall be used only in emergency, such as a program testing is imminent.

    You will still need to find the saproot.sh and execute it. I believe it is supplied in a the kernel. Try download it.

    Hope this help.

    Thank you

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2011 at 07:46 PM

    Hi!

    Normally I got this warnings when I have tablespaces with datafile maxsizes in summary are bigger than awaiable space on disk. Are You using 'autoextend on' option on your datafiles? If not, check if You can.

    PSAPSR3700, isn't it empty? I see you have listed PSAPSR3701. If I don't remember wrong, a part of the upgrade are to delete the empty tablespace from the database including datafiles on disk.

    Regards

    Audun

    DBA

    Add comment
    10|10000 characters needed characters exceeded