轻便的客户端oracle instant client安装备忘:
假定instant client 解压到E:\OracleInstantClient
1.SET PATH=E:\OracleInstantClient;
2.SET TNS_ADMIN=E:\OracleInstantClient
3.新建一个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那么需要设置SET SQLPATH=E:\OracleInstantClient
6.如果查询结果为乱码,设置set NLS_LANG=XXXX(我自己是SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280)
posted on 2007-09-13 17:12
老妖 阅读(8042)
评论(1) 编辑 收藏