| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 81745 upgrade and PL/SQL version
Bruce:
Actually I have seen this. My server installations were at 8.1.7.3 and I
applied the 8.1.7.4 patch to it. The version still says it is 8.1.7.3 and
the package STANDARD is invalid.
This was on AIX 4.3.3. On the Solaris installations, I have not had a
problem. Check out my TAR on MetaLink, TAR 13592498.6. I uninstalled
Oracle 8.1.7 and re-installed it to both servers. Then I applied the
latest patch, but the version still reported 8.1.7.3. Oracle support has
been methodical in their efforts but I will not hold my breath waiting for
a solution.
RWB "Reardon, Bruce (CALBBAY)" <Bruce.Reardon_at_comalco.riotinto.com.au> @fatcity.com on 08/27/2002 06:03:48 PM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
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" inproduct_component_version.
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-LReceived on Wed Aug 28 2002 - 12:48:22 CDT
(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: INET: Reginald.W.Bailey_at_jpmorgan.com 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).
 |
 |