SQL Developer、Navicat Premium、PLSQL Developer 通过 Oracle Instant Client 连接
目录
工具准备
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