SUM SP11 P7 – Oracle AutoExtend TableSpace Ignored

    Hi All,

    I’m in the prep stages of an SPS upgrade on our ERP 6 system.  During phase 5.4 Checks it’s stop and said manual activities required :-

    Insufficient free space in the database as follows. Please refer to file /sapsoftware/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check.

    Extend TABLESPACE SYSTEM by 341 MB

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

    in file ‘/sapsoftware/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.

    You must fulfill these requirements first before you continue with the procedure!

    Free space recommendation

    In some scenarios there might be more space required, which was not part of the calculation. Therefore we recommend to have up to 20% more free space than overall required:

    Additional 225 MB to TABLESPACE SYSTEM

    But our SYSTEM tablespace is set to autoextend and has 935.75MB free to extend into.

    Tablespace nameSize(MB)Free(MB)Used(%)AutoextendTotal size(MB)Sum of all free fragments(MB)Total used (%)#Files#Segments#ExtentsStatusContents
    SYSTEM1,124.0011.7599YES2,048.00935.755411,2143,107ONLINEPERMANENT

    Therefore we don’t need to extend the tablespace as it’s suggesting, as we have plenty free.

    Is this going to prevent me moving forward?

    UPDATE – this has stopped the update, seems to be a bug in SUM!

    Thanks

    Craig

    Hi All,I'm in the prep stages of an SPS upgrade on our ERP 6 system.  During phase 5.4 Checks it's stop and said manual activities required :- Insufficient free space in the database as follows. Please refer to file /sapsoftware/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check. Extend TABLESPACE SYSTEM by 341 MB INFO: To adjust the size of your tablespaces, you may use the commands in file '/sapsoftware/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. You must fulfill these…

    SUM SP11 P7 - Oracle AutoExtend TableSpace Ignored

    Very Helpfull

    User Rating: Be the first one !
    Vice Professor Asked on November 2, 2016 in software logistics.
    Add Comment
    1 Answer(s)

      Hello @Gabriela Pieper, @Craig Armstead, @James Wong and @Yves KERVADEC,

       

       

      I had to ask UPG Development about this intriguing information:

       

      Insufficient free space in the database as follows. Please refer to file /sapsoftware/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check.

       

       

       

      Extend TABLESPACE SYSTEM by 341 MB

       

       

       

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

      in file ‘/sapsoftware/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.

       

       

       

      You must fulfill these requirements first before you continue with the procedure!

       

       

       

      Free space recommendation

      In some scenarios there might be more space required, which was not part of the calculation. Therefore we recommend to have up to 20% more free space than overall required:

      Additional 225 MB to TABLESPACE SYSTEM

       

       

       

      The explanation is as follows: the tablespace has 840Mb free space, the calculated requirement is 1125Mb, so only 1125-841=284Mb is missing. Adding 20% as a safe margin over 284Mb gives you the figure of 341Mb.

       

      Besides this requirement SAP recommends to have another 20% of the requested 1125Mb available, which is 225Mb. So you could extend it by 384Mb to make the tool happy, but probably 341+225=556Mb is better.

       

      Development agreed this logic is confusing and difficult to understand, they informed they’ll review the coding of this particular part.

       

      I hope I could help.

       

      Best regards,

       

       

       

      Tomas Black

      Add Comment

        Hello @Gabriela Pieper, @Craig Armstead, @James Wong and @Yves KERVADEC,

         

         

        I had to ask UPG Development about this intriguing information:

         

        Insufficient free space in the database as follows. Please refer to file /sapsoftware/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check.

         

         

         

        Extend TABLESPACE SYSTEM by 341 MB

         

         

         

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

        in file ‘/sapsoftware/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.

         

         

         

        You must fulfill these requirements first before you continue with the procedure!

         

         

         

        Free space recommendation

        In some scenarios there might be more space required, which was not part of the calculation. Therefore we recommend to have up to 20% more free space than overall required:

        Additional 225 MB to TABLESPACE SYSTEM

         

         

         

        The explanation is as follows: the tablespace has 840Mb free space, the calculated requirement is 1125Mb, so only 1125-841=284Mb is missing. Adding 20% as a safe margin over 284Mb gives you the figure of 341Mb.

         

        Besides this requirement SAP recommends to have another 20% of the requested 1125Mb available, which is 225Mb. So you could extend it by 384Mb to make the tool happy, but probably 341+225=556Mb is better.

         

        Development agreed this logic is confusing and difficult to understand, they informed they’ll review the coding of this particular part.

         

        I hope I could help.

         

        Best regards,

         

         

         

        Tomas Black

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.