cancel
Showing results for 
Search instead for 
Did you mean: 

Not Enough space to extend tablespace

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

audunlea_hansen
Active Participant
0 Kudos

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

Former Member
0 Kudos

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

former_member266290
Participant
0 Kudos

Hi

Check this thread :

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

Former Member
0 Kudos

Hi,

Thank you for your reply,

i checked the direcoty /sapmnt/SID/exe,

but there is no , saproot.sh file availale,

for your information we have upgraded to EHP4 from ECC6.0

pls assist.

Regards,

Irfan

former_member266290
Participant
0 Kudos

Hi

The location of this file is the directory of SAP kernel.

If you have any backup of older kernel you can copy it from there to the kernel directory.

And then execute saproot.sh script as root user, this will set permissions.

Regards

Former Member
0 Kudos

Hi,

for your information we have upgraded to EHP4 from ECC6.0

Have you deleted the old tablespace as per the information in the EHP4 upgrade documentation ?

Mark

Former Member
0 Kudos

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

check and adjust your datafile auto extend parameters. Although this will depend on where the data blocks wlll be on the datafile. But you might have some luck....

Mark

Former Member
0 Kudos

saproot.sh worked...

thanks to All.

Former Member
0 Kudos

And to verify correct permissions of executable user and folder

check note 546006 and 651351.

Regards

Vinod

Former Member
0 Kudos

Hi Irfan,

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

Regards

Vinod