Re: Migrate EBS 11i 11gR2 Solaris database to 12c Linux

Hello Shastry,

Our project scope increased to include archiving. The customer was able to archive more than 50% of data. To realize the disk storage gain along with platform migration, we decided to go export / import route. The customer has 7 or 8 non-production environments, so disk saving was important (I can see the Delphix folks smiling :-) ).

At a high level the steps were:

• Install 12c database home per EBS requirements and apply required patches
• Create database
• Export from 11g (Solaris) database and import to 12c (Linux) database
• database size was less than 1.5T (data only around 700G, FND_LOBS was biggest at around 200G. This table was exported/imported outside the full to save time).
• Connect 11i application to 12c database to finish pre-upgrade functional tasks
• Install R12 12.1 software
• Upgrade application and apply RUP (12.1.3).

Biju

On Wed, Jan 10, 2018 at 4:02 PM Shastry(DBA) <shastry17_at_gmail.com> wrote:

> Hi Biju,
>
> Were you able to figure out the way to do the above Platform migration and
> R12 upgrade? Please share.
>
> In my current assignment, I have to perform platform migration from 11gR2
> (AIX) to OVM/OEL where the endian formats differ and also the DB size is
> 6TB. In the second part, I have to upgrade the database from 11i to
> R12.2.7. Please advise and share your experiences and approach and it will
> definitely help me to proactively review the challenges.
>
> On Wed, Jul 22, 2015 at 2:07 PM, Biju Thomas <biju.thomas_at_gmail.com>
> wrote:
>
>> Thanks Maris. Yes, 11i is a problem. Even for R12, this blog says "Full
>> transportable export/import, a new feature in 12c to move an entire
>> database, is not certified for use with E-Business Suite databases yet. "
>>
>>
>>
>> Biju Thomas
>>
>> <http://about.me/biju.thomas>
>>
>> On Wed, Jul 22, 2015 at 1:02 PM, Maris Elsins <elmaris_at_gmail.com> wrote:
>>
>>> Sorry you're on 11i :/
>>> On Jul 22, 2015 21:02, "Maris Elsins" <elmaris_at_gmail.com> wrote:
>>>
>>>> I didn't have more time to look into it but take s look at this, looks
>>>> like exactly what you needed!
>>>>
>>>> https://blogs.oracle.com/stevenChan/entry/oracle_e_business_suite_r121
>>>>
>>>> Maris
>>>> On Jul 22, 2015 20:24, "Biju Thomas" <biju.thomas_at_gmail.com> wrote:
>>>>
>>>>> Hello experts,
>>>>>
>>>>> We have a project to migrate and upgrade EBS 11i 11gR2 database.
>>>>>
>>>>> The requirement is:
>>>>>
>>>>> *Source:*
>>>>> EBS 11i - 11.5.10.2 RUP6
>>>>> Oracle DB - 11.2.0.3 (non-RAC)
>>>>> DB OS - Solaris 10
>>>>> Database size - ~4TB (about 1TB is SYSTEM, SYSAUX, TEMP, UNDO, etc)
>>>>>
>>>>> *Requirement (migration/upgrade)*
>>>>> EBS R12 - 12.1.3
>>>>> Oracle DB - 12c 12.1.0.2 (RAC)
>>>>> DB OS - Linux OEL 6 x86-64
>>>>>
>>>>> I have been reviewing the following MOS notes:
>>>>>
>>>>> Using Transportable Tablespaces for EBS 11i Using Database 11gR2 (Doc
>>>>> ID 1366265.1)
>>>>> 11G - Reduce Transportable Tablespace Downtime using Cross Platform
>>>>> Incremental Backup (Doc ID 1389592.1)
>>>>> 12C - Reduce Transportable Tablespace Downtime using Cross Platform
>>>>> Incremental Backup (Doc ID 2005729.1)
>>>>>
>>>>> We want to do the R12 upgrade on the new Linux platform, because it
>>>>> has better CPU and memory configuration.
>>>>>
>>>>> If this was a non-EBS database, the platform migration and upgrade of
>>>>> 11gR2 to 12cR1 would be much easier. MOS note says "Cross Platform
>>>>> Incremental Backup is not certified to work with an EBS database." I am not
>>>>> sure why...
>>>>>
>>>>> Looks like we will have to go with:
>>>>> 1. Migrate database to Linux 11gR2 to 11gR2 [downtime duration depends
>>>>> on time required to copy the data files after making the tablespaces read
>>>>> only]
>>>>> 2. Upgrade database to 12c [downtime required]
>>>>> 3. Upgrade EBS from 11i to R12 [downtime required]
>>>>>
>>>>> #2 and #3 can be interchanged.
>>>>>
>>>>> Is there anyway to combine #1 and #2, or to reduce the downtime
>>>>> required in #1 or #2. Since cross-platform incremental backup method is not
>>>>> supported withe EBS, if we can migrate from 11gR2 to 12cR1 on the new
>>>>> platform in single step, at least the upgrade time can be saved.
>>>>>
>>>>> The best scenario is to migrate 11gR2 Solaris to 12cR1 Linux using
>>>>> incremental backup, but that is not supported.
>>>>>
>>>>> Any thoughts on this much appreciated...
>>>>>
>>>>> Also considered Golden Gate migration.
>>>>>
>>>>> https://blogs.oracle.com/dataintegration/entry/low_downtime_e_business_suite
>>>>> But, for EBS, GG solution works only if we engage Oracle ACS
>>>>> (Advanced Customer Services)
>>>>>
>>>>>
>>>>> Thanks for your time reading...
>>>>>
>>>>> Have a great day!
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Biju Thomas
>>>>>
>>>>> <http://about.me/biju.thomas>
>>>>>
>>>>
>>
>

-- 
Best,
Biju Thomas
www.bijoos.com

--
http://www.freelists.org/webpage/oracle-l