on 04-09-2011 10:42 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
And to verify correct permissions of executable user and folder
check note 546006 and 651351.
Regards
Vinod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Irfan,
This means there is not enough space on Disk. Free up some space or extend file system size.
Regards
Vinod
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 | |
6 | |
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.