Migrate from oracle 10g 32-bit to 64-bit

Posted on 2007-10-21
Last Modified: 2013-12-19
Hi ,
I'm using oracle database 10g 32-bit windows edition in my environment and I want to migrate to 64-bit windows edition , is there any step by step walkthru which I can use for this upgrade ?
Question by:Farrahi
    LVL 9

    Accepted Solution

    if the change is on the same server, it's only about changing the software:
    1. install new version of oracle software to new oracle home
    2. use any supported way how to migrate database.
    you can use full export-import as "standard" to migrate database, but when you don't change operating system, relase of database, but only changing from 32 to 64 bit, you can use so called "cold backup":
    a) stop the database
    b) move datafiles, redo logs to new directory (if you need to do it)
    c) create empty database in new oracle software
    d) use alter database to add references to datafiles, redologs
    e) startup resetlogs
    LVL 7

    Assisted Solution

    When you are moving from 32bit to 64bit, only thing that is changing apart from the binaries is the pl/sql. Therefore, the method would be as follows.

    1. Take a cold backup of the database.
    2. Remove the Oracle database service
    3. Install Oracle 10g 64 bit.
    4. Copy the spfile from old oracle home to new home.
    5. Create new Oracle service using oradim
    6. Start the database in new Oracle home.
    7. Run Catalog.sql and Catproc.sql
    8. Run utlrp.sql to recompile all your plsql objects (as they will become invalid).

    This completes the upgrade. Now take a complete backup (cold or hot depending upon your backup strategy).


    Featured Post

    Looking for New Ways to Advertise?

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

    Join & Write a Comment

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    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…

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now