Check for the patch installed (107 Views)
Reply
Frequent Advisor
musaddaq_2
Posts: 43
Registered: ‎01-02-2005
Message 1 of 8 (107 Views)

Check for the patch installed

[ Edited ]

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

Please use plain text.
Honored Contributor
Joseph Loo
Posts: 1,981
Registered: ‎10-23-2000
Message 2 of 8 (107 Views)

Re: Check for the patch installed

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.
what you do not see does not mean you should not believe
Please use plain text.
Honored Contributor
Joseph Loo
Posts: 1,981
Registered: ‎10-23-2000
Message 3 of 8 (107 Views)

Re: Check for the patch installed


to be more specified:

select * from apps.ad_applied_patches;

regards.
what you do not see does not mean you should not believe
Please use plain text.
Frequent Advisor
musaddaq_2
Posts: 43
Registered: ‎01-02-2005
Message 4 of 8 (107 Views)

Re: Check for the patch installed

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.
Please use plain text.
Trusted Contributor
renarios
Posts: 317
Registered: ‎03-11-2005
Message 5 of 8 (107 Views)

Re: Check for the patch installed

Hi,

You can use swlist for that.

Cheers,

Renarios
Nothing is more successfull as failure
Please use plain text.
Frequent Advisor
musaddaq_2
Posts: 43
Registered: ‎01-02-2005
Message 6 of 8 (107 Views)

Re: Check for the patch installed

I have already tried that but how to grep it properly.
Please use plain text.
Honored Contributor
Joseph Loo
Posts: 1,981
Registered: ‎10-23-2000
Message 7 of 8 (107 Views)

Re: Check for the patch installed

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.
what you do not see does not mean you should not believe
Please use plain text.
Frequent Advisor
musaddaq_2
Posts: 43
Registered: ‎01-02-2005
Message 8 of 8 (107 Views)

Re: Check for the patch installed

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

Regards

Musaddaq
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation