Re: Check for the patch installed (257 Views)
Reply
Frequent Advisor
Posts: 43
Registered: ‎01-02-2005
Message 1 of 8 (257 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

Honored Contributor
Posts: 1,981
Registered: ‎10-23-2000
Message 2 of 8 (257 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
Honored Contributor
Posts: 1,981
Registered: ‎10-23-2000
Message 3 of 8 (257 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
Frequent Advisor
Posts: 43
Registered: ‎01-02-2005
Message 4 of 8 (257 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.
Trusted Contributor
Posts: 317
Registered: ‎03-11-2005
Message 5 of 8 (257 Views)

Re: Check for the patch installed

Hi,

You can use swlist for that.

Cheers,

Renarios
Nothing is more successfull as failure
Frequent Advisor
Posts: 43
Registered: ‎01-02-2005
Message 6 of 8 (257 Views)

Re: Check for the patch installed

I have already tried that but how to grep it properly.
Honored Contributor
Posts: 1,981
Registered: ‎10-23-2000
Message 7 of 8 (257 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
Frequent Advisor
Posts: 43
Registered: ‎01-02-2005
Message 8 of 8 (257 Views)

Re: Check for the patch installed

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

Regards

Musaddaq
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.