How to upgrade from an Oracle 10g to Database on MS Vista

Posted on 2008-11-04
Last Modified: 2013-12-19
Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database ( to on Microsoft Windows Vista?  If you have the patch numbers that one needs to download from Oracle's Metalink and the order that they need to be applied.  Several users have pointed out that you cannot apply patches to a database until it is upgraded to and that interim patches require the Opatch utility.  Any details would be appreciated!


Question by:rockwise
    LVL 27

    Expert Comment

    Cannot access metalink right now:

    404 Not Found
    Resource /CSP/ui/signin_de.html not found on this server


    Might be a locale problem.

    Will see.

    LVL 7

    Accepted Solution

    Here you go
    The patch No. is 6810189
    Step 1). download the pacth from metalink. the file name for solaris is
    Step 2). Extract the file using unzip utilities
    Step 3). Stop all services
             i) shutdown database (using: connect / as sysdba and shutdown immediate )
             ii) Shutdown listener (using lsnrctl stop)
            iii) emctl stop dbconsole  (if dbconsole is configured and running).
           iv). isqlplusctl stop (if isqlplus is configured and running)
    Step 4). Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe
    select the proper Oracle home and click next ..... next ... next
    On the Summary screen, click Install. When the installation is complete, the End of Installation screen appears. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

    Step 5). startup the listener.  (lsnrctl start )
    Step 6). Start the Oracle Database Upgrade Assistant:
    From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools and then Database Upgrade Assistant to start the Oracle Database Upgrade Assistant.
    On the Welcome screen, click Next.
    On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
    On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
    If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.

    On the Summary screen, check the summary, then click Finish.

    On the End of Upgrade screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.

    Step 7). Restart the database:


    Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

    SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql


    When the patch set is applied to an Oracle Database 10g Standard Edition database, there may be 54 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation.
    Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:



    Run the following command to check the status of all the components after the upgrade:


    In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.


    Author Closing Comment

    Thanks for the suggestion.  This patch should do it.  It comes with its own Universal Installer making it easier to deploy than the earlier interim patches.  Also it can be applied to all 10g Release 2 Databases (10.2.0.x) as well as most 32-bit operating systems - MS Windows Server 2003, Server 2003 R2, Windows XP Professional, Windows Vista SP1, and even Windows 2000 SP2 or later.

    Thanks again,


    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.

    Suggested Solutions

    Title # Comments Views Activity
    Copy table from Oracle to MySQL using PHP 12 93
    Oracle SQL Nested Select 3 50
    NMAP shows service 1521 is closed 13 68
    Oracle View 13 34
    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.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now