AMERICAN_AMERICA.ZHS16GBK
4.plsql配置
 
 5.在instantclient_11_2目录下新建文件夹 \NETWORK\ADMIN
 tnsnames.ora
 
# tnsnames.ora Network Configuration File: F:\myWorkSoft\PLSQL1306\instantclient_11_2\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
# 配置多个数据库连接，就是复制这一段，添加新的ip、端口、实例名就行了
15_ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.15)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
配置好多个数据库连接的效果如图
 
 
6.把tnsnames.ora复制到\NETWORK\ADMIN目录下。
 至此，打开plsql developer，可以看到database 和 connect as
 
 
-------------------------------end---------------------------------
 以下两个配置作为备份。。
 
**listener.ora**
```bash
# listener.ora Network Configuration File: F:\myWorkSoft\PLSQL1306\instantclient_11_2\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = F:\myWorkSoft\PLSQL1306\instantclient_11_2)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:F:\myWorkSoft\PLSQL1306\instantclient_11_2\bin\oraclr11.dll")
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = F:\myWorkSoft\PLSQL1306\instantclient_11_2)
      (SID_NAME = orcl)
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = PC201508131439)(PORT = 1521))
ADR_BASE_LISTENER = E:\app\Administrator
sqlnet.ora
 
# sqlnet.ora Network Configuration File: F:\myWorkSoft\PLSQL1306\instantclient_11_2\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = E:\app\Administrator
				
大佬们在使用PLSQL developer连接Oracle的时候经常出现一些小问题导致数据库连接失败，小弟我给大佬们总结一下连接数据库的配置流程
一、配置相关配置文件
1.数据文件的路径
pl\sql developer主要有两个文件需要配置。
其路径在Oracle安装路径\product\11.2.0\dbhome_1\NETWORK\ADMIN下，分别是tnsnames.ora和...
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN = D:\install\PLSQL\instantclient_11_2
三. PL/SQL Developer 环境设置
1. 位置
1、监听器(LISTENER) 
监听器是Oracle基于服务器端的一种网络服务，主要用于监听客户端向数据库服务器端提出的连接请求。既然是基于服务器端的服务，那么它也只存在于数据库服务器端，进行监听器的设置也是在数据库服务器端完成的。
2、本地服务名(Tnsname) 
Oracle客户端与服务器端的连接是通过客户端发出连接请求，由服务器端监听器对客户端连接请求...
				
plsql编辑tnsnames.ora插件，解压放到xxx\PLSQL Developer 12\PlugIns目录下重启即可，注意只支持32位的plsql（64位系统也可以安装32位plsql
）。可以在plsql界面直接通过可视化界面编辑tnsname.ora，测试、开发必备~