Oracle 11g Upgrade PLUS the SBP - When to run catsbp.sql?

[richard_howard]

My Database is 10.2.0.4.

I've installed 11.2.0.1. I've ran the mopatch.sh to apply all of the 39 patches in the SBP (11.2.0.1.2 201009).

The next step in the README-SBP.html instructions is to run catsbp.sql and rmsbp.sql scripts. Then, I still need to follow all the steps in the README-PSU.html instructions in order to complete the SBP procedure.

The Oracle 11g Upgrade Guide in section 3.4.5 doesn't really cover where you should stop in the SBP process, just the opposite. It says to follow the README instructions. But it doesn't seem right to run catsbp.sql and rmsbp.sql for the SBP when I haven't yet run DBUA to upgrade to 11.2.0.1, unpatched.

Bouncing around between the Upgrade Guide to the Notes to the README's makes it hard to tell what should be run a what point.

Has anyone worked through this process and can provide some clarity?

[Former Member · Accepted solution]

Dear Richard,

please have a look at the SAP note 1431793.

Regards

Shailesh Mamidwar

[richard_howard · Accepted solution]

Thanks for the reply, Shailesh. I have that note printed and I'm using it as reference.

Unfortunately, that's where my dilema is. There is nothing in the documentation or this note that says DO NOT run the scripts that are part of the SBP (catsbp.sql). So I have to assume that I do not. I'm going to run all of the scripts and the DBUA according to 1431793. I was hoping that someone could confirm that is the thing to do.

I also have the dilema of what to do with the PSU that is included in the SBP. Do I go ahead and run the opatch apply for 9654983, but again assume that you DO NOT run the "@catbundle.sql psu apply" that follows the PSU?

For tonight, I'm going to do the mopatch.sh and the opatch apply but I"m not going to run any scripts. I'll just use DBUA to do all of that. Hope it works, but much rather that the documentation clearly state one way or another.

[Former Member · Accepted solution]

I would love to have sap chime in here. I too find it confusing. I just applied SAP_112012_201010_AIX.zip.

Afterwards I just ran @?/sapbundle/SAP_112012_201010/catsbp.sql.

I would think I am done but not sure.

Below is what came out after applying SAP_112012_201010_AIX.zip but I did not do any of those steps as the README for SBP SAP_112012_201010_AIX.zip does not say when to do those steps - so I ignored

=======================================

Patch Post Installation Status:

-

---

The following patches (may) require special post installation

steps. Please note that the list and the instructions given

below may not be accurate, check the patch READMEs for complete

information.

The post installation steps of rolled back patches must be

executed before the post installation steps of newly installed

patches.

Rolled back patches:

+ 8795792

+ 8889137

! 9352237

+ 9657085

Installed patches:

! SAP_112012_201010_AIX.zip!9654983

+ SAP_112012_201010_AIX.zip!9930151

+ SAP_112012_201010_AIX.zip!9864538

+ SAP_112012_201010_AIX.zip!9584028

+ SAP_112012_201010_AIX.zip!9458152

+ SAP_112012_201010_AIX.zip!8889137

+ SAP_112012_201010_AIX.zip!8795792

+ SAP_112012_201010_AIX.zip!10007936

Patches marked with a "!" are Patchset Updates. To complete

their installation or roll-back, run SQL script "catpsu" or

"catpsu_rollback", respecitively.

Patches marked with a "+" update SQL scripts in the Oracle Home

and most likely require extra post installation steps.

[Former Member]

Hi Richard,

if you are upgrading from 10.2.0.4 to 11g, you need to apply all patches of RDBMS software on top of 11.2.0.1. All database related post upgrade steps can be executed after you run DBUA. By doing this way, you might notice majority of the post SBP patching steps have been taken care of by DBUA. But it does not hurt to rerun them.

I am not fully understand your question of PSU part, I thought SBP includes PSU. You should only run catsbp.sql.

rmsbp.sql is for removing sbp. You do NOT need to run that if you do not want to rollback the sbp.

Thanks,

Michael S. Wang

[stefan_koehler]

Hello Richard,

SAP introduced with the SBP of August the script "catsbp.sql" which executes the other ones like catbundle.sql, etc.

Regarding to "README BUGSFIXED_201008_LINUX.htm":

Most of the post-installation instructions and post-deinstallation instructions consist of SQL packages that need to be recompiled. These and all other pure SQL instructions are now executed as part of the catsbp.sql or the rmsbp.sql scripts included in this SBP.

Regards

Stefan

[richard_howard]

Thanks Stefan. The problem I encountered was that it was too soon for me to run the catsbp.sql following the mopatch.sh application of the pathes.

What happens is that you first Install 11g. Then, you run mopatch.sh to apply the SBP. At this point, I wanted to run the catsbp.sql to recomplie but I had yet to run DBUA to fully upgrade the actual Database to 11g. So running the catsbp.sql BEFORE running the DBUA did not work or make sense.

Sandeep, my mopatch.sh result was the same as yours. I did not run the catsbp.sql or follow any of the subsequent steps in the directions. Instead, I went forth with running my DBUA to finish the upgrade and I had successful results. My assumption is that installing 11g and running the mopatch stages all of the binary files that Oracle needs. Then, running the DBUA handles all of the execution of the SQL packages to complie the Database and get it ready to open.

