topic Re: Facing issue while connecting to oracle as a source. in Qlik Replicate

Facing issue while connecting to oracle as a source.

suvbin — Wed, 01 Mar 2023 07:34:36 GMT

Hi,

Am facing issue while connecting to the source. Below attached is the tns ora file content. And also find the screenshot of the error.

pqrs5nvs39r -- this is my computername. Replicate is running on this name

Thanks in advance.

Re: Facing issue while connecting to oracle as a source.

john_wang — Wed, 01 Mar 2023 08:19:37 GMT

Hello @suvbin ,

Thanks for reaching out.

Looks like a regular Oracle client/server connectivity issue. The most easy way to setup the Oracle client/server is installing Instant Client, no need to config TNS, utilize SQLplus to troubleshoot the connectivity issue. There are a few similar article, see the last comment in this article. Just replace the Linux platform by Windows platform.

Hope it helps.

Regards,

John.

Re: Facing issue while connecting to oracle as a source.

suvbin — Wed, 22 Mar 2023 10:47:51 GMT

Am getting below error when establishing source connection from oracle in Qlik replicate, am getting this error "Oracle CDB environment is not yet supported".

Am using oracle 19c (19.3.0.0.0)

Request your help here.

Thanks.

Re: Facing issue while connecting to oracle as a source.

john_wang — Wed, 22 Mar 2023 12:08:04 GMT

Hello @suvbin ,

If the Oracle is CDB environment then please configurate Replicate to connect to a given PDB rather than CDB, and also make sure you are using Replicate Log Reader option, because connecting to a PDB using Oracle LogMiner is not supported.

Hope this helps.

Regards,

John.

Re: Facing issue while connecting to oracle as a source.

suvbin — Thu, 23 Mar 2023 03:15:54 GMT

kindly assist how to connect to pdb rather than cdb. here are the connections.

Re: Facing issue while connecting to oracle as a source.

john_wang — Thu, 23 Mar 2023 07:15:12 GMT

Hello @suvbin ,

You may check your PDBs name , and replace the instance name by PDB name in connection string, for example:

C:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 21.0.0.0.0 - Production on Thu Mar 23 14:59:14 2023
Version 21.3.0.0.0

SQL> conn / as sysdba
Connected.
SQL> select name from v$pdbs;

NAME
-------------------------------------------------------
PDB$SEED
ORCLPDB1
ORCLPDB2

SQL>

In the above sample, there are 2 PDBs , ORCLPDB1 and ORCLPDB2, they can be used as Replicate source if they are CDC ready for Replicate, an example of connection string: OracleServer:1521/ORCLPDB1. Or check with your DBA for help.

Regards,

John.

Re: Facing issue while connecting to oracle as a source.

suvbin — Fri, 24 Mar 2023 01:59:11 GMT

Am able to connect to the pluggable database. But how to create tables under that database. ? Actually i connected with the pluggable database in SQL Developer tool. Below are the cred that i have given. And also i tried creating a table there. but its not showing up in the replicate. Kindly assist.

Re: Facing issue while connecting to oracle as a source.

john_wang — Tue, 28 Mar 2023 14:14:19 GMT

Hello @suvbin ,

Thanks for the feedback.

In general if you cannot find a table after creation, maybe it's created in another schema, or it's in CDB, or another PDB ... you may enable SERVER to Verbose to check the SQL how Replicate prepares the available tables list. Hope this helps.

Regards,

John.