ERP Upgrade complaing about creating PSAPUNDO

[Former Member]

I am doing upgrade for ERP components in BI system from 701 to 731.  While in extraction phase, system is complaining that it needs to create PSAPUNDO with 1011 MB

INSUFFICIENT FREE SPACE: Create TABLESPACE psapundo             with 1011 MB

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

      in file '/SUM/abap/log/ORATBSXT.LST' using the 'brspace' utility.

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

      overwritten in subsequent upgrade phases.

I have checked and I could see that PSAPUNDO exists and it has more than 10gb free.

Please note that db is on different host than CI from where I am running the upgrade (STARTUP/DSUGui).

Thanks and Regards,

Giridhara Tadikonda

[former_member144433]

Hi Giridhara,

Please refer the note specified below.

1035137 - Oracle Database 10g: Automatic Undo Retention

<====>

UNDO_RETENTION for undo tablespace with fix size

The system ignores the value set in the parameter UNDO_RETENTION for an

undo tablespace without AUTOEXTEND. Oracle calculates the optimal (the

highest possible) undo retention (V$UNDOSTAT.TUNED_UNDO_RETENTION)

taking into account 85% of the actual size of the undo tablespace and

the current system activity.

This is why the undo tablespace is almost full.

<====>

As per note #1035137, for productive SAP systems, we recommend:

    o  that you use undo tablespaces with fix size (AUTOEXTEND

       deactivated) or

    o  undo tablespaces with AUTOEXTEND, with the maximal file size

       limited by parameter MAXSIZE, so that no overflow or bottle neck

       occurs in the file system.

    o  The parameter UNDO_RETENTION must remain set (for LOB data, see

       below)....

The recommendation is to set the undo_retention to 12 hours as start

value. This indicated in the note #600141 which is also referenced in

the recommended settings for Oracle 11g #1431798 Oracle 11.2.0: Database

Parameter Settings. (The higher this value is set the more undo space is

required).

Thank You.

Regards,

Deepika

[srinivasan_vinayagam]

Hi Deepika,

For Oracle 11G.

Is the any fix value for parameter undo_retention.

Regards,

V Srinivasan

[Former Member]

Hi,

The tablespace needs more space , pls increase it using brtools extend tablespace option and try again and let us know.

BR,

Madhura

[Former Member]

Hi Giridhara

I think that what it's saying is 'you need to increase PSAPUNDO'.   It's been a while since I've done this upgrade (or similar) but I do recall sizing PSAPUNDO much larger for the process and then shrinking it later.  You may well need to increase it significantly.  Last time I increased mine to some 30GB and then back to 10GB after.

hope that helps,

Regards,

Graham

[Former Member]

Hi Giridhara,

The file ORATBSXT.LST contains command to create the tablespace, you just open that

file and copy the commands to command prompt which will automatically start the actions.

Only after this is met your upgrade can resume..

Thanks

Arun Hari.