Re: Patch Set for 8.1.7.4 failed to upgrade

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 18 Nov 2003 10:03:59 -0000
Message-ID: <3fb9ee8f$0$262$ed9e5944@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)

-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk

Received on Tue Nov 18 2003 - 04:03:59 CST