Home » RDBMS Server » Server Administration » Security Patches (Oracle 10g - AIX 5)
Security Patches [message #381169] Thu, 15 January 2009 09:08 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

I want to know what are the security patches applied to my Oracle DB Server.

Eg. Need to get whether October 2008 security patch is applied.

Thanks and Regards,
Prashanth
Re: Security Patches [message #381176 is a reply to message #381169] Thu, 15 January 2009 09:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search the forum before posting.
http://www.orafaq.com/forum/m/167408/0/?srch=lsinventory#msg_167408
Re: Security Patches [message #381183 is a reply to message #381176] Thu, 15 January 2009 10:07 Go to previous messageGo to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Thanks for the info.

But in our case, I am not finding the list of Security Patches that got applied. We did the Upgrade from 10.2.0.3 to 10.2.0.4, I am getting only that info.

So if not displayed, can I consider that this patch is not applied?

O/P:

[BDDB1.vsn.net:BDDB1]/u01/app/oracle/product/10.2.0/OPatch% ./opatch lsinventory
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/oracle/product/10.2.0
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/oui
Log file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2009-01-15_11-00-50AM.log

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2009-01-15_11-00-50AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (3):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 3 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.
Re: Security Patches [message #381189 is a reply to message #381183] Thu, 15 January 2009 10:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>So if not displayed, can I consider that this patch is not applied?
May be.
Certain patches get installed as bundle(along with installation/upgrade/terminal or newer release) and will to get list in opatch.
Only the patches that were specifically installed will be listed and you will get an output like this.

Installed Patch List:
  =====================
  1) Patch 5865568 applied on Wed Mar 07 16:23:51 EST 2007
      [ Base Bug(s): 5865568  ]
  2) Patch 5632264 applied on Wed Mar 07 14:57:45 EST 2007
      [ Base Bug(s): 5632264  ]
Re: Security Patches [message #381194 is a reply to message #381169] Thu, 15 January 2009 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 352783.1: How can I see if a Critical Patch Update is installed on the database

Regards
Michel
Re: Security Patches [message #381370 is a reply to message #381194] Fri, 16 January 2009 08:35 Go to previous message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Thanks to the replies.

After applying the patch I am able to see the information while executing in os level and db level command

./opatch lsinventory

select * from registry$history;

Thanks


Previous Topic: IS there any easy way to UNDERSTAND DB....
Next Topic: Installed Database Features
Goto Forum:
  


Current Time: Fri Dec 09 21:07:03 CST 2016

Total time taken to generate the page: 0.08984 seconds