DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: patchset for Oracle Standard Edition 8.1.7

Hybrid View

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    patchset for Oracle Standard Edition 8.1.7

    Hi all,

    I couldn't find out any info on metalink about Standard Edition, I only find stuffs and I guess they are all Enterprise Edition. Coule questions.

    1. what is the lastest patchset for Oracle 8.1.7???
    2. patchset number if there is one.

    Would it be the same pathset with Enterprise Edition????


    thanks
    Last edited by mike2000; 04-30-2003 at 06:03 PM.

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    What platform?

    For Solaris 64bit..

    I found: Patchset::2376472

    They're out there... search for it
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  5. #5
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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.

    TIA.
    -- Dilip

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    me too !!!

    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

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  8. #8
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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.

    Thanks.
    -- Dilip

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    catalog.sql runs catexp.sql, and as we all know we must run catalog.sql after patching so to be honest there is no really need to run catexp.sql oke!

    I have applied quite a few 8.1.7.4 and other patches in linux and unix, straight forward so this is probably only windows problem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width