Re: Oracle E-Business Migration from Windows to Linux
- From: James Morrow <morrow.james@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Fri, 20 Mar 2009 08:37:43 -0500
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:
