If you want to check for Oracle server patchsets like 9.2.0.6.x or so , check out the ../oraInventory/logs directory for the latest "installActions*.log and tail the log file as below to know the installed patches. $ tail -30 installActions2004-12-17_10-57-27AM.log Oracle OLAP Patch 9.2.0.6.0 Oracle interMedia Java Advanced Imaging Patch 9.2.0.6.0 Oracle interMedia Common Files Patch 9.2.0.6.0 Oracle interMedia Client Compatibility Files Patch 9.2.0.6.0 Oracle Wallet Manager Patch 9.2.0.6.0 Authentication and Encryption Patch 9.2.0.6.0 External Naming: NIS Patch 9.2.0.6.0 JDBC/OCI Common Files Patch 9.2.0.6.0 Oracle JDBC Development Drivers Patch 9.2.0.6.0 Oracle interMedia Locator Patch 9.2.0.6.0 Oracle Text Patch 9.2.0.6.0 iSQL*Plus Patch 9.2.0.6.0 Oracle 9iR2 Patch Set 9.2.0.6.0 Oracle Home: OraEXPRESS This Oracle Home has not been changed in this session. Oracle Home: OWB_Design This Oracle Home has not been changed in this session. Oracle Home: OWB_Serverside This Oracle Home has not been changed in this session. =============================================== > BTW , no reboot would be required to install Opatch in takes only few minutes to install. HTHU Ankur Shah Oracle DBA DHR-GA ----- Original Message ----- From: "Chirag DBA" <chiragdba@xxxxxxxxx> To: <askdba@xxxxxxxxxxxxx> Cc: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>; <oracle-dba-masters@xxxxxxxxxxxxxxx> Sent: Monday, May 09, 2005 2:48 PM Subject: [askdba] Re: How to find the latest patch applied? > Thanx Ankur n all. > > Problem is we have specified binaries in SUN to install oracle. > > You cant download and run other patches. Is this need any server reboot? > > More than 17 instances are running on this server. > > Any other way out to find. Inventory binaries or any View? > > Regards - Chirag > > On 5/10/05, Ankur Shah <ankur_ora@xxxxxxxxxxx> wrote: > > > Check if opatch is in your $PATH > >=20 > > > Need to download and install opatch if not on the system > >=20 > > > Download Opatch from Metalink by searching for patch # 2617419 > >=20 > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D > >=20 > > HTHU > >=20 > > Ankur Shah > > Oracle DBA > > DHR-GA > >=20 > > ----- Original Message ----- > > From: "Chirag DBA" <chiragdba@xxxxxxxxx> > > To: <askdba@xxxxxxxxxxxxx>; "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>= > ; > > <oracle-dba-masters@xxxxxxxxxxxxxxx> > > Sent: Monday, May 09, 2005 2:34 PM > > Subject: [askdba] Re: How to find the latest patch applied? > >=20 > > > :/ora01/app/oracle $ opatch > > > ksh: opatch: not found > > > :/ora01/app/oracle $ opatch lsinventory > > > ksh: opatch: not found > > > :/ora01/app/oracle $ opatch -r lsinventory > > > ksh: opatch: not found > > > :/ora01/app/oracle $=3D20 > > > > > > What is wrong here?=3D20 > > > > > > We have specified binaried to copy for oracle. > > > > > > Something is missing here?? > > > > > > - Regards, > > > > > > Chirag Majmundar. > > > On 5/9/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote: > > > > Hi Team, > > > >=3D20 > > > > Can anyone tell me how to find the latest patch applied on the DB? > > > >=3D20 > > > > Any Idea? I am on Solaris, Oracle version 9.2. > > > >=3D20 > > > > Regards - Chirag > > > > > > > > > > > >=20 > > > >