oracle客户端安装路径\product\11.2.0\client_1\network\admin\tnsnames.ora
其内容如下:
# tnsnames.ora Network Configuration File: E:\Oracle11g-client2-manager\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEV)
)
)
CESHISTU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
MYORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
以这个为例:
CESHISTU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
这里CESHISTU是服务名,我干脆叫它连接的别名,因为特很容易和数据库实例名混淆。
这个名字可以随便起,它最终在pl/sql的第三个下拉框数据库显示,而真正确定
连接哪个数据库的是SERVICE_NAME = orcl。这个orcl才是数据库实例名。它的连接地址
是:(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))。
这些东西当然有相关的管理客户端去设置,否则每个人都要学习这个文件的配置,那就
太不人性化了。你可以在配置和移植工具里的Net Manager里配置这些内容,其实质就是
在这个文件写这些东西,所以你明白原理以后,配置会更快,更准确。
oracle链接的配置--product\11.2.0\client_1\network\admin\tnsnames.ora
最新推荐文章于 2023-03-18 16:30:12 发布