Database Upgrade

Posted on 2011-04-23
Last Modified: 2013-12-18

How can I upgrade Oracle to in Solaris environment? This databse use Streams to replicate a schema DML operation to another database. (Bi-directional). What pre-cautions we need to take? Can anyone throw some idea and the steps?

Thanks in advance.
Question by:sree_vasan
    LVL 76

    Accepted Solution

    The readme for the patchset should have any special steps for streams if there are any.

    I've never done that specific patchset on streams but is the readme doesn't specifically mention streams, it should be just like any other patch.

    If you are nervous about it just stop propagation while you upgrade them.  Once everything is patched, restart propagation.
    LVL 23

    Expert Comment

    hi sree_vasan,
    - i believe you have an Oracle Support contract? there are published cases on applying patches on Solaris. these problem/cases might/might not hit your environment, depending on how your is setup.

    - if you have the access to Metalink, read up these Doc ID:
    : Patch Set - Availability and Known Issues [ID 555579.1] >> this includes comments that is not included in the Patch Set README
    : ocrcheck failed When Applying Patchset or on Solaris [ID 734129.1]
    : OUI-15038 While Installing The Patchset On Solaris 10 [ID 749197.1]
    : CRS Does Not Start On The Second Node After Applying On Solaris [ID 785305.1]
    : Streams Specific Patches [ID 437838.1] on top of

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now