RE: Oracle 81745 upgrade and PL/SQL version

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 27 Aug 2002 15:03:47 -0800
Message-ID: <F001.004C0E3D.20020827150347@fatcity.com>

Patrice,
You are right - I didn't put enough info in my email.

My database was at 8.1.7.2.5
I then applied 8.1.7.4.1 via the installer I then copied the files that comprise 8.1.7.4.5 to my Oracle home I then ran catalog, catproc and the other stuff from the 8.1.7.4.1 release notes.

At this stage I queried product_component_version and the PL/SQL version was shown as 8.1.7.3.

It seems no-one else has seen this.

I'll repeat the upgrade on 2 other databases (with and without JVM installed) and see if I can learn more.

Thanks,
Bruce

-----Original Message-----
Sent: Tuesday, 27 August 2002 22:19

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
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). Received on Tue Aug 27 2002 - 18:03:47 CDT