topic Endpoint connection to multiple Oracle ASM servers in Qlik Replicate

Endpoint connection to multiple Oracle ASM servers

RedRabbit — Wed, 11 Dec 2024 13:21:55 GMT

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

Re: Endpoint connection to multiple Oracle ASM servers

john_wang — Thu, 12 Dec 2024 07:29:49 GMT

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.

Re: Endpoint connection to multiple Oracle ASM servers

SushilKumar — Thu, 12 Dec 2024 07:41:54 GMT

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

Re: Endpoint connection to multiple Oracle ASM servers

RedRabbit — Thu, 12 Dec 2024 09:12:20 GMT

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

Re: Endpoint connection to multiple Oracle ASM servers

SushilKumar — Fri, 13 Dec 2024 12:49:26 GMT

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

Re: Endpoint connection to multiple Oracle ASM servers

charles898caballero — Sat, 11 Jan 2025 08:28:55 GMT

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.

Re: Endpoint connection to multiple Oracle ASM servers

Attunity_user — Mon, 13 Jan 2025 21:26:59 GMT

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

EG:

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