mac Navicat premium 链接oracle

1、下载文件:instant-client

 下载地址:https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html

2、创建tnsnames.ora文件

在此目录中/Users/xx/xx/xx/instantclient_19_8/network/admin/ 创建tnsnames.ora文件,文件内容如下

1 服务名_DATA_TEST_DB=
2     (DESCRIPTION =
3         (ADDRESS = (PROTOCOL = TCP)(HOST= ip)(PORT = 1521))
4         (CONNECT_DATA =
5             (SERVICE_NAME = 服务名)
6         )
7     )

3、配置以下内容:

4、 服务名与tnsnames.ora的服务名保持一致

原文地址:https://www.cnblogs.com/lxn0216/p/14700318.html