[askdba] Re: How to find the latest patch applied?

  • From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Mon, 9 May 2005 15:01:43 -0400

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
> >
>
>

Other related posts: