Apply OS: Windows, Mac

Apply Navicat Product: Navicat for Oracle, Navicat Premium

Apply Navicat Version No.: ALL

 

Windows

Please check the OCI library directory set in Options (In Navicat main menu, choose Tools > Options > OCI) 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

 

Mac

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

Have more questions?
Submit Ticket