cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle HA Setup - Application Instance connectivity

SAPSupport
Employee
Employee
0 Kudos
107

Hello Team,

We have configured the Oracle Dataguard on our SAP DB (19c). We are able to see the sync is happening between both Primary and Standby.

Primary Server Virtual Name : 

Standby Server Virtual Name : 

Problem : In Default Profile, we have maintained the parameter "SAPDBHOST=".

So when we do the failover of DB(Primary --> Standby). After the Failover my Standby becomes Primary. But in Default Profile (--> earlier primary server) is maintained. so application will fail to connect to DB.

 

So we want to know How can we define one unique name (dbSID) which always points to Primary DB (whether it is 00 or 01 node) ?

 


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

Check section "Reconnect SAP instance to database" in point 1 of following guide.
https://www.sap.com/documents/2016/12/a67bac51-9a7c-0010-82c7-eda71af511fa.html