How to apply an Oracle patch

I am trying to apply the oracle patch # 4923787 on a windows 64 bit machine.. i have a client installation on the server and below is the path for opatch
E:\oracle\product\10.2.0\client\OPatch

The Patch to be applied is on D:\Shared\p4923787_10201_MSWIN-x86-64

I have tried to do as in read me file but , i cannot completely understand

Help me out with exact commands

thanks
LVL 16
vdr1620Asked:
Who is Participating?
 
sridharv9Connect With a Mentor Commented:
Patchset 6810189 is 10g Release 2 (10.2.0.4) Patch Set 3 for Microsoft Windows x64.
0
 
slightwv (䄆 Netminder) Commented:
any command we would give you would be the same as the read me.  What specific part of the read me is confusing you?
0
 
vdr1620Author Commented:
This is what i was trying to do as described in the Read Me File

Please see the attached file. don't know if i am doing it the right..


cmd.jpg
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
slightwv (䄆 Netminder) Commented:
You either need to set your PATH to include the OPATCH directory or fully qualify it.  I typically fully qualify it since I typically have multiple oracle homes:

c:\oracle\...\...\OPATCH\Opatch apply
0
 
slightwv (䄆 Netminder) Commented:
Also make sure ORACLE_HOME is set correctly.
0
 
vdr1620Author Commented:
What's the next step after setting the path

set ORACLE_HOME = E:\oracle\product\10.2.0\client\OPatch\OPatch apply
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You are confusing a couple of things.  ORACLE_HOME is an environment variable you need to set.  Then you fully qualify the path to opatch.

from your patch directory:

set ORACLE_HOME=E:\oracle\product\10.2.0\client
then
E:\oracle\product\10.2.0\client\OPatch\OPatch apply
0
 
vdr1620Author Commented:
Ignore the above Comment

i did the following

C:\>Set Oracle_home = E:\oracle\product\10.2.0
C:\> D:
D:\> cd Shared\p4923787_10201_MSWIN-x86-64\4923787

D:\Shared\p4923787_10201_MSWIN-x86-64\4923787> When i specify the Opatch path here..it says system cannot not apply the file..Java Could not be located..Opath can not proceed

0
 
slightwv (䄆 Netminder) Commented:
You are missing part of ORACLE_HOME.  see mine and what you posted.

You really shouldn't heed to set ORACLE_HOME unless you have multiple homes.

open a new CMD window and just do the:
E:\oracle\product\10.2.0\client\OPatch\OPatch apply
0
 
sridharv9Connect With a Mentor Commented:
Try this

C:\>Set ORACLE_HOME = E:\oracle\product\10.2.0
C:>SET PATH=%PATH%; E:\oracle\product\10.2.0\client\OPatch;E:\oracle\product\10.2.0\client\BIN
C:\> D:
D:\> cd Shared\p4923787_10201_MSWIN-x86-64\4923787
D:\>OPATCH APPLY
0
 
slightwv (䄆 Netminder) Commented:
I fail to see how adding the directory to the PATH versus fully qualifying it makes a difference.
0
 
vdr1620Author Commented:
Thanks a Lot ... Now i know how to apply the patch..

Now, its giving me an error saying that Optach failed with Error code = 255
cmd.jpg
0
 
slightwv (䄆 Netminder) Commented:
A quick Google for that error leans towards a bad ORACLE_HOME variable.

Try setting it manually after all:
set ORACLE_HOME=E:\oracle\product\10.2.0\client
0
 
vdr1620Author Commented:
tried that ..no luck
0
 
slightwv (䄆 Netminder) Commented:
See if verbose tells you what the problem might be:

opatch apply -verbose
0
 
vdr1620Author Commented:
Still gives the same error
0
 
slightwv (䄆 Netminder) Commented:
I just logged into metalink and took a look at that readme file.  That is a server patch not a client patch.

Who told you to install this on the client machine?

If you still wish to, what version of OPATCH do you have?

From the readme:
You must use opatch version 10.2.0.1.1 or later. It can be downloaded from Metalink with Patch#4898608
0
 
vdr1620Author Commented:
Thanks.. but can you help me install it .. The read me file for that instructs only Perl script commands..how do i that using Command prompt
0
 
vdr1620Author Commented:
I just replaced the Opatch folders ..and tried to run the whole thing again..now it errors out with Error code =1
0
 
slightwv (䄆 Netminder) Commented:
Install what?  The OPATCH patch (4898608)?

If you only have the Oracle client on your machine, why bother?

but OK:
From the read me I'm looking at is says perl is  and optional install method.  It should use the Opatch version you have to install the new version:

excerpt from the readme:
It can be invoked directly using

    <path to OPatch>/opatch [<patch command>] [options]


0
 
vdr1620Author Commented:
The root of the problem is described in the link below

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ab662d63-6385-4f73-b27f-d526048f601f

So far, no luck resolving the issue.. Just saw that 10.2.0.4 has a fix for all the bugs.. Do not how to apply at that..as non of them patches i have been trying just error out
0
 
slightwv (䄆 Netminder) Commented:
>>Just saw that 10.2.0.4 has a fix for all the bugs
Patch 4923787 isn't the 10.2.0.4 patchset.  It appears to be just a one-off patch.

You will need the patchset to get you to 10.2.0.4.  I can't get on to Metalink right now so I can't find it for you.

Do you need to the 10g client?  You might try the 11g client to help with the SQL Server connection.
0
 
slightwv (䄆 Netminder) Commented:
I thought about this last night and wanted to suggest the Oracle Instant Client instead of the full-blown Oracle client.

Since it appears you only need the Oracle client to connect SQL Server to Oracle the instant client should work.

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
0
 
vdr1620Author Commented:
I Have assigned the Point Incorrectly.. can you please open the Post so, that i can reassign them correctly

Thanks
0
 
slightwv (䄆 Netminder) Commented:
You never really 'closed' it.  You left a request for the mods to close it out.  AS soon as you 'objected' Mods were notified.

You should be able to close this out and assign the points yourself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.