D:\all_install\Oracle10g_install\NETWORK\ADMIN\tnsnames.ora
在tnsnames.ora文件中添加如下代码,可以让pl/sql检测到
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.253.18)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
注:上面红色的“ORCL”是在pl/sql中显示的实例名称,蓝色的"orcl"是需要连接的oracle数据库的实例