How to upgrade oracle from 10.2.01 to step by step

Posted on 2009-02-10
Last Modified: 2013-12-18
Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database standard  ( to on Microsoft Windows Server 2003 R2?  Any details would be much appreciated. Thanks
Question by:a4sha24
    LVL 73

    Expert Comment

    download the patch from metalink, search for patch 6810189

    open the readme
    search for section 7, confirm you have completed all Preinstallation tasks that apply to your setup
    go to section 8, complete the steps in section 8.1
    based on your 7.5 results you may have to complete section 9.1
    next go to section 9.3.1 complete those steps for each database

    LVL 47

    Accepted Solution

    1. Shutdown gracefully the DB.
    2. Stop all Oracle services
    3. Download the Upgrade kit and unzip it
    4. Invoke Oracle Universal installer and point to the correct Oracle Home
    5. Do upgrade of the server
    6. Startup the DB
    7. ensure that the SYSTEM tablespace has at least 50 MB free space and
    shared_pool_size and java_pool_size are at least 150 MB
    8.shutdown immediate
    9. startup upgrade pfile=c:\init.ora
      here init.ora is a parameter file created to fulfill point 7.
    10. Run the script ORACLE_HOME\rdbms\admin\catupgrd.sql
    11. Shutdown
    12. Startup
    13. Run ORACLE_HOME\rdbms\admin\utlrp.sql
    14. enjoy

    Author Closing Comment

    Thanks for the detailed steps.
    LVL 47

    Expert Comment

    Good luck!

    Expert Comment

    Greetings a4sha24 i have upgraded from to i can give you the steps and steps procedure by screenshots if you like.

    Feel free to answer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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.

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows how to recover a database from a user managed backup
    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.

    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