SQL Developer、Navicat Premium、PLSQL Developer 通过 Oracle Instant Client 连接

目录

工具准备

Oracle Instant Client

SQL Developer

配置

Windows System

Oracle Instant Client

SQL Developer

PLSQL Developer

Navicat Premium

---

工具准备

Oracle Instant Client

http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

SQL Developer

https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

 

配置

Windows System

SET ORACLE_HOME=D:\db\instantclient_11_2 SET TNS_ADMIN=D:\db\instantclient_11_2 SET PATH=%ORACLE_HOME%;%PATH% SET NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Oracle Instant Client

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)   NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

tnsnames.ora

orcl=   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = orcl)     )   )

SQL Developer

PLSQL Developer

 

Navicat Premium