Question Re: Opatch tool in Technology Q&A

Opatch tool

Former Member — Sun, 18 May 2008 07:27:25 GMT

I have a question about Opatch? Can anybody tell me the installation steps of Opatch and how to use this tool in oracle?

Thanks

Re: Opatch tool

Former Member — Sun, 18 May 2008 11:18:47 GMT

Hi. Read this Note 306408 - OPatch: Oracle tool for patch installation.

Re: Opatch tool

andreas_herzog — Mon, 19 May 2008 06:54:25 GMT

which oracle version are you using?

opatch should be installed automatically by the oracle runinstaller...you may have to patch it...you then have to apply the path to the opatch directory + install perl v.5.8

for example (AIX and Oracle 10.2):

edit the corresponding .dbenv-file (on unix user ora<sid>, on windows user <sid>adm) by appending the line:

> set path = ( $path $ORACLE_HOME/OPatch ) #for c-shell

or:

> PATH=$PATH:$ORACLE_HOME/OPatch; export PATH #for standard shell

exit and login again to make the changes effective...then use the opatch tool in the following way:

test version:

> opatch version

check for patches applied:

> opatch lsinventory

apply interim patches:

> opatch apply <opatch number/directory> -force -silent

GreetZ, AH

Re: Opatch tool

fidel_vales — Mon, 19 May 2008 07:11:39 GMT

Hello Andreas,

you mentioned:

> opatch should be installed automatically by the oracle runinstaller

This is only true for oracle 10g. For oracle 9i it has to be downloaded and installed.

Relevant notes with explanation on how to update/patch and use

306408 OPatch: Oracle tool for patch installation

629588 Current versions of OPatch and OUI

839182 Oracle database 10g: OPatch

Re: Opatch tool

andreas_herzog — Tue, 20 May 2008 21:14:20 GMT

yup that's true...but all my examples dealt with oracle 10.2

GreetZ, AH