Skip to main content

Hello  community ,

My company use IFS CLOUd 23R1 and the IFS support have no solution to configure application to use active dataguard with oracle database 19c.

When I do a switchover, the application does not connect to the new primary database.

Has anyone ever used active datguard with IFS CLOUD?

 

Regards

I haven’t used it with IFS Cloud myself (I am assuming you mean on-premise and not IFS-hosted) but I think it should work.  I don’t know if it would be a seamless failover though for existing sessions....  is that what you’re expecting?  

What is your Application Server configured to point to for the database connectivity?  You would want to ensure that it is pointing to the dataguard connection name and not explicitly pointing to a single DB hostname.    Take a look here for an example of the formatting needed for the TNSNAMES entry, with the connection presumably needing to point to UATSIE.WORLD for this example and not HOSTNAME1.COM or HOSTNAME2.COM.

https://support.oracle.com/knowledge/Middleware/2303116_1.html

 

HTH,

Nick


It won’t seemless failover, but it is good for Disaster recovery. We use IFS 10 on premise on OCI with active dataguard. No issue so far. But not sure it would work with IFS CLOUd 23R1


I haven’t used it with IFS Cloud myself (I am assuming you mean on-premise and not IFS-hosted) but I think it should work.  I don’t know if it would be a seamless failover though for existing sessions....  is that what you’re expecting?  

What is your Application Server configured to point to for the database connectivity?  You would want to ensure that it is pointing to the dataguard connection name and not explicitly pointing to a single DB hostname.    Take a look here for an example of the formatting needed for the TNSNAMES entry, with the connection presumably needing to point to UATSIE.WORLD for this example and not HOSTNAME1.COM or HOSTNAME2.COM.

https://support.oracle.com/knowledge/Middleware/2303116_1.html

 

HTH,

Nick

 

Hi Nick,

thanks for your feedback but Active Dataguard works independently of IFS Cloud.

The issu is at the IFS CLOUD side, which does not know how to switch connection to the new primary database after switchover.

regards


Reply