Re: Oracle E-Business Migration from Windows to Linux

Additionally, (and this is probably what Mr. Tipton was pointing out),
there are documents particular to export/import with E-Business Suite.

230627.1 -- 9i Export/Import Process for Oracle Applications Release 11i
362205.1 -- 10g Release 2 Export/Import Process for Oracle
Applications Release 11i

-- James
----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA | TriOra Group, LLC
morrow.james <at> gmail <dot> com
james.morrow <at> trioragroup <dot> com




On Thu, Mar 19, 2009 at 6:38 PM, James Morrow <morrow.james@xxxxxxxxx> wrote:
> What I outlined was a "rough" outline of the underlying mechanics of
> the migration.
>
> The official document on how to perform this migration is 238276.1, as
> I detailed
> (and recommended) in my original message.
>
> -- James
> ----------------------------------------------------------------------
> James J. Morrow | Senior Oracle Applications DBA | TriOra Group, LLC
> morrow.james <at> gmail <dot> com
> james.morrow <at> trioragroup <dot> com
>
>
>
>
> On Thu, Mar 19, 2009 at 6:22 PM, Tipton, Josh
> <Josh.Tipton@xxxxxxxxxxxxxx> wrote:
>> That is not 100% correct. I just performed this migration without a hitch.
>> There is a metalink article that must be followed to a T.
>>
>> ----- Original Message -----
>> From: ora-apps-dba-bounce@xxxxxxxxxxxxx <ora-apps-dba-bounce@xxxxxxxxxxxxx>
>> To: ora-apps-dba@xxxxxxxxxxxxx <ora-apps-dba@xxxxxxxxxxxxx>
>> Sent: Thu Mar 19 18:13:13 2009
>> Subject: Re: Oracle E-Business Migration from Windows to Linux
>>
>> At the most basic, what you'll be doing is:
>>
>> 1)  Perform a fresh install for all components on your target platform.
>>
>> 2)  Assuming that you were an 11.5.10.2 fresh install on your source, you'll
>>     want to apply the TARGET version (or generic) of any patches that were
>>     applied to your SOURCE onto your TARGET.  (So, if you applied the
>> WINDOWS
>>     or GENERIC version of patch 1234567 on your SOURCE, you'll want to get
>>     the LINUX or GENERIC version and apply that [options=nodatabaseportion
>> or
>>     preinstall=y] to your fresh-install TARGET.)  The goal here is to bring
>>     your filesystem into allignment with the code that's in your database.
>>
>> 3)  Perform a database migration (export/import or expdp/impdp, if
>>     available).
>>
>> Now, a couple of things.
>>
>> 1)  Export/Import is slow.  However, odds are you can't just copy the
>>     datafiles over, so you'll have a choice to make here... if you upgrade
>>     the database to 10g (on Windows) you can use DataPump (expdp/impdp) to
>> do
>>     the platform migration.  It's also possible you could use "transportable
>>     tablespaces".
>>
>> 2)  Instead of manually collecting and applying the "patch delta" yourself,
>>     you should use Oracle's "manifest" feature (as outlined in MetaLink Note
>>     238276.1).  In this sense, you will upload a information bundle to
>> Oracle
>>     that tells them exactly which patches have been applied to your SOURCE
>>     and they will provide you with a single patch to do the catch-up.
>>
>> Best approach?  Note 238276.1.
>>
>> Approximate time required?  Depends on your hardware and size of database.
>> You should have no trouble accomplishing it over a weekend (after having
>> done
>> a few practice runs, and of course, going through the proper testing).
>>
>> Risk?  Not much, really.  "custom tables" will come over with the
>> export/import.  You'll have to re-deploy custom forms, reports, etc.
>> However, those should be platform agnostic (as they are "interpreted"
>> instead
>> of actually being executed by the OS).
>>
>> -- James
>> ----------------------------------------------------------------------
>> James J. Morrow | Senior Oracle Applications DBA | TriOra Group, LLC
>> morrow.james <at> gmail <dot> com
>> james.morrow <at> trioragroup <dot> com
>>
>>
>>
>>
>> On Thu, Mar 19, 2009 at 5:47 PM, hyder hussain syed <sd.hyder@xxxxxxxxx>
>> wrote:
>>>
>>>
>>> Hi All
>>>
>>>
>>>
>>>
>>>
>>> We are planning to migrate Oracle E-Business Suite 11i from Windows to
>>> Linux
>>> and upgrade the database also:
>>>
>>>
>>>
>>> Current Environment:
>>>
>>> OS: windows 2003
>>>
>>> Applications: 11.5.10.2
>>>
>>> Database    : 9.2.0.7
>>>
>>> Node: single node
>>>
>>>
>>>
>>> Target Environment:
>>>
>>>
>>>
>>> OS:  Linux
>>>
>>> Applications: 11.5.10.2
>>>
>>> Database: 10g
>>>
>>>  Node    : (single or multi)
>>>
>>>
>>>
>>>
>>>
>>> My Queries are:
>>>
>>>
>>>
>>> 1. What is best approach?
>>>
>>> 2. Approximate required time for application and database migration
>>>
>>> 3. What is the risk  (spl custom tables ,schema,reports etc)
>>>
>>>
>>>
>>>
>>>
>>> If anyone have done please share their experience or docs
>>>
>>>
>>>
>>> Thanks in Advance
>>>
>>>
>>>
>>> Thanks & Regards
>>>
>>> Hyd
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> ******************************************************************************
>> This email contains confidential and proprietary information and is not to
>> be used or disclosed to anyone other than the named recipient of this email,
>> and is to be used only for the intended purpose of this communication.
>> ******************************************************************************
>

Other related posts: