[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2007-10-21
Medium Priority
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

Accepted Solution

konektor earned 210 total points
ID: 20121047
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

Assisted Solution

vishal68 earned 165 total points
ID: 20121158
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

872 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