oracle免安装客户端+plsql配置

oracle数据库客户端提供安装和免安装的下载，这里备忘免安装配置方式

[list=1]

首先去oracle网站下载Instant Client Package

http://download.oracle.com/otn/nt/instantclient/121010/instantclient-basic-nt-12.1.0.1.0.zip

把下载的压缩包解压到硬盘，比如这里加到到C:\ 根目录。如图

打开解压的目录，创建目录"NETWORK"  然后再在   NETWORK  下创建  ADMIN ，然后在ADMIN文件夹下创建文件tnsnames.ora,最好可以从服务器端复制此文件 如图 

编写tnsnames.ora内容，如果不是从服务器端复制过来的，这里的配置映射服务器端监听

# tnsnames.ora Network Configuration 
# Generated by Oracle configuration tools.

62_ORCL =                #问本行最前面不能有空格
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.62)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

67_ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.67)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

配置环境变量

NLS_LANG       SIMPLIFIED CHINESE_CHINA.ZHS16GBK
ORACLE_HOME    C:\instantclient_11_2
TNS_ADMIN      C:\instantclient_11_2\NETWORK\ADMIN

安装plsql,安装完之后配置plsql

安装完成

[/list]