Re: Patch Set for 8.1.7.4 failed to upgrade

Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<iomkrvctvtp3gb2tnknak31674007q4m1t_at_4ax.com>...
> 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...

I think this is because the MSDTC or whatever the heck it is is smart enough to follow the name change. Similar to open inodes on unix.

jg

--
@home.com is bogus.
Time to stop reading.