How to fix the Oracle error ORA-28543: Error initializing apply connection to non-Oracle system?

In this post, you’ll learn more about the Oracle ErrorORA-28543: Error initializing apply connection to non-Oracle system with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28543: Error initializing apply connection to non-Oracle system

Reason for the Error ORA-28543: Error initializing apply connection to non-Oracle system

Attempt to initialize connection to non-Oracle for heterogeneous replication failed.

How to fix the Error ORA-28543: Error initializing apply connection to non-Oracle system ?

You can fix this error in Oracle by following the below steps

Check if the listener used to connect to the gateway is up and is correctly configured. Make sure that the database link used has been configured correctly and, if a tnsnames alias has been used in the database link definition, make sure that the configuration of the entry in tnsnames.ora has been done correctly.