Re: Patch Set for 8.1.7.4 failed to upgrade

Ed Stevens <nospam_at_noway.nohow> wrote:

>On Tue, 18 Nov 2003 07:40:28 -0800, Anne Nolan
><MUNGEanneDOTnolanNOSPAM_at_rts-group.com> wrote:
>
>>
>>
>>Paul Drake wrote:
>>
>>> Anne Nolan <MUNGEanneDOTnolanNOSPAM_at_rts-group.com> wrote in message news:<3FB92FBE.9C75204D_at_rts-group.com>...
>>> > Glen A Stromquist wrote:
>>> >
>>> > > Anne Nolan wrote:
>>> > >
>>> > > > We have an instance of Oracle 8.1.7.0 on a (now unused) server, running
>>> > > > on Windows NT 4. I thought I'd take the opportunity to upgrade this to
>>> > > > 8.1.7.4, to learn about the process.
>>> > > >
>>> > > > I downloaded the patch set from Oracle (81741_nt_release.zip), unzipped
>>> > > > the file, and slavishly followed the directions in the README file (I
>>> > > > used the "silent installation" option for step 4 of the process, running
>>> > > > setup.exe). Things proceeded with no problems. When I was all done, I
>>> > > > checked the version in v$session:
>>> > > >
>>> > > > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
>>> > > > PL/SQL Release 8.1.7.0.0 - Production
>>> > > > CORE 8.1.7.0.0 Production
>>> > > > TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
>>> > > > NLSRTL Version 3.4.1.0.0 - Production
>>> > > >
>>> > > > There's no sign of any version change. (!?!)
>>> > > >
>>> > > > I guess I can run through the whole thing again, but it was agonizingly
>>> > > > slow (the computer is a 300 MHz Celeron, 256 MB of RAM).
>>> > > >
>>> > > > I have googled for some discussion of this, without success. I was
>>> > > > hoping that some kind soul in this group could shed some light on why
>>> > > > nothing seems to have happened to the Oracle version. Is there some
>>> > > > step that I must have omitted? Was it a mistake to use the "silent
>>> > > > installation" option?
>>> > > >
>>> > > > Thanks in advance for any information.
>>> > > >
>>> > > > Anne Nolan
>>> > > >
>>> > > when you sign on (or off) sqlplus you should see the patched version
>>> > > number, or select banner from v$version
>>> > >
>>> > > hth
>>> >
>>> > Sadly, my SQL*Plus login shows just 8.1.7.0. And it was v$version I used..
>>> > the "session" was an error.
>>> >
>>> > Thanks,
>>> > Anne
>>>
>>> Anne,
>>>
>>> even when run in a silent mode, the oui will create logs of the patch
>>> install.
>>> Please check the logs in C:\Program Files\Oracle\Inventory\logs
>>>
>>> Was there virus protection software running (realtime scan)?
>>> Might some other software hava had a handle (lock) on
>>> d:\oracle\ora81\bin\ociw32.dll or something similar?
>>>
>>> I'd re-run the patchset with a non-silent install.
>>>
>>> hth.
>>>
>>> Paul
>>
>>Thanks, Paul. I'll have a look at the logs to see if there's any light to be shed there. I'm pretty sure I shut
>>all Oracle stuff off but it's worth another try... and I didn't even consider the antivirus angle.
>>
>>Regards,
>>
>>Anne
>
>Anne,
>
>I've found that it's often not enough to stop all the Oracle services.
>In particular, ociw32.dll often seems to get locked by other services
>as well, though off the top of my head I can't remember which ones.
>Go to http://sysinternals.com/ntw2k/utilities.shtml and get a copy of
>Process Explorer. It's a neat utility that will show every process
>that is executing a given DLL. I had to resort to this during our
>last round of upgrades.

Oddly, I have found that even though you may not be able to delete one of those files, you can rename it ( say to ociw32.dllold) and then continue with the installation... Received on Tue Nov 18 2003 - 11:48:12 CST