I still see some people forget to execute catsbp.sql after upgrade database. In the SBP installation guide (readme file), it has below content:

Capture.PNG

The point 5 lets us know we do not need to execute 6, 7 during upgrade, but the guide does not mention whether we should do this after upgrade. After testing upgrading from 10g to 11g again, we definitely need to run catsbp.sql after upgrade! If we do not run this script, the oracle internal dictionary is not updated. For example, we cannot query SBP information from dba_registry_history.

So by following the oracle upgrade guide and SBP readme file, below should be the right steps:

1. install oracle software only

2. install SBP by referring the readme file (note: it tells us we don’t need to execute catsbp.sql in this phase)
3. dbua
4. database upgrade post actions
5. back to SBP readme file and run catsbp.sql, utlrp.sql for target instance.

Best regards,
James

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

      1. Gaurav Rana

        You could find it in README.html file of Oracle® Database SAP® Bundle Patch 12.1.0.2.4 – 201509 under section 2.2 Installing the SAP Bundle Patch.

        (0) 
  1. Igor Taratutin

    I’ve just finished installing Oracle® Database Patch (21551086) version 12.1.0.2.9 on Windows and I still don’t see reference to those scripts in readme.html.

    Maybe it’s not required anymore?

    (0) 
    1. James Zhang Post author

      Hi Igor,

      Thanks for your attention.

      catsbp.sql is the script for Unix OS, however the similar script in windows is catbundle.sql. I checked both 11g and 12c readme file.


      for 11g, the readme explicitly execute catbundle.sql. However 12c does not explicitly execute

      catbundle.sql, just mentions one word catbundle.sql.


      You just follow up the readme file for 12c.


      All we can do is to strictly following up the readme file. 🙂


      Best regards,

      James




      (0) 
  2. José Manuel Salguero

    Many thanks James for sharing this. Very good point.

    It’s not actually clearly stated in the Upgrade guide that we have to continue with the point 7 of the README, but it makes a lot of sense. It just says that you need to run the post-installation steps, which is another section (2.3) in the README file.

    Thanks.

    Cheers.

    (0) 
    1. James Zhang Post author

      yes, it is not clear, so many people did not apply catsbp.sql finally. Also since the system will be running without executing catsbp.sql. so it is hard for people to remember this.

      However in some cases, there will be some weird problems if we do not run catsbp.sql

      (0) 
  3. Jan Heinik

    It’s quite clear to that catsbp must be launched after SBP installation, upgrade etc. Usually SAP system is stopped.

    We have a debate with no clear anwer here – what would happen in case SAP system would be online during catsbp run? What exactly happens/might happen to a SAP system? Data in oracle data dictionary are updated by catsbp but SAP should load fresh information from data dictionary every time they’re neede, right?
     

    (0) 
  4. James Zhang Post author

    Hi Jan,

    I don’t know what will happen. You already executed catsbp.sql during sap online? If so, you can raise a ticket to SAP to confirm, otherwise you have to avoid run catsbp.sql when sap is online.

     

    Best regards,
    James

    (0) 

Leave a Reply