plsql developer连接oracle的配置文件(tnsnames、listener、sqlnet)

1.ORACLE_HOME路径：

F:\myWorkSoft\PLSQL1306\instantclient_11_2

2.path变量中也把上边的路径配好 3.配置字符集

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