oracle链接的配置--product\11.2.0\client_1\network\admin\tnsnames.ora

 

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里配置这些内容，其实质就是在这个文件写这些东西，所以你明白原理以后，配置会更快，更准确。