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: [EMAIL PROTECTED] -----Original Message----- [mailto:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
