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