Home » RDBMS Server » Server Administration » Oracle Database Cross Platform Migration from 9i to 11g (OS:Sunsolaris to Linux,Database:9i to 11g)
Oracle Database Cross Platform Migration from 9i to 11g [message #613816] Mon, 12 May 2014 12:03 Go to next message
sprakashyz
Messages: 2
Registered: May 2006
Junior Member
Hi All,

I am into oracle database migration project.I need your help for this migration.
Please find the below details and suggest me the best method to implement this migration.

Oracle Database migration from 9i to 11g.

Source Details:

Database Version: 9i
OS: Sunsolaris (Big Endian)
Database size: 3.7 TB
Environment: Production(Standalone)

Target Details:

Database Version: 11g
OS: Linux (Little Endian)
Environment: Production (Standalone)

Since the source and target OS are in different Endian format,seems it should be the cross platform migration.

Since it is a production environment the downtime should be less.

Please suggest me the best method for this migration.


Thanks in Advance...
Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613817 is a reply to message #613816] Mon, 12 May 2014 12:36 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Some questions, in no particular order:
1. You need to more precise about your releases. 9i and 11g are not good enough. For example, is it 9.2.0.8 to 11.2.0.4?
2. Is it 64bit in both environments?
3. What 11.x features do you want to enable? In particular, will you be using GI and ASM? (The correct answer is "yes").
4. Is the storage going to be the same?
5. Is it Standard or Enterprise Edition licences?

Overall, you might want to think about bringing in some external assistance so that you can lay off the responsibility (my boss will be happy to quote Smile ) for a job this size.
Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613818 is a reply to message #613817] Mon, 12 May 2014 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... one method that always work... export/import.

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613820 is a reply to message #613816] Mon, 12 May 2014 14:22 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
https://community.oracle.com/thread/3558769
Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613825 is a reply to message #613820] Mon, 12 May 2014 14:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=71661&SkipA=0

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613837 is a reply to message #613818] Mon, 12 May 2014 16:15 Go to previous messageGo to next message
jgarry
Messages: 3
Registered: July 2006
Location: Vista, CA
Junior Member
Quote:
... one method that always work... export/import.


But like anything else, it may be very, very slow.

As far as crossposting this OP over every site, doesn't that make sense for cross platform? Laughing
Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613848 is a reply to message #613837] Tue, 13 May 2014 00:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Laughing

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #682432 is a reply to message #613818] Fri, 23 October 2020 08:30 Go to previous messageGo to next message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Michel,

Quote:
... one method that always work... export/import.
Can we use export and import method for small and big databases.

Regards,
Balaji
Re: Oracle Database Cross Platform Migration from 9i to 11g [message #682433 is a reply to message #682432] Fri, 23 October 2020 10:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 12 May 2014 19:56

... one method that always work... export/import.

[Updated on: Fri, 23 October 2020 10:51]

Report message to a moderator

Previous Topic: How to get size in MB of all objects in a Schema in Oracle?
Next Topic: How can I safely limit the amount of memory used by Oracle 12c?
Goto Forum:
  


Current Time: Thu Mar 28 17:52:50 CDT 2024