Switching EBS Application from primary to Secondary Database

[Tabrez]

Hi Erman,

We are working on the migration of our app servers (EBS R12.2.4) to new servers and we are configuring the new servers on Standby snapshot mode. Can we change database details in the R12.2 context file from secondary db connection details to primary connection details without doing a Switchover after new app is configured on secondary server ? The main purpose of doing this is to decrease the downtime by keeping old servers running on Primary doing activity on standby site.

Please advise on this...Thanks Brother

[ErmanArslansOracleBlog]

Hi,

I didn't understand what you are asking.

So you try to migrate both your apps and db tier to new nodes.
You have a sync standby database and probably you have a sync apps tier.
So, you will just do a switchover or failover both for apps and db.
The downtime will already be minimal if you follow the Business Continuity documents in Oracle Support.
For instance: Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1)

Section 5: Configuring the Application Tier After the Standby Database has been Enabled
Section 6: Performing Role Transitions

Step 5 has actions to decrease the downtime..

I just didn't get your point..

[Tabrez]

Hi,


Thanks for the response

We don't have any application configured on standby site. If we want to connect primary application server to standby db site (after switchover new primary). Do we need to run adcfgclone on new primary application server  as db hostname and dns is going to be changed after switchover.
 

[ErmanArslansOracleBlog]

Yes. You need to do that. There may be some custom actions , some moves that involves running autoconfig and running some APIs and scripts in order to get rid of that adcfgclone execution need, but I wouldn't get into that..  adcfg is nice and clean.

-----
Check ->  Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1) -- you don't do an apps tier failover or switchover, but still it is your guide..

-----
*Also, check the document  "Configuring Oracle E-Business Suite Release 12.x Using Logical Host Names (Doc ID 1968231.1)

*Section 6.2.1: Changing Host Name of Database Tier Node
Case 1 (Recommended) ->

Here in this case, there is an alternative method provided.. So you do that method and try to make the hostname change transparent to the environment.. You may also consider this.

Basically, it says;

Treat the current host name of the database tier as the logical name of the host.
Change the host name of the server only in DNS for external access.

----
Another ref: 12.2 E-Business Suite Applications Technology Stack Steps To Change The Hostname In E-Business Suite 12.2 (Doc ID 1963018.1)