oracle 客户端配置

找到你 的oracle的安装目录

如：E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN

 在此文件夹下找到 tnsnames.ora 文件用 记事本打开 

添加 

#WONDERTEK_IDCM_BEGIN
orcl_192.168.150.165 = 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.165)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xf)
)
)
#WONDERTEK_IDCM_END

IP：HOST = 192.168.150.165

端口：PORT = 1521

实例：SERVICE_NAME = xf

在pl/SQL 中就可以看到

即 选中部分是其配置的别名