我目前用的11g的oracle 找到E:\app\leiyanfei\product\11.1.0\db_1\NETWORK\ADMIN这个目录
找到这个文件打开,ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = leiyanfei.hnisi.com.cn)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)安装这种格式添加实例就行了。用户名 端口之类的当然需要手动去改的。
![](https://img-my.csdn.net/uploads/201304/16/1366084539_4137.jpg)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = leiyanfei.hnisi.com.cn)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)安装这种格式添加实例就行了。用户名 端口之类的当然需要手动去改的。