輕便的客戶端oracle instant client安裝備忘：
假定instant client 解壓到E:\OracleInstantClient
1.SET PATH=E:\OracleInstantClient;
2.SET TNS_ADMIN=E:\OracleInstantClient
3.新建一個(gè)tnsnames.ora，然后填入
for example:
192.168.0.20 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
4.SET LD_LIBRARY_PATH=E:\OracleInstantClient
5.如果要安裝SQL plus那么需要設(shè)置SET SQLPATH=E:\OracleInstantClient
6.如果查詢結(jié)果為亂碼，設(shè)置set NLS_LANG=XXXX（我自己是SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280）
posted on 2007-09-13 17:12
老妖 閱讀(8063)
評(píng)論(1) 編輯 收藏