界面配置

首选项->oracle->连接
配置oracle主目录为D:\soft\plsql\instantclient_11_2
oci库为：D:\soft\plsql\instantclient_11_2\oci.dll

环境变量

添加环境变量
变量名：ORACLE_HOME
变量值：D:\soft\plsql\instantclient_11_2
变量名：TNS_ADMIN
变量值：D:\soft\plsql\instantclient_11_2 >>该参数不设置在登录plsql时候就找不到tnsnames.ora文件中配置的数据库链接
变量名：NLS_LANG
变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

tnsnames.ora放入到TNS_ADMIN对应的目录

pve_ora =
  (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
    )
 (CONNECT_DATA =
   (SERVICE_NAME = helowin)
 )
)