在XP上安装Oracle 10g的instantclient

 在XP上安装Oracle 10g的instantclient

从Oracle官方网站上下载

instantclient-basic-win32-10.2.0.3
instantclient-sqlplus-win32-10.2.0.3

1、解压缩到 d:/instantclient

2、在windows环境变量中添加

path = d:/instantclient
TNS_ADMIN = d:/instantclient

3、在d:/instantclient中建立一个tnsnames.ora文件

TVE  =  
         ( DESCRIPTION  =  
                ( ADDRESS  =  (PROTOCOL  =  TCP)(HOST  =   10.150.1.194 )(PORT  =   1521 ))
                ( CONNECT_DATA  =  
                         ( SERVICE  =  TVE )
                )
          )

TVE 为 SID

4、在注册表中加入

      

HKEY_LOCAL_MACHINESOFTWAREORACLE

NLS_LANG  =  SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4、在dos下运行d:/instantclient/sqlplus SCOTT/scott@TVE 进入sqlplus