pl/sql远程连接oracle
(2010-03-11 18:37)
分类： oracle 11g
通过pl/sql远程连接oracle 需要在本地装上oracle客户端,并且在E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.org添加
QC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.152)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qc.local)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.152)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qc.local)
)
)