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: 7212
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: 65317
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: 887
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: 65317
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 message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Laughing

Previous Topic: How to Upgrade 11g 11.2.0.1 to 11.2.0.3
Next Topic: Excessive DB connections.
Goto Forum:
  


Current Time: Tue Jan 16 16:20:04 CST 2018

Total time taken to generate the page: 0.01139 seconds