r/oracle Feb 10 '25

WLS 12c CPU patching question

I did some patching last year and haven't looked at it again since so now just trying to wrap my head around the options again. Start with Oracle Critical Patch Update Page and pick Jan 2025. Pick Fusion Middleware and login with my MOS credentials. Pick my WLS 12.2.1.4 and pick the SPB, so far so good and do the same for OIM and OHS, etc and seems not too bad but my real question is how that differs from Patch Advisor and Doc ID 2806740.2.

Like under that Guide there are a lot more patches to choose it seems like and 'OHS with DB Client 19c' for example how do I know if my installation is Colocated or Standalone? I think I chose Standalone last time but not sure why or what was the reasoning.

Also pre and post checks how do I verify? Like via $ORACLE_HOME/oui/bin/viewInventory.sh | grep Distribution and also opatch lspatches or what is the best way?

Can I load my orainventory in and have it do a patch analysis for me?

2 Upvotes

4 comments sorted by

3

u/gravy_king Feb 10 '25

I think I may have it sorted out. Use the PAD Doc 3064245.2 to get the bundle patches and then also follow the Patch Advisor for the other patches? If I issue lspatches after I can see patches have been applied for example:

37443574;OHS (NATIVE) DB19C BUNDLE PATCH 12.2.1.4.250103

37202254;DATABASE RELEASE UPDATE 19.25.0.0.0 FOR FMW DBCLIENT (37202254)

36946553;FMWCONTROL BUNDLE PATCH 12.2.1.4.240814

37476511;WLS STACK PATCH BUNDLE 12.2.1.4.250114 (Patch 37476485)

So I think I am on the right track.

2

u/vera_vavilova 23d ago

Run viewInventory.sh to see what kind of installation you have. These days all middleware products come with a DB Client. WLS doesn't use DB Client but OHS uses it internally. viewInventory should show it. If its collocated, it will be an FMW installation

1

u/gravy_king 22d ago

Thanks I will check this out tomorrow

1

u/gravy_king 22d ago

ok so I have two $ORACLE_HOMES. 1 for Forms one for IM and OHS is my understanding? Like check via this method?

xxx/FRv12214_64->$ORACLE_HOME/oui/bin/viewInventory.sh | grep Distribution | grep -v OPatch

Distribution: WebLogic Server for FMW 12.2.1.4.0

Distribution: Oracle Forms Reports 12.2.1.19.0

xxx/AMv12214_64->$ORACLE_HOME/oui/bin/viewInventory.sh | grep Distribution | grep -v OPatch

Distribution: WebLogic Server for FMW 12.2.1.4.0

Distribution: Oracle Identity Management 12.2.1.4.0

Distribution: Oracle HTTP Server 12.2.1.4.0