OraFAQ Forum: Server Administration » Oracle Database Cross Platform Migration from 9i to 11g

Home » RDBMS Server » Server Administration » Oracle Database Cross Platform Migration from 9i to 11g (OS:Sunsolaris to Linux,Database:9i to 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Database Cross Platform Migration from 9i to 11g [message #613816]

Mon, 12 May 2014 12:03

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...

Report message to a moderator

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613817 is a reply to message #613816]

Mon, 12 May 2014 12:36

John Watson
Messages: 8949
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.

Report message to a moderator

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613818 is a reply to message #613817]

Mon, 12 May 2014 12:56

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613820 is a reply to message #613816]

Mon, 12 May 2014 14:22

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

https://community.oracle.com/thread/3558769

Report message to a moderator

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613825 is a reply to message #613820]

Mon, 12 May 2014 14:51

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Oracle Database Cross Platform Migration from 9i to 11g [message #613837 is a reply to message #613818]

Mon, 12 May 2014 16:15

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