Skip to main content
Question

Is Active Dataguard compatible with IFS CLoud ?


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 1 reply

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

3 replies

NickPorter
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • 324 replies
  • March 18, 2025

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


Forum|alt.badge.img+5
  • Do Gooder (Customer)
  • 18 replies
  • March 18, 2025

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


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • March 19, 2025
NickPorter wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings