oracle免装配客户端+plsql配置

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.ZHS16GBKORACLE_HOME    C:\instantclient_11_2TNS_ADMIN      C:\instantclient_11_2\NETWORK\ADMIN

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

安装完成

[/list]