EBS Upgrade and Migration - Cut over Plan

[senthil]

Hi Erman,

 
You are doing great job!!!!!




Now we are doing the ebs migration from Windows 2003 server 32 bit to OEL 7 64 bit.

Source:

DB Ver: 10.2.0.4

Application: 12.0.4 Modules: HR and Payroll

OS: Windows 2003 server 32 bit

 

Target:

DB Ver: 12cR1

Application: 12.1.3

OS: OEL 7 64 BIT

 

We did the Migration in TEST, it is running row. The total process consumed around 23 days.

 

In windows server 2003 sp2 32 Bit  we did 10.2.0.4 to 11.2.0.4 , 12.0.4 to 12.1.1, 12.1.1 to 12.1.3 --> Then migrated all to linux OEL 7 64 bit --> Upgraded DB to 12cR1 .

 

Now the EBS 12.1.3 is running with 12cR1 DB. Modules: HR and Payroll

 

We have a plan to do the same thing in PROD.

 

Plan : Taking clone of production as preprod, doing the upgrdation and Migration in Preprod. Then Migrating the required schema  using datapump from running production(10gr2 on windows to 12cR1 on Linux 64). After that Change the Preprod as PROD, then decommission the Existing production running on windows server. is it ok?

But i hope the application table structure is differed with versions.

 

Please let me know your feedback on this.

 

Thanks

Senthil

[ErmanArslansOracleBlog]

You are upgrading doing a big upgrade (EBS 12.0 to 12.1 and DB 10G to 12C), and you are planning to do it in PREPROD and then export/import schemas from PROD (old version) to PREPROD?
This is not supported.
You shouldn't do this.
You need to upgrade PROD properly..

[senthil]

Hi Erman,

Thanks for your reply.

Ok, I will do the production upgrade + Migration. It will take around 15-20 days.

But my concern is how to keep the production downtime for 2 weeks.

Is there any alternate solution?

Thanks
-Senthil

[ErmanArslansOracleBlog]

15-20 days?
This is huge. How do you calculate those number of days?

We do these kinds of things in weekends.. If there is a big work which can't fit in a weekend, then we divided that work into pieces..

ofcourse, at the end of each piece of work, the system should be in a supported/certified position. (in terms of tech stack and versions)

For ex: we upgrade db tier in a weekend.
Then we upgrade EBS apps tier in another weekend..

Just wanted to give you an idea.

[senthil]

Thanks Erman ,

I will work out your idea "divide the works" with team.

[senthil]

Hi Erman,


We have completed the project successfully. Thanks for your Advice!!

Thanks
-Senthil