Versin Number does not change after applying SAP Bundle Patch

[Former Member]

Hi all,

After applying the SAP Bundle Patch 11.2.0.2.12 ,when entering sqlplus

I still see the version number 11.2.0.2.2. I applied the Patch with Mopatch.

regards,

[Reagan]

You apply the SBP for a specific release and patch level. A budle patch (SBP) update will not be reflected when you run sqlplus -version or connect to the database using sqlplus "/as sysdba"

If you want to see the SBP applied on the system then you should query the dba_registry_history as suggested or run opatch lsinventory.

The version information when you call sqlplus will be changed when you do a patch set update. Eg: Patch set update from 11.2.0.2 to 11.2.0.3

Cheers

RB

[former_member207186]

Hi Shatti,

Please refer to SAP note #1696147 - "How to determine the list of Oracle patches or SAP Bundle Patches (SBP) that are installed in SAP system".

Also you can query from dba_registry_history
SQL> select * from dba_registry_history;

Please also note that Patchset Updates basically don't change the Oracle release version (fifth digit).

Regards,
Bíborka

[fidel_vales]

This is "almost" good.

The installation of the SBP has some "postinstallation" steps that are the ones updating the tables below the dba_registry_history.

Unfortunatelly a lot of "people" do not read the "README" for the SBP installation and do not execute those steps. Therefore the information on the view is "obsolete".

checking the oracle inventory gives you all the installed patches, unfortunatelly, if your SBP is old then you are also "lost" with the amount of pathches there.

If you run the script "Configuration_Patches_SBPLevel" from the SAP Note 1438410 you can get a clear "picture" of your system patches (from SAP point of view)

The first column will show you the Oracle Version (eg. 11.2.0.2.0)

The second column will show you the Date of last SBP implementation (updated when catsbp.sql post processing script is executed)

The 3rd column will show you the SBP level according to DBA_REGISTRY_HISTORY (updated when catsbp.sql post processing script is executed)

the 4th column will show you the minimum SBP in place based on existing _FIX_CONTROL values

the 5th column will show you the maximum SBP in place based on existing _FIX_CONTROL values.

All columns should be in "sync" if the last two indicate that there is a SBP installed and the 3rd one has a differnet one (lower or empty, in general) then you have not applyed the SBP postinstallation scrips and so on.

it could be also interesting to check the document "Identifying Your Oracle Database Software Release"

The last number (platform specific release number) does not change with the patches (at least in UNIX, I think it might be updated in windows) for that reason you have to use indirect way tofind out

[ACE-SAP]

Hello

You could get the detailed of the installed patch using the here under optach command

Regards

Windows

%ORACLE_HOME%\Opatch\opatch lsinventory -all | find "PATCH"

Unix

$ORACLE_HOME/OPatch/opatch lsinventory -all | grep "Patch Set"

[former_member188883]

Hi Shatti,

You may check the updated version using SQL command

SQL> select * from product_component_version;

or

SQL> select * from v$version;

Regards,

Deepak Kori