Skip to Content

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.

11 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) 
  5. Dilkush Mukkamalla

    BTW, the ‘readme.html’ that comes along with each SBP says to run catsbp only “For Container Databases only*

    So, I doubt if it is a mandatory step for stand alone databsaes.

    however, I have run this script multiple times post upgrade to 12.1/2.* I did not notice any issue.

    (0) 
    1. James Zhang Post author

      Hi Dilkush,

      The document was for 10g, 11g, back then 12c was not referred. However I checked the 12c readme file, this is “for container database only”:

      o post-process a container database, the catsbp and rmsbp scripts require all pluggable databases (PDBs) to be open in read/write mode. Both scripts post-process the root container and all PDBs.

      ——————————————————————————————————————————

      Only this, the following section is for both container and non-container architecture.

      Best regards,
      James

      (0) 

Leave a Reply