访问 Oracle 推荐用“ PLSQL Developer ”。不过要连接 Oracle 还要在本机上装上 Oracle 自己的客户端程序,里面提供了 JDBC 包和一些配置。要连接服务器还得配置一下,
不用 GUI 而直接改 tnsnames.ora 文件,
E:\Oracle\product\10.1.0\Client_3\NETWORK\ADMIN\tnsnames.ora
内容如下 ( 两面有两个配置了 ) :
# TNSNAMES.ORA Network Configuration File: E:oracleora92networkadmintnsnames.ora
# Generated by Oracle configuration tools.
WXXRDB_192.168.3.2 = #显示在客户端得名称
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = wxxrDB)数据库名称
(SERVER = DEDICATED)
)
)
WXXRDB_192.168.4.2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = wxxrDB)
(SERVER = DEDICATED)
)
)