Home » RDBMS Server » Server Administration » Finding out if a patch is installed
Finding out if a patch is installed [message #167331] Wed, 12 April 2006 08:23 Go to next message
madchaz
Messages: 65
Registered: October 2005
Member
Newbie question, but I'm having trouble figuring it out.

I want to know if a specific patch is installed on the system, but I can't figure out how to do it. Anyone as a pointer?
Re: Finding out if a patch is installed [message #167408 is a reply to message #167331] Wed, 12 April 2006 18:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Using Oracle Universal Installer?
Or
Using Opatch ( use opatch.pl or download the executable version from ftp site updates.oracle.som. You need metalink account)
oracle@hemlock#perl opatch.pl lsinventory -all
Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation.  All rights reserved..


Oracle Home       : /u01/10g
Central Inventory : /u01/app/oracle/product/oraInventory
   from           : /u01/10g/oraInst.loc
OPatch version    : 10.2.0.1.0
OUI version       : 10.2.0.1.0
OUI location      : /u01/10g/oui
Log file location : /u01/10g/cfgtoollogs/opatch/opatch-2006_Apr_12_19-07-20-EDT_Wed.log

Lsinventory Output file location : /u01/10g/cfgtoollogs/opatch/lsinv/lsinventory-2006_Apr_12_19-07-20-EDT_Wed.txt

--------------------------------------------------------------------------------
List of Oracle Homes:
  Name          Location
   OraDb10g_home1         /u01/10g

Installed Top-level Products (1):

Oracle Database 10g                                                  10.2.0.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.


Seems using opatch execute is better. Please check metalink.

[Updated on: Wed, 12 April 2006 18:23]

Report message to a moderator

Re: Finding out if a patch is installed [message #172534 is a reply to message #167408] Wed, 17 May 2006 02:25 Go to previous message
vipin
Messages: 40
Registered: May 2002
Member
Thank you very much.

Vipin.
Previous Topic: Information regarding audit trail for changes in tables
Next Topic: proble for temptable space growing
Goto Forum:
  


Current Time: Fri Sep 20 10:35:39 CDT 2024