Mike, I too find it almost impossible to find & understand Oracle patches!
What I found for NT (that's your OS isn't it?):
Patchset 2376472 is from June 2002 and gives you version 8.1.7.4.1 - it does not say that it is for EE only.
Since then there have been a lot of Patches, latest being 8.1.7.4.10
I've had some "conversations" with MeatLink (sorry, MetaLink) about the Security Alerts:
Alert #54 seems to have been "accidentally" fixed by 8.1.7.4.1 (the problem was discovered after the solution existed!)
Other Alerts up to #51(?) need 8.1.7.4.10
Well that's what I believe to be true . . . and that's what I'm doing (for EE).
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Originally posted by DaPi I've had some "conversations" with MeatLink (sorry, MetaLink) about the Security Alerts:
Alert #54 seems to have been "accidentally" fixed by 8.1.7.4.1 (the problem was discovered after the solution existed!)
Other Alerts up to #51(?) need 8.1.7.4.10
This info from MeatLink is apparently CRAP.
Just found Note:237172.1 on MeatLink saying that for alert #54 you need patch 2899111 (this is 8.1.7.4.9) which, it turns out, is missing a file in the NT version - so in fact you need patch 2904997 (8.1.7.4.10)
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Dapi,
While applying patchset 8.1.7.4.10, I encountered the following error, while trying to execute prvtbfla.plb(this is one of four scripts suggested we should run, others ran sucessfully). This is on Win 2000. I was applying this patchset on 8.1.7.4.1.
Code:
SQL> conn sys/change_on_install@amdata;
SQL> @d:\oracle\ora81\rdbms\admin\prvtbfla.plb
Warning: Package Body created with compilation errors.
SQL> show err
Errors for PACKAGE BODY DBMS_REPCAT_FLA:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00201: identifier 'DBMS_REPCAT_FLA' must be declared
1/14 PLS-00304: cannot compile body of 'DBMS_REPCAT_FLA' without its
specification
Any ideas on what it could be. Could not find anything on Metalink.
The installation notes for 8.1.7.4.7 say that this is only if you have Advanced Replication - I guess this line got dropped from this patch readme.txt
If anyone from Oracle is watching: the whole patch area is a heap of 5H1T - the installation instructions are always wrong and first-line MeatLink doesn't have a clue either.
BTW the two .map files go in HOME\bin (only used in some error tracing apparently) - that's missing from the instructions too.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
You might need to run catexp.sql as well - depends on which version you are coming from. I've run it - it doesn't hurt to do it when it's not needed.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Thank You Dapi. No, I am not using Replication. So I guess I can ignore that error. I agree that running catexp.sql after installing patches is always a good idea. You never know when you face Oracle 0904 Error.
Have to say, Installing Oracle patchsets is really cumbersome. You never know if you have missed any files while manually copying at thier respective directories. This is more bad coz there is no way to know what patchsets have been applied. V$version, product_component_version, Oracle\Inventory\Patchsets all give incomplete information.
Originally posted by patel_dil Have to say, Installing Oracle patchsets is really cumbersome. You never know if you have missed any files while manually copying at thier respective directories.
Absolutely! I consider it unacceptably unprofessional for the files not to be supplied in a directory structure.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Reply With Quote
Bookmarks