On Tue, 18 Nov 2003 11:48:12 -0600, Turkbear <john.g_at_dot.spamfree.com>
wrote:
>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...
>
>
Hah! And I've found just the opposite! Either I couldn't rename it,
or it was still mysteriously locked. Seems like it depended on the
phase of the moon, but it's been nearly a year. Who says Windoz ain't
a great OS?!?!? (He says with tongue firmly planted in cheek.)
Received on Tue Nov 18 2003 - 13:37:02 CST
