Apply OS: Windows, macOS

Apply Navicat Product: Navicat for Oracle, Navicat Premium

Apply Navicat Version No.: ALL



Please check the OCI library directory set in Options (In the menu bar, choose Tools > Options > OCI / Environment) is correct or not.

If the path is: e.g. c:\client1\BIN\oci.dll

Then, the tnsnames.ora should be located at c:\client1\network\admin\tnsnames.ora or c:\client1\net80\admin\tnsnames.ora



Please ensure there is a correct tnsnames.ora file inside the TNS_ADMIN path. (In the main bar, choose Navicat for Oracle/Navicat Premium > Preferences > Environments / Environment tab)

Have more questions?
Submit Ticket