Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

database migration

780276Nov 8 2010 — edited Nov 9 2010
Hi,
I am migrating 32-Bit 10g database to 64-Bit 10g database on 64-Bit server, as of now i done the following steps

1.Installed Oracle 10gR2 on 64-Bit machine
2. Take the full export backup of source databse (32-Bit database)
3. copy the init.ora from 32-Bit to 64-Bit home and start the database with this parameter file(after editing)
4. Do the full import
5. Run utlirp.sql and utlrp.sql
6. start the database

Please suggest if the above steps is ok or i need anything extra to do

Regards

Comments

CKPT
hi,

no need to do export & import, what is the OS ?

1)take backup
2) install 64 bit
3) startup upgrade
4) run catupgrd.sql
5)shut immediate
6)startup
7)run utlrp.sql.

Thanks
780276
OS is windows 2003 (32-Bit)
The existing 32-Bit database is on 32-Bit server, so I have to migrate it to 64-Bit Hardware and the client could not afford the downtime
so I planned to use import/export to migrate, please suggest

Regards
Bilal
CKPT
Hi,

*How to Migrate Oracle 10.2 32bit to 10.2 64bit on Microsoft Windows [ID 403522.1]* :) :)
744052
Hi,

There is a useful My Support Oracle Document *How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers [ID 277650.1]*

Certain things you need to be carful of while using the export and import.

Thanks.
780276
I want to know can we do this migration proccess through imp/exp?

Regards
744052
Yes you can.
CKPT
Hi,

You can do it, but it is complex if you compare with upgrade mode..

Thanks
ora_tech
Hi,
I want to know can we do this migration proccess through imp/exp?
The best way to do is to follow MOS tech note *403522.1* mentioned by CKPT.

Regards,
X A H E E R
780276
thanks a lot folks
CKPT
So using exp/imp or upgrade? :)
roy.swonger-Oracle
If you are migrating without upgrading (10g 32-bit to 10g 64-bit) then you don't need to upgrade or export/import. Simply doing the utlirp/utlrp is enough to change the word size of the database:

startup upgrade
@$ORACLE_HOME/rdbms/admin/utlirp.sql
shutdown immediate
STARTUP pfile=init.ora;
@$ORACLE_HOME/rdbms/admin/utlrp.sql;

Note that you will want to adjust your init.ora settings for larger memory values, because 64-bit requires significantly larger pool sizes than does 32-bit.
sb92075
because 64-bit requires significantly larger pool sizes than does 32-bit.
Really?
Please post proof?
Since when does Oracle RDBMS know or care about whether it is on 32-bit or 64-bit hardware?
1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 7 2010
Added on Nov 8 2010
#general-database-discussions
12 comments
133 views