Patching Questions, common but important !

[yyghp]

I have 2 questions in the situation when I tried to apply patches to the existing system.

Now, I am going to upgrade our Oracle 9iAS to 10g, I followed the 10g installation guide and know that I need to apply the following patches(those i couldn't find in the system after i tried to search them with 'swlist -l product | grep ', i am not sure whether this command can avoid any hidden patches ):

PHKL_27091, PHKL_28267, PHNE_28089, PHSS_24638, PHSS_26263, PHSS_26792, PHSS_26793, PHCO_29960

For example, I want to load patch "PHKL_27091", I am confused with its "dependencies": if I follow the patch document, then
Patch Dependencies:
s800: 11.11: PHKL_27294 PHKL_27093 PHKL_27094;
but when I was going to download PHKL_27091, I found that "PHKL_27091 has the following dependencies: PHKL_27094, PHKL_27096, PHKL_27317, PHKL_28122" in the "selected patch list". So, which one should I follow ?

Another question is that if I follow one(no matter i follow the patch document or patch list), I can find a lot of sub-dependencies !
Like for PHKL_27091, there are 3 dependencies:
PHKL_27294, PHKL_27093, PHKL_27094, and when I went through their documents, I could find more dependencies under them !!! such as PHKL_27294 has PHKL_25729...
So, I really don't know how deep such Patch Tree will be ! And how many patches I have to apply before this 10g installation, maybe more than 100 patches, it's possible!!!
And some patches have "recommended" ones, I don't know whether I have to apply them too and their own dependencies as well !
And I am sure there will be an ORDER issue about how to apply so many patches like this BIG TREE !

Any similar experience or suggestions ?
Thanks a lot !

[Tom Smith_9]

If you haven't already done so, you may find it easier to load the latest gold patch bundle, it may already contain many of the patches you need along with their dependencies. Once you have finished that then you can load any that were not included.

Hope this helps.

[Fabio Ettore]

Hi,

you not have to see patch text, sometimes it gets confusion!
Just insert the ID of patch in "patch database home", for example PHKL_27091 and flag the box near the patch, usually the recommended patch is the best. Then click 'add to selected patch list'. It will get patch with the right dependencies.
Again, on left side click on 'patch database' and insert the ID of another patch and 'add to selected patch list', you will get other dependencies and so on until to download.
Don't worry, it will be good!

Best regards,
Ettore

[yyghp]

what do you mean "latest gold patch" ?
is that latest QPK ?

But there is one paragraph in the 10g installation doc:

Verify that computer has the following operating system patches, or higher:
Dec 2001 Consolidate Patches (Dec01GQPK11i_Aux_Patch B.03.02.06) or higher
PHKL_25212 vm preemption point, mlock/async_io patch
PHKL_25506 asyncio driver patch
PHKL_27091 s700_800 11.11 Core PM, vPar, Psets Cumulative, slpq1 perf patch
PHKL_28267 s700_800 11.11 thread perf, user limit, cumulative VM
PHNE_28089 s700_800 11.11 cumulative ARPA Transport patch
PHSS_24638 s700_800 11.11 HP aC++ -AA runtime libraries (aCCA.03.33)
PHSS_26263 s700_800 11.11 ld(1) and linker tools cumulative patch
PHSS_26792 s700_800 11.X ANSI C compiler B.11.11.04 cumulative patch
PHSS_26793 s700_800 11.X +O4/PBO Compiler B.11.11.04cumulative patch


So, I think even after I load the latest QPK, I still need to load those patches in the list...
However, I really hope that there is a GOLD patch bundle for this...
And I think such kind of issue will happen in some other fields, i mean it's very common issue...

Thanks again !

[yyghp]

Hi Ettore Rossi,

thanks.
but do I still need to download those dependencies of the 1st level dependencies of that specific patch ?
I mean do i need to care about those children in the 2-level, 3-level, etc., of such Dependency Tree ?

Maybe I worry about this too much, but I think it's reasonable and logical...

so...?

[Patrick Wallek]

YES! You must have all dependencies met when install a patch. That means, if patch1 depends on patch3, which in turn depends on patches 6, 7 and 8, then you must install all 5 patches. As said above your best bet is to installed the latest QPK of patches. You could also then download the patches that Oracle says you need, make them into a bundle, andn run the swinstall analysis on them. That will tell you if they have already been installed, if a superceding patch has been installed, or if you need to install them.

Patching can be a pain, but with the ITRC patch tool as described above, which resolves all dependencies for you, it is much less painful than it used to be.

[Tom Smith_9]

I believe the latest name they have given the patch bundles is GOLDBASE11i and GOLDAPPS11i. One for OS and one for HP Apps.
I believe that the lastest bundles are from Dec 03.

Here is the link to the bundle page. It has a search routine that allows you to see what bundle contains a particular patch. (You may need a registered username on the site.) You should also be able to get to the page by starting at www.hp.com -> Support & Drivers -> IT Resource Center -> Patch Database -> find a batch bundle.


Hopefully this should at least cut down on the list of patches you will need to research. It can be tedious to track down a large list of patches and the required dependencies.

[yyghp]

Hi Patrick,

What do you mean "ITRC patch tool"? where can I find this tool ?

Thanks!

[Patrick Wallek · Accepted solution]

Go to:
http://itrc.hp.com

Click on the "Patch Database" link.

That will allow you to search for patches and create your own patch bundle. It will automatically resolve all dependencies for each patch. YOu can download this patch bundle, transfer it to your HP-UX system, un-tar it and run a script to create a bundle of patches. This bundle will allow you to install all patches at once.

[Riccardo_21]

I had the same problem.
Now I only need to install Dec01GQPK11i_Aux_Patch, but I can't find it on ITRC... anyone can help me????

Thx in advace

[Thayanidhi]

Hi,
If a patch required to be installed (say as per Oracle Document), simply search these patches in ITRC patch database. The Oracle list may be bit old(generally). So, install the latest QPK, and from the search result of patches select the recommended patches and download, which in turn selects all the depandencies. No need to woory whether it's already in the system or not, becuase the swinstall will skip them anyway.

If the download size matters to you, it's bit tediuos to findout what's in the system.

If you are interested I can post here!!

regards
TT

[yyghp]

close, thanks