oracle instant client

下載oracle instant client
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

下載後解壓縮
於path環境變數，附加C:\instantclient_11_2
新增環境變數TNS_ADMIN為C:\instantclient_11_2
開啟win7防火牆1521
netstat -a，仍無法連線
TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING

修改server端的listener.ora
###################################
LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = yourhost)(PORT = 1521))

)
####################################

netstat -a，此時可telnet yourhost 1521
TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING


在C:\instantclient_11_2新增tnsnames.ora文件
#########################################
TAIWAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.196)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = taiwan)
)
)
##########↑請手動輸入或copy server上的tnsnames.ora#########################
如需要使用sqlplus再下載
instantclient-sqlplus-windows.x64-11.2.0.2.0.zip ，解壓至
同instantclient-basic-windows.x64-11.2.0.2.0目錄。不能是32位元的。

Instant Client中不包含tnsping, exp/imp, rman, netca等工具。要安裝oracle client套件，如win64_11gR2_client.zip。

順便注意hosts是否設對，即可~~