Error when opening a saved Data Comparison (.DCP) file: "ORA-12154" or "Can not obtain Oracle..." (4302378)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error when opening a saved Data Comparison (.DCP) file: "ORA-12154" or "Can not obtain Oracle..."
Description

Error when opening a saved Data Comparison (.DCP) file:

"Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server."

AND / OR

"ORA-12154: TNS: could not resolve the connect identifier specified"
Cause

Multiple Oracle Clients are installed in the PC including some invalid ones.
Resolution

Add the Windows Environment Variable "TNS_ADMIN" and point it to the location of the tnsnames.ora file. Also ensure the Oracle Client Home Bin path (for the client you want to use) is in the beginning of the PATH environment variable.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title