Re: Patch Set for 8.1.7.4 failed to upgrade

Sybrand Bakker wrote:

> 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
>
> --
> Sybrand Bakker, Senior Oracle DBA

Given that this is the output from v$version (not v$session.. my posting error), how then can I tell whether or not my instance (or any given instance) has been patched to 8.1.7.4? What do I do to display the server banner?

Thanks,

Anne Nolan Received on Mon Nov 17 2003 - 14:27:29 CST