FAQ
If you're running 10.2.0.4 cpu patch 24, is there a version number for this like 10.2.0.4.24?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

Search Discussions

  • Roger Xu at Aug 24, 2009 at 4:35 pm
    10.2.0.4.0

    1st Digit is a major database release number.

    2nd Digit is the database maintenance release number.

    3rd Digit is the application server release number.

    4th Digit identifies a release level specific to a component.

    5th Digit identifies a *platform specific release*.

    On Mon, Aug 24, 2009 at 11:23 AM, Taylor, Chris David <
    ChrisDavid.Taylor_at_ingrambarge.com> wrote:
    If you're running 10.2.0.4 cpu patch 24, is there a version number for
    this like 10.2.0.4.24?



    *Chris Taylor*
    *Sr. Oracle DBA*
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-354-4799
    Email: chris.taylor_at_ingrambarge.com


    *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
    confidential and may also be privileged. If you are not the named recipient,
    please notify the sender immediately and delete the contents of this message
    without disclosing the contents to anyone, using them for any purpose, or
    storing or copying the information on any medium.*
    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at Aug 24, 2009 at 4:39 pm
    Actually, Roger, that's not really true anymore.

    Oracle has recently announced the concept of a PSU, or patch set update.

    So, if you're on 10.2.0.4.0, and you apply the first PSU on 10.2.0.4.0, you'll be running 10.2.0.4.1. After the second PSU, it will be 10.2.0.4.2.

    This is very new. I've never seen a PSU, let alone applied one, but, they're starting w/ 10.2.0.4, and later plan to add one for 11.1.0.7.

    See MetaLink Doc ID 850471.1 for full details.

    -Mark

    From: oracle-l-bounce_at_freelists.org On Behalf Of Roger Xu
    Sent: Monday, August 24, 2009 12:35 PM
    To: ChrisDavid.Taylor_at_ingrambarge.com
    Cc: Oracle L
    Subject: Re: Question about patch levels

    10.2.0.4.0

    1st Digit is a major database release number.

    2nd Digit is the database maintenance release number.

    3rd Digit is the application server release number.

    4th Digit identifies a release level specific to a component.

    5th Digit identifies a platform specific release.

    On Mon, Aug 24, 2009 at 11:23 AM, Taylor, Chris David > wrote:
    If you're running 10.2.0.4 cpu patch 24, is there a version number for this like 10.2.0.4.24?

    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-354-4799
    Email: chris.taylor_at_ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
  • Roger Xu at Aug 24, 2009 at 6:14 pm
    Mark,

    So we need to pick either CPU or PSU from now on?
    Note 854428.1 says it's not easy to reverting from PSU back to CPU.

    Thanks,

    Roger
    On Mon, Aug 24, 2009 at 11:39 AM, Bobak, Mark wrote:

    Actually, Roger, that�s not really true anymore.



    Oracle has recently announced the concept of a PSU, or patch set update.



    So, if you�re on 10.2.0.4.0, and you apply the first PSU on 10.2.0.4.0,
    you�ll be running 10.2.0.4.1. After the second PSU, it will be 10.2.0.4.2.



    This is very new. I�ve never seen a PSU, let alone applied one, but,
    they�re starting w/ 10.2.0.4, and later plan to add one for 11.1.0.7.



    See MetaLink Doc ID 850471.1 for full details.



    -Mark



    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Roger Xu
    *Sent:* Monday, August 24, 2009 12:35 PM
    *To:* ChrisDavid.Taylor_at_ingrambarge.com
    *Cc:* Oracle L
    *Subject:* Re: Question about patch levels



    10.2.0.4.0

    1st Digit is a major database release number.

    2nd Digit is the database maintenance release number.

    3rd Digit is the application server release number.

    4th Digit identifies a release level specific to a component.

    5th Digit identifies a *platform specific release*.

    On Mon, Aug 24, 2009 at 11:23 AM, Taylor, Chris David <
    ChrisDavid.Taylor_at_ingrambarge.com> wrote:

    If you're running 10.2.0.4 cpu patch 24, is there a version number for this
    like 10.2.0.4.24?







    *Chris Taylor*

    *Sr. Oracle DBA*

    Ingram Barge Company

    Nashville, TN 37205

    Office: 615-517-3355

    Cell: 615-354-4799

    Email: chris.taylor_at_ingrambarge.com



    *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
    confidential and may also be privileged. If you are not the named recipient,
    please notify the sender immediately and delete the contents of this message
    without disclosing the contents to anyone, using them for any purpose, or
    storing or copying the information on any medium.*



    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at Aug 24, 2009 at 6:31 pm
    I have no idea. To date, I have never done a PSU or a CPU. From what I read, the PSU will encompass the latest CPU...I think.....but don't quote me on that.... :)

    From: Roger Xu
    Sent: Monday, August 24, 2009 2:14 PM
    To: Bobak, Mark
    Cc: ChrisDavid.Taylor_at_ingrambarge.com; Oracle L
    Subject: Re: Question about patch levels

    Mark,

    So we need to pick either CPU or PSU from now on?
    Note 854428.1 says it's not easy to reverting from PSU back to CPU.

    Thanks,

    Roger
    On Mon, Aug 24, 2009 at 11:39 AM, Bobak, Mark > wrote:

    Actually, Roger, that's not really true anymore.

    Oracle has recently announced the concept of a PSU, or patch set update.

    So, if you're on 10.2.0.4.0, and you apply the first PSU on 10.2.0.4.0, you'll be running 10.2.0.4.1. After the second PSU, it will be 10.2.0.4.2.

    This is very new. I've never seen a PSU, let alone applied one, but, they're starting w/ 10.2.0.4, and later plan to add one for 11.1.0.7.

    See MetaLink Doc ID 850471.1 for full details.

    -Mark

    From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
    Sent: Monday, August 24, 2009 12:35 PM
    To: ChrisDavid.Taylor_at_ingrambarge.com
    Cc: Oracle L
    Subject: Re: Question about patch levels

    10.2.0.4.0

    1st Digit is a major database release number.

    2nd Digit is the database maintenance release number.

    3rd Digit is the application server release number.

    4th Digit identifies a release level specific to a component.

    5th Digit identifies a platform specific release.

    On Mon, Aug 24, 2009 at 11:23 AM, Taylor, Chris David > wrote:

    If you're running 10.2.0.4 cpu patch 24, is there a version number for this like 10.2.0.4.24?

    Chris Taylor

    Sr. Oracle DBA

    Ingram Barge Company

    Nashville, TN 37205

    Office: 615-517-3355

    Cell: 615-354-4799

    Email: chris.taylor_at_ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
  • Lyall Barbour at Aug 24, 2009 at 7:27 pm
    Here's my opatch for my Grid Control server 10gR2 Release 5, with the
    July 09CPU patch loaded:

    oms1.tri-c.edu: ./opatch lsinventory
    Invoking OPatch 10.2.0.4.6

    Oracle Interim Patch Installer version 10.2.0.4.6
    Copyright (c) 2009, Oracle Corporation.  All rights reserved.

    Oracle Home       : /oracle/oms10g
    Central Inventory : /home/oracle/oraInventory
    from           : /etc/oraInst.loc
    OPatch version    : 10.2.0.4.6
    OUI version       : 10.2.0.5.0
    OUI location      : /oracle/oms10g/oui
    Log file location :
    /oracle/oms10g/cfgtoollogs/opatch/opatch2009-08-24_15-20-55PM.log

    Patch history file:
    /oracle/oms10g/cfgtoollogs/opatch/opatch_history.txt

    Lsinventory Output file location :
    /oracle/oms10g/cfgtoollogs/opatch/lsinv/lsinventory2009-08-24_15-20-55PM.txt

    Installed Top-level Products (2):

    Enterprise Manager Patchset

    10.2.0.5.0

    Oracle Enterprise Manager Grid Console

    10.2.0.1.1
    There are 2 products installed in this Oracle Home.

    under all that was the "Interim patches" that came with JULY09CPU.
    there was no number in the 5th position for my CPU patch, of
    anything... the number in the 5th position above for OPatch was
    because of the 6880880 patch that was installed before i installed
    the CPU.

    HTH,

    Lyall

    On Mon, Aug 24, 2009 at 11:23 AM, Taylor, Chris David
    wrote:

    If you're running 10.2.0.4 cpu patch 24, is there a version number
    for this like 10.2.0.4.24?







    Chris Taylor

    Sr. Oracle DBA

    Ingram Barge Company

    Nashville, TN 37205

    Office: 615-517-3355

    Cell: 615-354-4799



    --
    Be Yourself _at_ mail.com!
    Choose From 200+ Email Addresses
    Get a Free Account at www.mail.com!

    --
    http://www.freelists.org/webpage/oracle-l
  • Stefan Knecht at Aug 25, 2009 at 6:37 am
    It's all on metalink..

    The PSUs are recommended patch bundles. Search metalink for "11.1.0.7
    recommended patch" - it'll be like the first hit.

    PSUs are listed as *.1 or *.2 so i.e. 10.2.0.4.1 - but they don't actually
    change the server version. And yes, they do include the latest CPU at the
    time of their release.

    We're installing them on all new 10.2.0.4 and 11.1.0.7 release
    installations. Quite a few BUGs are fixed with them.

    Cheers

    Stefan P Knecht
    CEO & Founder
    s_at_10046.ch

    10046 Consulting GmbH
    Schwarzackerstrasse 29
    CH-8304 Wallisellen
    Switzerland

    Phone +41-(0)8400-10046
    Cell +41 (0) 79 571 36 27
    info_at_10046.ch
    http://www.10046.ch
    On Mon, Aug 24, 2009 at 9:27 PM, Lyall Barbour wrote:

    Here's my opatch for my Grid Control server 10gR2 Release 5, with the
    July 09CPU patch loaded:

    oms1.tri-c.edu: ./opatch lsinventory
    Invoking OPatch 10.2.0.4.6

    Oracle Interim Patch Installer version 10.2.0.4.6
    Copyright (c) 2009, Oracle Corporation. All rights reserved.


    Oracle Home : /oracle/oms10g
    Central Inventory : /home/oracle/oraInventory
    from : /etc/oraInst.loc
    OPatch version : 10.2.0.4.6
    OUI version : 10.2.0.5.0
    OUI location : /oracle/oms10g/oui
    Log file location :
    /oracle/oms10g/cfgtoollogs/opatch/opatch2009-08-24_15-20-55PM.log

    Patch history file: /oracle/oms10g/cfgtoollogs/opatch/opatch_history.txt

    Lsinventory Output file location :
    /oracle/oms10g/cfgtoollogs/opatch/lsinv/lsinventory2009-08-24_15-20-55PM.txt


    --------------------------------------------------------------------------------
    Installed Top-level Products (2):

    Enterprise Manager Patchset
    10.2.0.5.0
    Oracle Enterprise Manager Grid Console
    10.2.0.1.1
    There are 2 products installed in this Oracle Home.

    under all that was the "Interim patches" that came with JULY09CPU. there
    was no number in the 5th position for my CPU patch, of anything... the
    number in the 5th position above for OPatch was because of the 6880880 patch
    that was installed before i installed the CPU.

    HTH,
    Lyall

    On Mon, Aug 24, 2009 at 11:23 AM, Taylor, Chris David <
    ChrisDavid.Taylor_at_ingrambarge.com> wrote:

    If you're running 10.2.0.4 cpu patch 24, is there a version number for this
    like 10.2.0.4.24?







    *Chris Taylor*

    *Sr. Oracle DBA*

    Ingram Barge Company

    Nashville, TN 37205

    Office: 615-517-3355

    Cell: 615-354-4799




    -- Be Yourself _at_ mail.com
    Choose From 200+ Email Addresses
    Get a *Free* Account at www.mail.com!
    --
    http://www.freelists.org/webpage/oracle-l
  • Taylor, Chris David at Aug 25, 2009 at 12:45 pm
    Ultimately I knew it wasn't like this but I was hoping it was.

    How do you guys setup your Oracle homes for different versions? I had originally wanted to do something like \oracle\product\10.2.0.4.24\db_1 for upgraded homes, but decided against it.

    So now I have
    \oracle\product\10.2.0\db_1 (10.2.0.2)
    \oracle\product\10.2.0\db_2 (10.2.0.4 Patch 7)
    \oracle\product\10.2.0\db_3 (10.2.0.4 Patch 24)

    Ultimately the db_1 & db_2 databases will all be moved to the db_3 home, but it's not as intuitive as I would like to have the directories so "vanilla".

    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-354-4799
    Email: chris.taylor_at_ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

    From: oracle-l-bounce_at_freelists.org On Behalf Of Taylor, Chris David
    Sent: Monday, August 24, 2009 11:24 AM
    To: 'Oracle L'
    Subject: Question about patch levels

    If you're running 10.2.0.4 cpu patch 24, is there a version number for this like 10.2.0.4.24?

    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-354-4799
    Email: chris.taylor_at_ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
  • Yechiel Adar at Aug 26, 2009 at 4:40 am
    We do not have separate homes.
    I install 10.2.0.3 in oracle/product/10.2.0 and I upgrade this home and
    the database when I move to 10.2.0.4.
    Patch level also goes into this home.

    Why do you use 3 homes?

    Adar Yechiel
    Rechovot, Israel

    Taylor, Chris David wrote:
    Ultimately I knew it wasn't like this but I was hoping it was.

    How do you guys setup your Oracle homes for different versions? I had
    originally wanted to do something like
    \oracle\product\10.2.0.4.24\db_1 for upgraded homes, but decided
    against it.

    So now I have
    \oracle\product\10.2.0\db_1 (10.2.0.2)
    \oracle\product\10.2.0\db_2 (10.2.0.4 Patch 7)
    \oracle\product\10.2.0\db_3 (10.2.0.4 Patch 24)
    --
    http://www.freelists.org/webpage/oracle-l
  • Yechiel Adar at Aug 26, 2009 at 7:28 am
    You are right in principle.
    However, he used windows '\' rather then Linux '/' in the directory list
    so I assumed Windows.
    We generally use only one database per windows server.
    Add to that the fact that he uses separate home for each CPU, so my
    question is relevant.

    Maybe it needed to be: Why use a separate home for each patch level?

    Adar Yechiel
    Rechovot, Israel

    Niall Litchfield wrote:
    I can't speak for Charles, but sometimes this is a sensible idea in
    the event of wishing to roll back an upgrade, or more generally when
    you have multiple database applications on the same server, then the
    slowest/most difficult to update doesn't hold everyone back. .
    --
    http://www.freelists.org/webpage/oracle-l
  • Taylor, Chris David at Aug 26, 2009 at 12:26 pm
    Yes its Windows.

    When you say "We generally use only one database per windows server.", you mean one database software installation AND 1 instance? Or multiple instances?

    We've got several db instances on most of our windows servers and they run smoothly (minus the occassional Oracle bug!)

    Regarding why we would have multiple 10.2.0.4 homes is that it is easier to rollback a patch if necessary. Basically I repoint the Oracle services back to the old Oracle home, and clean up the database components and we're back to the previous version.

    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-354-4799
    Email: chris.taylor_at_ingrambarge.com


    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org On Behalf Of Yechiel Adar
    Sent: Wednesday, August 26, 2009 2:29 AM
    Cc: Oracle L
    Subject: Re: Question about patch levels

    You are right in principle.
    However, he used windows '\' rather then Linux '/' in the directory list so I assumed Windows.
    We generally use only one database per windows server.
    Add to that the fact that he uses separate home for each CPU, so my question is relevant.

    Maybe it needed to be: Why use a separate home for each patch level?

    Adar Yechiel
    Rechovot, Israel

    Niall Litchfield wrote:
    I can't speak for Charles, but sometimes this is a sensible idea in
    the event of wishing to roll back an upgrade, or more generally when
    you have multiple database applications on the same server, then the
    slowest/most difficult to update doesn't hold everyone back. .
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • Ganesh Raja at Aug 26, 2009 at 7:34 am
    Multiple database applications which don't want to upgrade. A seperate home will help.

    Cheers.
    ------Original Message------
    From: Yechiel Adar
    Sender: oracle-l-bounce_at_freelists.org
    Cc: Oracle L
    ReplyTo: adar666_at_inter.net.il
    Subject: Re: Question about patch levels
    Sent: Aug 26, 2009 12:58

    You are right in principle.
    However, he used windows '\' rather then Linux '/' in the directory list
    so I assumed Windows.
    We generally use only one database per windows server.
    Add to that the fact that he uses separate home for each CPU, so my
    question is relevant.

    Maybe it needed to be: Why use a separate home for each patch level?

    Adar Yechiel
    Rechovot, Israel

    Niall Litchfield wrote:
    I can't speak for Charles, but sometimes this is a sensible idea in
    the event of wishing to roll back an upgrade, or more generally when
    you have multiple database applications on the same server, then the
    slowest/most difficult to update doesn't hold everyone back. .
    --
    http://www.freelists.org/webpage/oracle-l

    Sent from BlackBerry® on Airtel†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 24, '09 at 4:23p
activeAug 26, '09 at 12:26p
posts12
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase