参考资料:
https://blog.csdn.net/qq_39194322/article/details/127189004
需要配置的文件名:tnsnames.ora
文件路径:
D:\oracle\product\10.2.0\db_1\network\ADMIN
配置格式:
#别名# =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = #ip或者计算机全名#)(PORT = #端口#))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = #实例名#)
)
)
例:
ORCLdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-liucl170212)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)