Problem after implementing SBP 3 for Oracle 11.2.0.2

[Jörg_Brockmann]

Hello,

we have a problem after installing SAP Bundle Patch 3 for Oracle 11.2.0.2 like discribed in SAP-Note 1503709.

During the installation procedure of this SBP (SAP_112023_201110) everything looks fine, but when we checking the version in the SAP system after the update the transaction ST04 the DB-Version stands still on 11.2.0.2.0 . We expected that the version should show Version 11.2.0.2.3 ?

When we check the table dba_registry_history (like described in SAP-Note 1175996) we could´nt find the SBP (or the integrated PSU) the table.

When we check the oracle version with sql commands the version stands still on 11.2.0.2.0

Any idea to fix the problem or a hint where we could find useful logs ?

[Jörg_Brockmann]

for information:

We start the script catsbp.sql manually and now everything looks fine (the SBP is now visible in the dba_registry_history too).

For completing the info from my post before: doing some corrections because the link.sh script has a problem = we have udated the mopatch tool an rerun the tool. After that the link.sh script was successfully.

regards

Jörg

[Jörg_Brockmann]

Hi Stefan,

after checking the mopatch log we found this entry at the end of the log:

Link Status:

Link script not executed due to patch conflicts. Please check the log file $ORACLE_HOME/cfgtoollogs/mopatch/mopatch-<date>.log for details. Resolve the conflicts as described in SAP note 1027012. Re-start MOPatch to execute the link script or execute it manually as /bin/sh "./link.sh"

We also checked the single opatch logs and found some errors / problems. After doing some corrections an re-run the mopatch tool the mopatch log ends with these entries:

Link Status:

Link script "./link.sh" executed successfully.

Then we check your recommended commands again:

1.) The oracle_home looks much better than before:

10248523 12419331 Wed Nov 09 14:02:17 CET 2011 DATABASE PSU 11.2.0.2.1

11724916 12419331 Wed Nov 09 14:02:17 CET 2011 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)

GRID PSU

12419331 12419331 Wed Nov 09 14:02:17 CET 2011 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)

11.2.0.2.2 PSU (HIGHER CPU POSSIBLE

2.) But there is still no change/advancement executing the sql command.

Any ideas how we could fix the entry in the registry$history ? Or it´s an normal behaviour ?

regards

Jörg

[Jörg_Brockmann]

Hello Stefan,

thank your for the quick response and the hint with the oracle note 861152.1

When I execute your commands for checking the versions the results are:

1.) 24-MAY-11 03.48.38.744804 PM 1 APPLY 11.2.0.2 PSU

PSU 11.2.0.2.1

2.) 10248523 10248523 Tue May 24 12:00:40 CEST 2011 DATABASE PSU 11.2.0.2.1

The expected version 11.2.0.2.3 is obviously not implemented.

The PSU 11.2.0.2.1 was implemented during the upgrade vom Oracle Version 10 to 11 in May 2011.

Is it now possible to install the 11.2.0.2.3 PSU (without reinstalling the SBP 3 ?). Or which other solutions are possible ?

best regards

Jörg

[stefan_koehler]

Hi Jörg,

Is it now possible to install the 11.2.0.2.3 PSU (without reinstalling the SBP 3 ?). Or which other solutions are possible ?

No - the PSU is included in the SBP, so you can not install it additionally. But with your posted output you have not applied the SBP SAP_112023_201110 to the current ORACLE_HOME.

The oracle inventory and the database have not applied the SBP. If you just forget to run the SQL script afterwards, you would even find some information in oracle inventory, but there is also nothing.

You need to check why there is no SBP applied to that current ORACLE_HOME.

Regards

Stefan

[stefan_koehler]

Hi Jörg,

We expected that the version should show Version 11.2.0.2.3 ?

No - Oracle PSUs don't change the oracle release version/fifth digit. That is also described in metalink note #861152.1.

You can verify the installed PSUs / SBPs with the following query (check the comment section):

SQL> set linesize 500
SQL> select substr(action_time,1,30) action_time, substr(id,1,10) id, substr(action,1,10) action,
            substr(version,1,8) version, substr(BUNDLE_SERIES,1,6) bundle, substr(comments,1,20) comments
     from registry$history; 

... or you can run opatch

shell> cd $ORACLE_HOME/OPatch
shell> ./opatch lsinv -bugs_fixed | grep PSU 

Regards

Stefan