topic Re: Oracle Rac Source Endpoint using SCAN with Qlik replicate in Qlik Replicate

Oracle Rac Source Endpoint using SCAN with Qlik replicate

Saravanakumar27 — Thu, 07 Sep 2023 09:07:27 GMT

Hi,

I am using Qlik Replicate Nov 2021 version and I have a requirement to connect to Oracle Rac Source Endpoint using SCAN.

I need to know the following.

1. Can I provide the SCAN domain name in my source end point connection will Qlik Replicate acept it?
2. Is there any additional configuration required
3. What is the configuration required in the Advanced connection setting using Replicate Log Reader (Replicate Log Reader was recommended when using Oracle RAC setup)

Thanks,

Saravanakumar

Re: Oracle Rac Source Endpoint using SCAN with Qlik replicate

john_wang — Fri, 08 Sep 2023 09:24:12 GMT

Hello @Saravanakumar27 ,

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

Yes, you can. From Qlik Replicate view, there is no special regarding RAC SCAN setup, Replicate works well with connection to the individual nodes, or SCAN node, However , connect to SCAN node is recommended as it's more stable in case one of the nodes is inaccessible.

3. You are right, Replicate Log Reader is always recommended because of better performance and less impact to the source system. if the Oracle source is PDB then it's the only choice as LogMiner does not support a pluggable PDB.

Hope this helps.

Regards,

John.

Re: Oracle Rac Source Endpoint using SCAN with Qlik replicate

Saravanakumar27 — Fri, 08 Sep 2023 09:36:51 GMT

Hi @john_wang,

Thanks for your information.

Can you tell me about the configuration steps in the advanced tab? Also is there any link to the forum where I can see this?

Thanks,

Saravanakumar

Re: Oracle Rac Source Endpoint using SCAN with Qlik replicate

john_wang — Fri, 08 Sep 2023 09:55:16 GMT

Hello @Saravanakumar27 ,

Thanks for the update.

More detailed configuration can be found in Replicate User Guide, Setting general connection properties , the connection string is as same as the standalone node, hope the Oracle doc, About the SCAN helps a bit.

Regards,

John.

Re: Oracle Rac Source Endpoint using SCAN with Qlik replicate

SushilKumar — Sat, 09 Sep 2023 13:47:56 GMT

Hello Team,

Yes, you can use SCAN name for Qlik replicate connection. QR works same as Any Application user connects.

as SCAN mainly works on the Cluster level. As any application connection made with Service name. when you define service, you use host name/VIP.

sample

TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testscan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST.database.com)
)
)

qrusr/@scan_name:1521/test

either you can use one of the above menthod.

you can install Oracle administrative Client and use TNSNAMES.ORA

or you can put entire Service name into the connection string for Oracle endpoint under Endpopint settings.

Choice is yours.

Regards,

Sushil Kumar