Check for the patch installed

[musaddaq_2]

We have 9iRAC(9.2.0.5) implmented with
(RAW Devices) on HP-UX platform.
I want to apply some patches on it but its patch requires following patches as pre-requisite patch
2719046: FA minipack M
or
2946358: FA minipack N

Now my quistion is how can i check for any minipack or superseeds patches installed on my system.

P.S. this thread has been moevd from HP-UX > HP-UX Technical Documentation to HP-UX > databases - Hp Forums moderator

[Joseph Loo]

hi,

i suppose the patches u have given r from Oracle. thus, u will have to run this sql statement (i think):

select * from ad_applied_patches;


regards.

[Joseph Loo]

to be more specified:

select * from apps.ad_applied_patches;

regards.

[musaddaq_2]

Thanks for replying.
I have checked the sql provided by you.
But patch_type doesnot show any minipack or familypack patches. and secondly if i want to check fom HP-UX how is it possible to c which Familypack or minipack patches is been installed.

[renarios]

Hi,

You can use swlist for that.

Cheers,

Renarios

[musaddaq_2]

I have already tried that but how to grep it properly.

[Joseph Loo]

hi,

if it is run using adpatch process, the sql statement will tell u whether the Oracle patches r install.

another way to check is from the log directory, e.g. /prod/appl/admin/PROD/log/ which is the /admin/PROD/log/

p.s. swlist will not be able to find these Oracle patches.

regards.

[musaddaq_2]

Thanks for ur suggestions.
I will try and will update u back.

Regards

Musaddaq