Home » RDBMS Server » Server Administration » Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2 (windows)
Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2 [message #555738] Mon, 28 May 2012 01:52 Go to next message
sandeip
Messages: 23
Registered: May 2011
Location: pune
Junior Member
Hi,

Can you please tell me the action plan about

"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"

Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition
Re: Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2 [message #555747 is a reply to message #555738] Mon, 28 May 2012 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export/create new database/import.

Regards
Michel
Re: Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2 [message #555753 is a reply to message #555747] Mon, 28 May 2012 05:52 Go to previous messageGo to next message
sandeip
Messages: 23
Registered: May 2011
Location: pune
Junior Member
Hi Michel,
Thanks for your reply,
Could you please provide me the appropriate parameters
Re: Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2 [message #555757 is a reply to message #555753] Mon, 28 May 2012 06:28 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
For which part of it? Export full database, import full database. Oracle data pump documentation contains all parameters - have a look.
Re: Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2 [message #555758 is a reply to message #555753] Mon, 28 May 2012 06:32 Go to previous message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Quote:
Could you please provide me the appropriate parameters


What parameters are you talking about?

DO a full database export.
Create a new database in the new 64 bit server
Import your exported database to the new database.

Else you can try another option. DO a cold copy of your data files and restore to your new database as you do in a clone. I am not sure if it will work but I think it may work.

Cheers
Ridhi
Previous Topic: ORA-00600: internal error code
Next Topic: Privilege require to gather stats
Goto Forum:
  


Current Time: Fri Apr 19 06:39:18 CDT 2024