Why I cannot see any instances under the Net Service Name when using TNS connection?

Apply OS: Windows, Mac

Apply Navicat Product: Navicat for Oracle, Navicat Premium

Apply Navicat Version No.: ALL



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



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.
Have more questions? Submit a request


Article is closed for comments.