在C:\oracle\product\10.2.0\db_1\network\ADMIN\tnsnames.ora文件中加入
miisp_107 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tea)
)
)
注:
远程服务器ip: 192.168.0.107
端口:1521
数据库:tea
用pl/sql登陆时候的database就填 miisp_107