The Upgrade Guide for 11g definitely needs to incorporate the proper steps for including the SBP. The instructions done separately leaves you to make assumptions.

[Former Member]

Re: I did not run the catsbp.sql or follow any of the subsequent steps in the directions. Instead, I went forth with running my DBUA to finish the upgrade

I would think that after you get your db to 11 (after the catupgd script; or dua if that is what your use) you still have to run catsbp.sql... No??

I agree.. SAP needs clarification. I still am unsure what to do with the Mopatch patch post install output. As of now I did nothing.

I thought SAP monitors these forums?

[stefan_koehler]

Hello Sandeep,

sorry but i don't get your point.

The documentation states the whole procedure - you just need to read carefully (for example for SBP of July).

To extract the SAP Bundle Patch documentation and additional README files contained in this SBP, run MOPatch on the SBP in documentation mode as follows:
/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -d -s SAP_112011_201007_AIX.zip
MOPatch extracts the SBP documentation to a file named README-SBP.html. If the SBP contains a PSU or CPU that has not been installed already, MOPatch extracts their documentation to files named README-PSU.html or README-CPU.html, respectively."

The only "tricky" part is that you have to run this command before applying the SBP to ORACLE_HOME, otherwise you are not able to generate the READMEs anymore.

So the procedure is pretty clear:

1) Install 11g R2 Software

2) Run the documentation command from above and apply actual SBP

3) Upgrade your database to 11g R2

4) Follow the instructions of the SBP/PSU/CPU README

As i already mentioned - SAP introduced the catsbp.sql script to simplify the post steps.

Regards

Stefan

[richard_howard]

Stefan,

Thanks, this actually helps because nowhere in the documentation have I found these steps fo follow.

1) Install 11g R2 Software
2) Run the documentation command from above and apply actual SBP
3) Upgrade your database to 11g R2
4) Follow the instructions of the SBP/PSU/CPU README

In the Upgrade Guide:

3.4.3 - Install the 11g R2 Software (no problem here)

3.4.5 - Generate the Documentaion and apply the SBP

The READM-SBP.html provides the steps for applying the SBP, including section

3.5 Executing Post-Installation Instructions. This is where someone is inclined to

proceed with running the catsbp.sql but you really can't if you haven't upgraded the DB.

Nowhere in any of the documentation does it say run mopatch.sh to apply the 39 patches, then Upgrade your database to 11g R2 (with DBUA), and then come back to do all of these Post-Installation steps for the SBP and PSU.

I'm glad you said something because otherwise, I would have left out that last step in the process. Actually, I've already started my DB without doing these last steps, so I'll need to go back and do that.

Regards,

Richard

[Former Member]

Thanks Stefan.

Could someone clarify what I do with the below output from mopatch?

Installed patches:

! SAP_112012_201010_AIX.zip!9654983

+ SAP_112012_201010_AIX.zip!9930151

+ SAP_112012_201010_AIX.zip!9864538

+ SAP_112012_201010_AIX.zip!9584028

+ SAP_112012_201010_AIX.zip!9458152

+ SAP_112012_201010_AIX.zip!8889137

+ SAP_112012_201010_AIX.zip!8795792

+ SAP_112012_201010_AIX.zip!10007936

do i have to go into each + and run something additional? and if so..when...after I have successfully migrated from 10.2.0.4 to 11.2?

[richard_howard]

Sandeep,

Michael Wang is with Oracle and he's confirmed what Stefan was telling us with the four steps:

1) Install 11g R2 Software
2) Run the documentation command from above and apply actual SBP
3) Upgrade your database to 11g R2
4) Follow the instructions of the SBP/PSU/CPU README

After you've ran mopatch.sh and got the result you show, go ahead and move on to the 11g Upgrade using DBUA. As DBUA runs through all of it's steps, many of the steps needed after running mopatch will get done but it's prudent to then return to the README-SBP.html file and resume tasks in 3.5 Executing Post-installation Instructions. (catsbp.sql) If it repeats steps done in DBUA, that's ok.

Because the SBP includes a PSU, you also need to follow the post-installation steps that are in the README-PSU.html starting in section 2.3.3.2 Loading Modified SQL Files into the Database. After that, I believe you are done.

Regards,

Richard

[Former Member]

For this:

Installed patches:

! SAP_112012_201010_AIX.zip!9654983

+ SAP_112012_201010_AIX.zip!9930151

+ SAP_112012_201010_AIX.zip!9864538

+ SAP_112012_201010_AIX.zip!9584028

+ SAP_112012_201010_AIX.zip!9458152

+ SAP_112012_201010_AIX.zip!8889137

+ SAP_112012_201010_AIX.zip!8795792

+ SAP_112012_201010_AIX.zip!10007936

It is interesting how I went thru each one marked with a "+" and there is no README. The only one that has a README is the one marked with a "!" - of which it is the catbundle - so if you run it again.. no big deal.

I do not know if it is SAP or Oracle that has the verbage "Patches marked with a "+" update SQL scripts in the Oracle Home and most likely require extra post installation steps"

Of which I do not see any..