配置oracle数据库别名

参考资料:
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)
)
)

posted on 2023-02-03 22:12  圣人已死  阅读(134)  评论(0)    收藏  举报