oracle instantclient和plsql配置

1、下载instantclient
下载后多解压到某文件夹下
如：c:\instantclient11
注意，文件夹所在路径里，不可以有中文，不可以有空格
2、添加环境变量
新建c:\instantclient11\tnsnames.ora文件
内容如下

orclaaaa =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.207)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl)
    )
  )
orclbbbb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.208)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl)
    )
  )

添加环境变量
TNS_ADMIN=c:\instantclient11

3、配置plsql

tools-->preference-->
oracle-->connection
oracle home c:\instantclient11
OCI library c:\instantclient11\oci.dll

oracle-->logon history
store with password
保存，重新打开plsql


instantclient sqlplus配置
下载instantclient-sqlplus-11.1.0.2.0
解压后将文件复制到c:\instantclient11

环境变量里添加 %TNS_ADMIN%

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;%TNS_ADMIN%

打开命令行登录

sqlplus sys/oracle@orclaaaa as sysdba