1：PLSQL Developer安装

2：解压instantclient

3：设置instantclient 相关的环境变量

4：新增sqlnet.ora文件

内容为

# sqlnet.ora Network Configuration File: E:\app\limn\product\11.1.0\db_1\network\admin\sqlnet.ora

# Generated by Oracle configuration tools. # This file is actually generated by netca. But if customers choose to  # install "Software Only", this file wont exist and without the native  # authentication, they will not be able to connect to the database on NT. SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

5：新增tnsnames.ora文件

内容为

# tnsnames.ora Network Configuration File: E:\app\limn\product\11.1.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools. 1.1.7.88 =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.7.88)(PORT = 1521))     (CONNECT_DATA =       (SERVER = TEST)       (SERVICE_NAME = TEST)     )   ) 1.1.2.26 =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.2.26)(PORT = 1521))     (CONNECT_DATA =       (SERVER = ORCL11G)       (SERVICE_NAME = ORCL11G)     )   ) 1.1.2.28 =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.2.28)(PORT = 1521))     (CONNECT_DATA =       (SERVER = orcl)       (SERVICE_NAME = orcl)     )   )