How can I upgrade 10G R1 to  R2 ?

Posted on 2006-04-25
Last Modified: 2008-01-09
We have Oracle 10G installed since last year. So far so good. But since Oracle had release latest one R2, can anyone tell me how to upgrade the existing 10G R1 ? There are a lot of data inside the server and many system had been deployed. So how can I ensure the upgrade will work 100% or another word, I am afraid if the upgrade failed, the system also failed. If the upgrade is straight foward without reconfigure or minimum changes, then I will try if the procedure is simple and easy.

Another thing is, we also have 2nd 10G installed to another machine. We plan to use this as a backup, just incase 1st server down, 2nd one will take over. But I believe it is not as siimple as it is. How can I do that ?

Question by:KG1973
    LVL 19

    Accepted Solution


    notice if you have RAC set up, 10g introduces a "rolling upgrade" which doesn't incur any downtime while upgrading.
    LVL 3

    Expert Comment

    If you can't do RAC you can use Dataguard to ship the arch logs to the second server.
    LVL 47

    Assisted Solution

    The best way is to use new installation or 10g R2 and to Export/Import the data.
    This way is not simple because it needs investigations - non system users, tablespaces, etc.
    but the DBA has full control over the process and also the original DB is not damaged (you can turn it off).
    LVL 4

    Expert Comment

    The following is a chain of events that I first thought might solve the upgrade with no downtime:

    (These first steps *would* requires downtime for certain:)

    1. shutdown Oracle 10g R1 on both nodes.
    2. shutdown crs process.
    3. upgrade CRS.
    4. open the R1 databases using the R2 of crs.


    the next steps I was unsure about, until I realized that what would happen in step 7:

    5. shutdown Oracle 10g R1 on node A.
    6. upgrade Oracle 10g to R2 on node A
    7. open Oracle 10g R2 on node A <-- This step should not work because we are trying to join an Oracle 10g R2
    database to a cluster with an already running an Oracle 10g R1 instance.
    8. shutdown Oracle 10g R1 on node B
    9. upgrade Oracle 10g to R2 on node B
    10 open Oracle 10g R2 on node B


    For more details, visit

    Chetan Sachdeva

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    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 video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now