利用PL/SQL developer从远程连接oracle 10g:从官网下载oracle 客户端绿色版(需要先登录),并略加配置,内容:
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
然后打开pl/sql, tools->preferences->connect,在些配置oracle home 和 oci.dll的路径,oci.dll可能也在同一目录下。
重启pl/sql,即可在登录页看到刚配置的数据库实例