RE: Keeping track of patches/ Patchset Installations

For one of patches, if the file undo_pre<patch_no> is present then the patch has been applied, or, unfortunately, the files were copied from somewhere which had the patch applied. You cannot install a patch when undo_pre<patch_no> is present.

Pathsets themselves are tracked by oui. But how does one tell if all the post-patch installation scripts were run? For instance, there anything to confirm that catalog.sql was run after a patchset was applied?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----
Sent: Tuesday, April 29, 2003 1:32 PM
To: Multiple recipients of list ORACLE-L

Try installing the patch again if possible.

For OUI installed patches, the installer will know if it has already been installed.

FWIW, in 10i, OEM appears to do a good job of tracking patches.

Jared

On Tue, 29 Apr 2003, Morrin, Liam wrote:

> Good afternoon all,
>
> Is there any way of telling which individual patches have been applied
> to a database?
>
> For instance I am running 8.1.7.4 (on Solaris 8) and have just applied
> patch 2832809 following a recent security alert. When I query
> v$version it still shows as 8.1.7.4.0. How would anybody know that I
> have applied this patch?
>
> I can find no reference to the patch number in
> ../oraInventory/Patches.
>
> Many thanks,
> Liam
>
>
>
>
> ###########################################
>
> This message has been scanned by F-Secure Anti-Virus for Microsoft
> Exchange. For more information, connect to http://www.F-Secure.com/
>
>
> This communication and the information it contains: - (a) Is intended
> for the person(s) or organisation(s) named above and for no other
> person(s) or organisation(s). Access to this mail by anyone else is
> unauthorised. (b) Is confidential, and may be legally privileged or
> otherwise protected in law. Unauthorised use, circulation, copying or
> disclosure of any part of this communication may be unlawful. (c) May
> be susceptible to interference, and should not be assumed that it has
> come in its original form and/or from the stated sender or PinkRoccade
> UK accepts no responsibility for information, errors or omissions in
> this e-mail or use or misuse thereof or any act done or omitted to be
> done in connection with this communication. If you are not the
> intended recipient, please inform postmaster_at_pinkroccade.co.uk
> immediately and delete it and all copies from your system.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Morrin, Liam
> INET: Liam.Morrin_at_pinkroccade.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <jkstill_at_cybcon.com
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).