Skip to Content

DBChecks job shows incorrect version of oracle database after upgrade for compatible parameter

After upgrading the database when running the DBCheck job it flags the compatible parameter as being incorrect. DBCheck seems to still be using the value of the old database not the current one. I know I can correct this in transaction DB17 but I would rather find the process that changed this during the database upgrade to ensure other checks are correct. Can anyone point me in the right direction?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Mar 30 at 10:50 AM

    Hi Matt,

    Normally the compatible parameter is changed/adapted with our 'Custom Scripts' during the upgrade. If you did not include this script in the post_upgrade steps, this needs to be executed manually.

    Our Upgrade notes contains these instruction. Just like here in section( Step: Check and Set Parameter 'COMPATIBLE') of below SAP note.

    2660027 - Upgrading to Oracle Database 18c

    The same is documented in the 12.2 and 19c upgrade notes as well.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 30 at 11:15 AM

    Hi,

    You can also check SAP Note ##1739274 - "Database Parameter COMPATIBLE" which contains default and supported values for Oracle database parameter 'COMPATIBLE' in SAP environments.

    Regards,
    Bíborka

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.