Re: Patch Set for 8.1.7.4 failed to upgrade

Ed Stevens 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.

Thanks, Ed, I'll look into this as well. Thank goodness I have this unused server to practice on!

Anne Received on Tue Nov 18 2003 - 13:13:55 CST