FAQ
Greetings,


Is there a routine you follow for testing patch sets, such as an upgrade
from 9.2.0.3 to 9.2.0.5?


thanks,


Josh C.

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/

Search Discussions

  • Nelson, Allan at Sep 3, 2004 at 1:14 pm
    Yes,

    Do a clean install of a new oracle home to be the site for testing
    your upgrade. Upgrade it to whatever patch level you currently run.
    Have it owner by another OS account
    Make a copy of your database. It is easiest to do this as a cold
    copy or use rman to do it hot.
    Start it in the new Oracle home using a copied initora.
    Do your patch
    test test test

    Allan

    -----Original Message-----
    =46rom: oracle-l-bounce_at_freelists.org
    On Behalf Of Josh Collier
    Sent: Friday, September 03, 2004 1:14 PM
    To: oracle-l_at_freelists.org
    Subject: patch set testing

    Greetings,
    =20
    Is there a routine you follow for testing patch sets, such as an upgrade
    =66rom 9.2.0.3 to 9.2.0.5=3F
    =20
    thanks,
    =20
    Josh C.=20

    --
    To unsubscribe -
    mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe=20
    To search the archives - http://www.freelists.org/archives/oracle-l/

    ___________________________________________________________________________=
    ___
    This email is intended solely for the person or entity to which it is =
    addressed and may contain confidential and/or privileged information. =
    Copying, forwarding or distributing this message by persons or entities =
    other than the addressee is prohibited. If you have received this email in =
    error, please contact the sender immediately and delete the material from =
    any computer. This email may have been monitored for policy compliance. =
    [021216]

    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • David at Sep 3, 2004 at 1:22 pm
    I accidentally dropped a package body frok production.
    Outside of RMAN backups, there is no copy of this body.
    I tried use flashabck query at the session level and export level, but for
    somereason even though the command/exp succeeds, I still get the wrong or
    new body.
    Any ideas?
    Can I use logminer to retrieve a dropped package body?
    --
    ..
    David

    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • Jeremiah Wilton at Sep 3, 2004 at 1:49 pm
    You might try using strings on the system datafile that holds source$.
    Depending on how big the package was, you may be able to see it.
    Oracle doesn't remove the data, it just marks the space free.

    something like:

    $ strings system01.dbf | more

    then search for a word unique to the dropped package.

    If that doesn't work, restore only the system and rollbacks
    tablespaces to another location, offline drop all other files, and
    open the (mini-clone) database.

    --
    Jeremiah Wilton
    http://www.speakeasy.net/~jwilton
    On Fri, 3 Sep 2004, David wrote:

    I accidentally dropped a package body frok production.
    Outside of RMAN backups, there is no copy of this body.
    I tried use flashabck query at the session level and export level, but for
    somereason even though the command/exp succeeds, I still get the wrong or
    new body.
    Any ideas?
    Can I use logminer to retrieve a dropped package body?
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • Bobak, Mark at Sep 3, 2004 at 1:24 pm
    Josh,

    Guidelines we follow are:
    1) When moving a major release, like 8.1.7 to 9.2.0, always go
    with the newest patchset that's out, in this case, 9.2.0.5.

    2.) If just bumping up a patchset, don't go there, unless you
    need to fix a problem that you actually have. If you're going
    from 9.2.0.2 to 9.2.0.5 just cause 9.2.0.5 is there, that's not
    a reason to go.

    3.) Regardless of if we are going from one major release to
    another, we always try to roll it out with the release of our
    product, so that it gets a full complement of QA testing,=20
    capacity testing and soak testing.

    4.) We try to stay away from one-off patches all together,
    but, sometimes you can't. In that case, we'll roll it into
    our pre-prod environment, run a 3-4 hour cap test, and if that
    succeeds, we'll run a weekend long soak test, to hopefully=20
    catch memory leaks, and those types of problems.

    Patching is always an art and never a science. You just mitigate
    what you can and hope for the best. (And be prepared for the worst!)

    Hope that helps,

    -Mark

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Josh Collier
    Sent: Friday, September 03, 2004 2:14 PM
    To: oracle-l_at_freelists.org
    Subject: patch set testing

    Greetings,
    =20
    Is there a routine you follow for testing patch sets, such as an upgrade
    from 9.2.0.3 to 9.2.0.5?
    =20
    thanks,
    =20
    Josh C.=20

    --
    To unsubscribe - =
    mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe=20
    To search the archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • Mercadante, Thomas F at Sep 3, 2004 at 1:31 pm
    David,

    Is it an Oracle package body from the SYS schema? If so, you can search for
    it in the $ORACLE_HOME/rdbms/admin directory and reload it (or just re-run
    catproc.sql).

    If it is one of your package bodies from your schema, then it's gone. Hope
    you have a PL/SQL library someplace.

    If you don't have it anyplace, then your only option is to perform a
    database recovery up to the point-in-time just before you dropped it.

    The get all of your PL/SQL source code out of the database and into a
    source-management facility.

    Good Luck!

    Tom Mercadante
    Oracle Certified Professional

    -----Original Message-----
    From: David
    Sent: Friday, September 03, 2004 2:25 PM
    To: oracle-l_at_freelists.org
    Subject: screw up

    I accidentally dropped a package body frok production.
    Outside of RMAN backups, there is no copy of this body.
    I tried use flashabck query at the session level and export level, but for
    somereason even though the command/exp succeeds, I still get the wrong or
    new body. Any ideas? Can I use logminer to retrieve a dropped package body?
    --
    ..
    David

    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • Gogala, Mladen at Sep 3, 2004 at 1:33 pm
    You can't use LogMiner. Logminer can't reconstruct DDL. You can use
    CVS (or equivalent) or your documentation. What you may try is
    to look into the recycle bin, if you have it (oracle version 10g).
    If you have none of the above, then don't be a girlie man, sit
    down and white (spelling the Austrian accent) it from scratch.

    --
    Mladen Gogala
    A & E TV Network
    Ext. 1216
    -----Original Message-----
    From: David
    Sent: Friday, September 03, 2004 2:25 PM
    To: oracle-l_at_freelists.org
    Subject: screw up




    I accidentally dropped a package body frok production.
    Outside of RMAN backups, there is no copy of this body.
    I tried use flashabck query at the session level and export
    level, but for somereason even though the command/exp
    succeeds, I still get the wrong or new body. Any ideas? Can I
    use logminer to retrieve a dropped package body?
    --
    ..
    David










    --
    To unsubscribe -
    mailto:oracle-l-> request_at_freelists.org&subject=unsubscribe
    To
    search the
    archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • David at Sep 3, 2004 at 1:53 pm
    Damn, I was afraid of that and really knew that!
    I was just hoping I was wrong.
    DB is 9i.
    If I have to restore a package body and have to go to the point of doing a
    tablespace point in time recovery to an alternate node, do I only need the
    system tablespace or do I also need the tablespace that is the default
    tablespace for the schema that owned the package and body?

    --
    ..
    David
    You can't use LogMiner. Logminer can't reconstruct DDL. You can use
    CVS (or equivalent) or your documentation. What you may try is
    to look into the recycle bin, if you have it (oracle version 10g).
    If you have none of the above, then don't be a girlie man, sit
    down and white (spelling the Austrian accent) it from scratch.

    --
    Mladen Gogala
    A & E TV Network
    Ext. 1216

    -----Original Message-----
    From: David
    Sent: Friday, September 03, 2004 2:25 PM
    To: oracle-l_at_freelists.org
    Subject: screw up




    I accidentally dropped a package body frok production.
    Outside of RMAN backups, there is no copy of this body.
    I tried use flashabck query at the session level and export
    level, but for somereason even though the command/exp
    succeeds, I still get the wrong or new body. Any ideas? Can I
    use logminer to retrieve a dropped package body?
    --
    ..
    David










    --
    To unsubscribe -
    mailto:oracle-l-> request_at_freelists.org&subject=unsubscribe
    To
    search the
    archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • David at Sep 3, 2004 at 1:56 pm
    Damn, I was afraid of that and really knew that!
    I was just hoping I was wrong.
    DB is 9i.
    If I have to restore a package body and have to go to the point of doing a
    tablespace point in time recovery to an alternate node, do I only need the
    system tablespace or do I also need the tablespace that is the default
    tablespace for the schema that owned the package and body?

    --
    ..
    David
    You can't use LogMiner. Logminer can't reconstruct DDL. You can use
    CVS (or equivalent) or your documentation. What you may try is
    to look into the recycle bin, if you have it (oracle version 10g).
    If you have none of the above, then don't be a girlie man, sit
    down and white (spelling the Austrian accent) it from scratch.
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • Ken Naim at Sep 3, 2004 at 1:49 pm
    Do you have a recent export of your database or that schema?. If so you can
    retrieve your lost source code directly and relatively easily. Also
    restoring your backup shouldn't be too bad since you do not need to restore
    your data and index tablespaces, just your system, rbs/undo, sort/temp etc.

    A poor and lazy man's source control can be running a nightly export with
    rows=N, it will export the structure and more importantly the code from your
    database. It can come in handy for situations such as yours.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Gogala, Mladen
    Sent: Friday, September 03, 2004 2:37 PM
    To: 'thump_at_cosmiccooler.org'; oracle-l_at_freelists.org
    Subject: RE: screw up

    You can't use LogMiner. Logminer can't reconstruct DDL. You can use
    CVS (or equivalent) or your documentation. What you may try is
    to look into the recycle bin, if you have it (oracle version 10g).
    If you have none of the above, then don't be a girlie man, sit
    down and white (spelling the Austrian accent) it from scratch.

    --
    Mladen Gogala
    A & E TV Network
    Ext. 1216
    -----Original Message-----
    From: David
    Sent: Friday, September 03, 2004 2:25 PM
    To: oracle-l_at_freelists.org
    Subject: screw up




    I accidentally dropped a package body frok production.
    Outside of RMAN backups, there is no copy of this body.
    I tried use flashabck query at the session level and export
    level, but for somereason even though the command/exp
    succeeds, I still get the wrong or new body. Any ideas? Can I
    use logminer to retrieve a dropped package body?
    --
    ..
    David










    --
    To unsubscribe -
    mailto:oracle-l-> request_at_freelists.org&subject=unsubscribe
    To
    search the
    archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 3, '04 at 1:09p
activeSep 3, '04 at 1:56p
posts10
users8
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase