1、
2、设置环境变量
1)
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK(注意中间有空格,这个如果不设,toad查询中文会是乱码)
需要英文环境把上面的改为:AMERICAN_AMERICA.AL32UTF8
2)TNS_ADMIN=D:\instantclient_11_1
3)Path=D:\instantclient_11_1 追加,不要覆盖,否则jdk用不了
3、tnsnames.ora文件
oracle_XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
oracle_XE_60 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.60)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
4、测试