1 安装 PLSQL Developer 10.0.5.1710 和 ODAC_Client_112021
2 配置监听
# TNSNAMES.ORA Network Configuration File: C:\Program Files (x86)\Oracle\odac_client\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
admin_170=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.170)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = admin)
)
)
3 配置oci库 , 选择Tools->Preferences,在Oracle Home OCI Library两栏中分别填入Oracle客户端的路径和OCI文件的路径(oci.dll文件直接在instantclient_10_2文件夹下)。
转载于:https://blog.51cto.com/zhang916/1323684