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

  • From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx, chiragdba@xxxxxxxxx
  • Date: Thu, 12 May 2005 00:01:06 -0500

hi chirag,

i suppose you can check with RDA also..thanx..take care..subodh

----- Original Message -----
From: "Chirag DBA" <chiragdba@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: How to find the latest patch applied?
Date: Tue, 10 May 2005 01:03:44 +0530

>=20
> We have our internal tool to provide info. Got from there.
>=20
> Dont have a folder called ../oraInventory/logs as specified by Ankur.
>=20
> But this will be surely useful Outside SUN.=3D20
>=20
> Thanx all.
>=20
> Regards - Chirag
>=20
> On 5/10/05, Ankur Shah <ankur_ora@xxxxxxxxxxx> wrote:
> > If you want to check for Oracle server patchsets like 9.2.0.6.x or so ,
> > =3D20
> > check out the ../oraInventory/logs directory for the latest
> > "installActions*.log and tail the log file as below
> > to know the installed patches.
> > =3D20
> > $ 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.=3D
> 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.
> > =3D20
> > =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
> > =3D20
> > > BTW , no reboot would be required to install Opatch in takes only few
> > minutes to install.
> > =3D20
> > HTHU
> > =3D20
> > Ankur Shah
> > Oracle DBA
> > DHR-GA
> > =3D20
> > ----- 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?
> > =3D20
> > > 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 rebo=
ot=3D
> ?
> > >
> > > 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
> > > >=3D3D20
> > > > > Need to download and install opatch if not on the system
> > > >=3D3D20
> > > > > Download Opatch from Metalink by searching for patch # 2617419
> > > >=3D3D20
> > > >
> > =3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D=3D
> 3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D
> > > =3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > > >=3D3D20
> > > > HTHU
> > > >=3D3D20
> > > > Ankur Shah
> > > > Oracle DBA
> > > > DHR-GA
> > > >=3D3D20
> > > > ----- Original Message -----
> > > > From: "Chirag DBA" <chiragdba@xxxxxxxxx>
> > > > To: <askdba@xxxxxxxxxxxxx>; "Oracle-L Freelists"
> > <oracle-l@xxxxxxxxxxxxx>=3D3D
> > > ;
> > > > <oracle-dba-masters@xxxxxxxxxxxxxxx>
> > > > Sent: Monday, May 09, 2005 2:34 PM
> > > > Subject: [askdba] Re: How to find the latest patch applied?
> > > >=3D3D20
> > > > > :/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 $=3D3D3D20
> > > > >
> > > > > What is wrong here?=3D3D3D20
> > > > >
> > > > > 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,
> > > > > >=3D3D3D20
> > > > > > Can anyone tell me how to find the latest patch applied on the =
DB=3D
> ?
> > > > > >=3D3D3D20
> > > > > > Any Idea? I am on Solaris, Oracle version 9.2.
> > > > > >=3D3D3D20
> > > > > > Regards - Chirag
> > > > > >
> > > > >
> > > > >
> > > >=3D3D20
> > > >
> > >
> > >
> > =3D20
> >



Good Luck..Subodh Deshpande

=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Experience Is Knowledge
Wisdom Is Philosophy
=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D








--=20
_______________________________________________
NEW! Lycos Dating Search. The only place to search multiple dating sites at=
 once.
http://datingsearch.lycos.com


Other related posts: