1.oracle官网下载oracle客户端
1.链接:https://www.oracle.com/technetwork/topics/winx64soft-089540.html
因为plsql都是32位的,所以oracle客户端选择32位(电脑windows10 64位)
2.全部解压
3.新建NETWORK/ADMIN/tnsnames.ora
2.添加环境变量
ORACLE_HOME=C:\java\ruanjian\plsqldeveloper\oci\instantclient_10_2
TNS_ADMIN= C:\java\ruanjian\plsqldeveloper\oci\instantclient_10_2\NETWORK\ADMIN
path添加C:\java\ruanjian\plsqldeveloper\oci\instantclient_10_2
NLS_LANG=AMERICAN_AMERICA.UTF8(不清楚)
3.plsqldeveloper配置
oracle主目录:C:\java\ruanjian\plsqldeveloper\oci\instantclient_10_2
oci库:C:\java\ruanjian\plsqldeveloper\oci\instantclient_10_2\oci.dll