Oracle-L: RE: Oracle 81745 upgrade and PL/SQL version

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 27 Aug 2002 04:18:36 -0800
Message-ID: <F001.004C015B.20020827041836@fatcity.com>

Bruce,

I think the minor releases have to be applied to the first one in the series, i.e. 8.1.7.4.5 would go on top of 8.1.7.4.1..

To go from 8.1.7.2.0, follow this path:

8.1.7.2.0 --> 8.1.7.4.1. --> 8.1.7.4.5.

It may be though that 8.1.7.4.1 can only go on top of 8.1.7.3, which would add at least another step.

The first in the series usually uses the Oracle Installer; the later (minor) ones ask us to archive files and replace them manually.

I haven't applied 8.1.7.4.5, maybe that one is different.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au]

Sent:	Tuesday, August 27, 2002 1:03 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Oracle 81745 upgrade and PL/SQL version

Hi,

Yesterday I upgraded a database from 81725 to 81745 on W2K SP3 (the DB doesn't have JVM in it).
Before the upgrade, product_component_version showed the PL/SQL version as version "8.1.7.2.0".
After the upgrade, the PL/SQL version is shown as 8.1.7.3.

The product_component_version table in total shows:

Product                             Version     
----------------------------------- ---------
NLSRTL                              3.4.1.0.0
Oracle8i Enterprise Edition         8.1.7.4.1
PL/SQL                              8.1.7.3.0
TNS for 32-bit Windows:             8.1.7.4.0

So the other products are showing as 8174 but not PLSQL.

Has any one else seen this - I couldn't find any reference to it on Metalink?

We have another database that has been upgraded to 81741 (this one is on NT4 SP6a).

This one shows "PL/SQL                              8.1.7.4.0" in

product_component_version.
This one does have JVM installed so I don't know if the difference is related to that.

Any suggestions are welcome.
I don't know at this stage if this is a problem, but it is an (as yet) unexplained difference and I don't like those sort of differences.

Thanks,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------