Not able to Create TABLESPACE PSAPROLL|PSAPUNDO with 728 MB

[Former Member]

Hi Experts,

When i an trying to upgrade PI 7.0 to pi 7.1 with EHP1 in checks roadmap in abap it throws error like

ERROR> Insufficient free space in the database as follows:

Create TABLESPACE PSAPROLL|PSAPUNDO with 728 MB

INFO> To adjust the size of your tablespaces, you may use the commands

in file '/oracle/stage/upg/abap/log/ORATBSXT.LST' using the 'brspace' utility.

Please copy the file before making changes, as it may be

overwritten in subsequent upgrade phases.

In the location

'/oracle/stage/upg/abap/log/ORATBSXT.LST

1. These are examples for brspace commands to extend/create the required

2. tablespaces. You can adapt them according to your own needs.

3. Add option '-c force' to call the commands in batch mode.

4. Change option '-autoextend' to 'yes' and set '-maxsize' and '-incrsize'

5. to create autoextensible segments.

brspace -function tscreate -tablespace PSAPROLL|PSAPUNDO -owner SAPSR3 -size 728 -autoe

xtend no

info while creating : PSAPUNDO: Command not found.

with the help of this above command i am not able to create the tablespace.

My Existing tabelspaces are

PSAPSR3

PSAPSR3700

PSAPSR3DB

PSAPSR3USR

PSAPTEMP

PSAPUNDO1

SYSAUX

SYSTEM

Plz help me on this ASAP.

Thanks,

Hari

[Former Member]

Hi,

Try exceuting the command show parameter undo; in the sql prompt. This will give you the current undo tablespace name.

In your case the current undo tablespace should be PSAPUNDO1. During the upgrade, the upgrade assistant checks for the undo tablespace (PSAPUNDO of size 728 MB), but as you have PSAPUNDO1 as your undo tablespace the UA fails to create a new undo tablespace.

So, as Eric said, try to rename the undo tablespace to PSAPUNDO from PSAPUNDO1 and also change the undo_tablespace in the controlfile. This would resolve your issue.

Regards,

Varadhu

[former_member204746]

try to rename the undo tablespace to PSAPUNDO from PSAPUNDO1 and also change the undo_tablespace in the controlfile.

the controlfile does not contain undo_tablespace, this must be changes in initSID.sap or SPFILE as I suggested earlier.

[Former Member]

Hi Harish,

Instead of using the direct command use brtools utility to create tablespace.

BR,

Darshan

[Former Member]

Hi Darshan

If i try to execute with brspace command i get like this

Tablespace name 'PSAPUNDO' should have at least 7 characters and begin with 'PSAPSR3'

Warning by checking input value for 'tablespace'

i am in upgrade process so i have not tried with brtools.

as per SAP recommend.

[Former Member]

Thats just a warning.

You should be able to go ahead with it.

Pravin

[Former Member]

After continue with it as u said it gives

The name 'PSAPUNDO' is reserved for an UNDO tablespace

Warning by checking input value for 'tablespace'

Warnings or errors occurred - you can continue to ignore them or go back to

last action

Hari

[Former Member]

Suspected that it might give that warning also

Would just go ahead as you wont be using this tablespace at all.

You have UNDO1 for your work but make it has the same amount of space as they mention.

Pravin

[former_member204746]

Your real problem is that PSAPUNDO does not exist. For an unknown reason you are using PSAPUNDO1. so, you must fix this:

shutdown your DB.

rename tablespace PSAPUNDO1 to PSAPUNDO. this can be done with:

brspace -c force -f tsalter -a rename -t PSAPUNDO1 -n PSAPUNDO

you will also need to change parameter undo_tablespace to PSAPUNDO

if using initSID.ora, change this manually. or else, do this:

alter system set undo_tablespace=PSAPUNDO scope=both;

you might need to restart your database.

good luck.

[Former Member]

Are you running the following command as ora<SID> ??

brspace -function tscreate -tablespace PSAPUNDO -owner SAPSR3 -size 728 -autoextend no

You really dont have to do the above as you have PSAPUNDO1 instead of PSAPUNDO

Pravin

[Former Member]

Hi Pravin,

Thanks for the reply

ya i am running the command in ORASID only

PSAPUNDO1 is their but throws error to create PSAPUNDO....