Endpoint connection to multiple Oracle ASM servers

[RedRabbit]

Hi,

Currently Qlik Replicate is connecting to Oracle using the ASM server which we have provided under 

ASM connection string tab in endpoint connection - "server1.abc.dlk.com:1521/+ASM"

now the oracle is configured for HA, we need to configure 2 servers - "server1.abc.dlk.com:1521/+ASM" & "server2.abc.dlk.com:1521/+ASM" so that if there is a switch in the source, Qlik will automatically switch to the active server and continue replicating.

Please let me know if this is possible and how to accomplish

Thanks,

Ram

[john_wang]

Hello @RedRabbit ,

Welcome to Qlik Community forum and thanks for reaching out here!

Good question. Not sure if the multiple ASM instance share the same storage. If yes, then I think we can input the floating IP address of the HA.

Hope this helps.

John.

[SushilKumar]

Hello @RedRabbit 

As per configuration, HA on Oracle is RAC. if you using a rac Setup then the +ASM instance running on both of the Servers. and via Connection string it would be able to connect with asm in case of any issue or failover 

Regards,
Sushil Kumar

[RedRabbit]

Thanks @john_wang , @SushilKumar ; can you please help me how to provide both the server names in the same box?

 

[SushilKumar]

Hello @RedRabbit 

As I mentioned in the earlier post. If you are using RAC then Qlik replicate is making the connection with the provided Service and wherever the +ASM instance is running ( mentioned in ASM Connection String )

ASM Connection is not managed by some other Tool it is managed by Clusterware or Grid infrastructure and the +asm instance is only accessed by the user-created on the +ASM instances which is there to cater to the certain nodes which are part of a cluster

You can not connect with another +asm instance running for all to gather different nodes as all the instance id start with +ASMn

Qr Will try to connect with the +ASM server which ever put into the ASm connection string. 

As per your environment, server1.abc.dlk.com and server2.abc.dlk.com are 2 nodes belonging to the same cluster. .

Regards,

Sushil Kumar

[charles898caballero]

Hello,

You can add both Oracle servers in Qlik Replicate’s source endpoint connection. When you configure the endpoint, add both server addresses, separated by a comma, in the connection string (for example, server1.abc.dlk.com:1521/+ASM,server2.abc.dlk.com:1521/+ASM). your Oracle setup supports Real Application Clusters (RAC) or a similar HA configuration. When you configure the connection to Oracle, the load balancing feature of RAC should help Qlik Replicate automatically failover to the available node without needing manual intervention.  you are using a connection string that supports Oracle’s load balancing (e.g., using +ASM or TNS with the correct failover and load balancing parameters configured in Oracle). The ASM-based configuration should automatically handle failover, allowing Qlik Replicate to connect to the active server. After setting this up, make sure to test the failover by shutting down one of the servers and ensuring that Qlik Replicate automatically switches to the other server without interruption in replication.

[Attunity_user]

@RedRabbit If this is ASM, the host can go one after another without commas. 

EG:

(PROTOCOL = ###)(HOST =#####)(PORT =####))(PROTOCOL = ###)(HOST =####)(PORT =####))