1、安装oracle9i310, 连接局域网中oracle9,10的方法。
2、配置E:\Oracle\ora90\network\ADMIN\tnsnames
REPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = report)
)
)
soar6=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = soar)
)
)
soar6 可以任意起名
soar 是数据库的名字
HOST = 192.168.0.6 是服务器的地址
3、安装sqlplus链接。
4、安装Navicat for Oarcle 时必须 在工具(tool)-->选项卡(option)中填写 OCI
也就是说必须安装Oracle才能链接。