设置环境变量

NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

TNS_ADMIN=F:\MyJob\Oracle11gInstantClient\ADMIN

Path=F:\MyJob\Oracle11gInstantClient;

其中ADMIN文件夹需手工创建，用来存放tnsnames.ora，或者不创建将tnsnames.ora放在客户端根目录下，效果一样

tnsnames.ora内容可参考：

ORCL= 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) 
      ) 
      (CONNECT_DATA = 
        (SERVICE_NAME = ORCL) 
      ) 
    )