EBS 12.2.6 Upgrade in Oracle Database Appliance

[SSBob]

Hi Erman,

Hope you are doing good. We are planning to Migrate & Upgrade our existing EBS applications to ODA and the details as follows.

Can you please suggest the best route to accomplish.

Existing Environment:
-------------------------------
Application: EBS 12.1.3
Database: 12.1.0.2
OS: HP UX Blade Server

Target Environment:
--------------------------
Application: EBS 12.2.6
Database: 12.1.0.2
OS: Oracle Database Appliance (ODA 5.2)


Database Migration can be done by Datapump / TTS (Transportable Tablespace Migration) But to Upgrade EBS Applications am bit afraid due to below concerns.

Have reviewed the document "http://www.oracle.com/technetwork/database/database-appliance/oda-ebs-virtualized-wp-2183063.pdf" which is referring to EBS 1224 templates with database version 11204, Where as our database is already in 12102 version.

Have also reviewed if any available VM Appliances Templates for EBS R1226 with DB 12102 and am able to find only for Vision instance, In this scenario can you please suggest me if I have any other options.

Thank You.

[ErmanArslansOracleBlog]

You have a serious upgrade..
What kind of EBS upgade are you planning to upgrade?
option1)Will you upgrade EBS 12.1 to 12.2 ? or option 2) will you install a fresh EBS 12.2 and migrate your data from EBS 12.1 to this new EBS 12.2?

Migrating to the ODA is another work, which can be thought as a straight forward thing (once the above upgrade is done or decided/planned)

[SSBob]

Thank you for the reply. In this process, the source server (HP UX Blade Servers) doesn't have sufficient resources (RAM & CPU) for performing the EBS upgrade.So am planning to do as below.

1) Create a 12CR1 database in ODA_Base

2) Migrate database from HP UX to ODA server (expdp/impdp)

3) Create & Clone EBS R12.2.3 template on Guest VM

4) Apply R12.2.0 upgrade driver, ADOP Enabling patch, Delta/TXK Patches & RUP patch for 12.2.6

Please suggest me if this plan works or if I have to follow any different approach.

If I go with option 2 - will you install a fresh EBS 12.2 and migrate your data from EBS 12.1 to this new EBS 12.2?

I still have to apply upgrade drivers I believe as the data will be still  R12.1.3.

On Fri, Mar 16, 2018 at 2:49 AM, ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

You have a serious upgrade..
What kind of EBS upgade are you planning to upgrade?
option1)Will you upgrade EBS 12.1 to 12.2 ? or option 2) will you install a fresh EBS 12.2 and migrate your data from EBS 12.1 to this new EBS 12.2?

Migrating to the ODA is another work, which can be thought as a straight forward thing (once the above upgrade is done or decided/planned)

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-6-Upgrade-in-Oracle-Database-Appliance-tp5397p5399.html

To unsubscribe from EBS 12.2.6 Upgrade in Oracle Database Appliance, click here.
NAML

[ErmanArslansOracleBlog]

So, you are planning to migrate your EBS 12.1 to ODA and then do the EBS upgrade there.
Migrate your DB to ODA_BASE nodes, and migrate your Apps Tier to Guest VMs..
that 's ok.

As for your question regarding option 2: you don't have to migrate any data..  You will just install a fresh EBS 12.2 instance, your functional teams will do the setup, and your functional+developer teams will migrate the data from EBS 12.1 to 12.2 using APIs and etc.. (the customization will also be migrated between these 12.1 and 12.2 instances).. Note that, generally, not all the data is migrated from the old release to new release... So in this option, the old version EBS will still be running (at least for a while) for archiving and reporting purposes. This is a decision to be made and it is not decided by DBAs. . The project owner and the business side should decide on this.

[SSBob]

Thank you for the information.

On Mon, Mar 19, 2018 at 7:18 AM, ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

So, you are planning to migrate your EBS 12.1 to ODA and then do the EBS upgrade there.
Migrate your DB to ODA_BASE nodes, and migrate your Apps Tier to Guest VMs..
that 's ok.

As for your question regarding option 2: you don't have to migrate any data..  You will just install a fresh EBS 12.2 instance, your functional teams will do the setup, and your functional+developer teams will migrate the data from EBS 12.1 to 12.2 using APIs and etc.. (the customization will also be migrated between these 12.1 and 12.2 instances).. Note that, generally, not all the data is migrated from the old release to new release... So in this option, the old version EBS will still be running (at least for a while) for archiving and reporting purposes. This is a decision to be made and it is not decided by DBAs. . The project owner and the business side should decide on this.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-6-Upgrade-in-Oracle-Database-Appliance-tp5397p5416.html

To unsubscribe from EBS 12.2.6 Upgrade in Oracle Database Appliance, click here.
NAML