topic Re: Replicate - OCI Error ORA-12560 - Oracle Source in Qlik Replicate

Replicate - OCI Error ORA-12560 - Oracle Source

guilherme-matte — Thu, 08 Dec 2022 00:26:27 GMT

Hello All

We are configuring the replicate in an Oracle source to Azure. Whenever we start the replicate process, after configuring the endpoints, the process loading bar goes up to 75% and enters a loop. The logs is the following:

Any ideas if its Replicate or the Database side that needs to be configured?

I found the following post: Qlik Replicate task does not start with OCI error ... - Qlik Community - 1935117

Will go into these inputs, but would appreciate additional info and if someone already faced something similar.

Cheers

Re: Replicate - OCI Error ORA-12560 - Oracle Source

sureshkumar — Thu, 08 Dec 2022 02:32:05 GMT

Hi Team,

As mentioned in the Article please check you have entered the ASM details in Oracle source endpoint advanced setting.

and also check "Access privileges when using Replicate Log Reader to access the redo logs"
Required ASM Privileges
SELECT on V_$TRANSPORTABLE_PLATFORM

Grant the SELECT on v_$transportable_platform privilege if the Redo logs are stored in ASM and accessed by Replicate from ASM.

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDBSource_Security.htm

Regards,

Suresh

Re: Replicate - OCI Error ORA-12560 - Oracle Source

john_wang — Thu, 08 Dec 2022 14:47:34 GMT

Hello @guilherme-matte , copy @sureshkumar ,

Oracle classify this as a 'generic protocol adapter error'. It indicates that Oracle client does not know what instance to connect to or what TNS alias to use. Besides Suresh's comment, we also need to check:

1. What's the Oracle client/server version? if they are compatible, and what's the client type ? instant client or a 'fat' one with TNS configured

2. if Oracle client is installed/configured correctly in Replicate server, or you may try access the Oracle server thru SQLPlus or ODBC DSN

3. Oracle Listener or database is not up or not healthy

4. Set SOURCE_CAPTURE/SOURCE_UNLOAD to Verbose to see if any helpful information printed in task log file

5. Check if Connection between Oracle client and server has random problem (TCP/IP or network side). DBA may check Oracle side log to further understand the reason.

Regards,

John.

Re: Replicate - OCI Error ORA-12560 - Oracle Source

guilherme-matte — Fri, 09 Dec 2022 00:30:41 GMT

Hello John!

Just to check my understanding, these should be done even if the connection with the Oracle endpoint is successful? In my case replicate is being able to successful connect and find the db's in oracle when i test the connection, but will enter the loop and generate this error when i actually run the task.

The db version is oracle database 11g release 11.2.0.2.0 with ASM, which seems to be compatible.

Also, thank for the tips, will make sure to go through them

Regards!

Matte

Re: Replicate - OCI Error ORA-12560 - Oracle Source

john_wang — Fri, 09 Dec 2022 06:41:02 GMT

Hello @guilherme-matte ,

Thanks for the update. The Endpoint Connection Test is a ping test, sometimes it cannot detect the connection issues especially the rare runtime or random errors; when it comes to Design Tables selection, it's straight: Replicate get the available tables list by query the system tables and show them in the windows, it's irrelevant to ASM access at all but only general Oracle connection and access. In short, it's hard to tell the connection stability by the Endpoint Connection Test result.

Hope this helps.

Regards,

John.