首页 > 数据库技术 > 详细

ORACLE Instant Client 配置

时间:2015-04-09 23:40:38      阅读:218      评论:0      收藏:0      [点我收藏+]

http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html

在官网下载对应的 Instant Client 包,解到 C:\ 。

运行以下批处理,即可。

reg add "HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment" /v ORACLE_HOME /t reg_sz /d "C:\instantclient_11_2" /f
reg add "HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment" /v TNS_ADMIN /t reg_sz /d "C:\instantclient_11_2" /f
reg add "HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment" /v NLS_LANG /t reg_sz /d "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" /f
REM tnsnames.ora
echo ORALOCAL = >C:\instantclient_11_2\tnsnames.ora
echo  (DESCRIPTION = >>C:\instantclient_11_2\tnsnames.ora
echo     (ADDRESS_LIST = >>C:\instantclient_11_2\tnsnames.ora
echo       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) >>C:\instantclient_11_2\tnsnames.ora
echo     ) >>C:\instantclient_11_2\tnsnames.ora
echo     (CONNECT_DATA = >>C:\instantclient_11_2\tnsnames.ora
echo       (SERVER = DEDICATED) >>C:\instantclient_11_2\tnsnames.ora
echo       (SERVICE_NAME = ORCL) >>C:\instantclient_11_2\tnsnames.ora
echo     ) >>C:\instantclient_11_2\tnsnames.ora
echo   ) >>C:\instantclient_11_2\tnsnames.ora

 

ORACLE Instant Client 配置

原文:http://www.cnblogs.com/Tty725/p/4412731.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!