Re: Patch Set for 8.1.7.4 failed to upgrade

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3fb9ee8f$0$262$ed9e5944_at_reading.news.pipex.net>...
> "Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message
> news:ch5irv4o9f0d62tjgf52fa83u6d4f87vl0_at_4ax.com...
> > On Mon, 17 Nov 2003 08:39:33 -0800, Anne Nolan
> > <MUNGEanneDOTnolanNOSPAM_at_rts-group.com> 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
> >
> >
> > You are showing the client banner. The client banners sign-on doesn't
> > change. The server banner does.
> >
> > Other than that, according to a Metaclunk note, only *upgrades* will
> > show changed sign-on's on Microsux, *patches* won't
>
> Then the note is incorrect.
>
> SQL> select banner from v$version;
>
> BANNER
> -------------------------------------------------------------
> Oracle9i Release 9.2.0.3.0 - Production
> PL/SQL Release 9.2.0.3.0 - Production
> CORE 9.2.0.3.0 Production
> TNS for 32-bit Windows: Version 9.2.0.3.0 - Production
> NLSRTL Version 9.2.0.3.0 - Production
>
> SQL> conn user/pass_at_8i
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
> Connected.
> SQL> select banner from v$version;
>
> BANNER
> -------------------------------------------------------------
> Oracle8i Release 8.1.7.4.1 - Production
> PL/SQL Release 8.1.7.4.0 - Production
> CORE 8.1.7.2.1 Production
> TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> SQL>
>
> I'd agree with Paul and try rerunning in non-silent mode. You will also need
> to stop other services (like the apache web server and the semi-intelligent
> agent)

oops.
I usually forget about those, as they go to "Disabled" right after install around here.

thanks.

Pd Received on Tue Nov 18 2003 - 10:55:12 CST