How to fix the Oracle error ORA-26913: must connect to instance string where string string server “string” is running?

In this post, you’ll learn more about the Oracle ErrorORA-26913: must connect to instance string where string string server “string” is running with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26913: must connect to instance string where string string server “string” is running

Reason for the Error ORA-26913: must connect to instance string where string string server “string” is running

The client application was not connected to the same Oracle RAC instance as the specified Oracle GoldenGate or XStream server.

How to fix the Error ORA-26913: must connect to instance string where string string server “string” is running ?

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

Connect to the specified instance using the network service name obtained from the following query: SELECT network_name FROM all_queues q, all_xstream_outbound ob WHERE q.owner = ob.queue_owner AND q.name = ob.queue_name AND server_name = ‘‘;