OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Security Patches (Oracle 10g - AIX 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Security Patches [message #381169]

Thu, 15 January 2009 09:08

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

Report message to a moderator

Re: Security Patches [message #381176 is a reply to message #381169]

Thu, 15 January 2009 09:36

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Security Patches [message #381183 is a reply to message #381176]

Thu, 15 January 2009 10:07

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.

Report message to a moderator

Re: Security Patches [message #381189 is a reply to message #381183]

Thu, 15 January 2009 10:25

Mahesh Rajendran
Messages: 10708
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  ]

Report message to a moderator

Re: Security Patches [message #381194 is a reply to message #381169]

Thu, 15 January 2009 10:53

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Metalink note 352783.1: How can I see if a Critical Patch Update is installed on the database

Regards
Michel

Report message to a moderator

Re: Security Patches [message #381370 is a reply to message #381194]

Fri, 16 January 2009 08:35

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:47:00 CST 2024