Oracle客户端tnsnames.ora连接配置
Oracle90的在C:\Oracle\ora90\network\ADMIN下面
Oracel10g的在D:\oracle\product\10.2.0\db_1\network\ADMIN下面
配置如下:
RKK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)
主要就是ip和sid