Oracle instantclient免安装版部署步骤

1.下载免安装文件，下载路径不再详细介绍，本地使用64位文件“instantclient-basic-windows.x64-11.2.0.4.0.zip”

2.设置环境变量

NLS_LANG：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

ORACLE_HOME：F:\instantclient_11_2

TNS_ADMIN：F:\instantclient_11_2

Path：F:\instantclient_11_2

3.写入注册表文件，文件格式*.reg，文件内容：

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1]
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_BUNDLE_NAME"="Enterprise"
"ORACLE_GROUP_NAME"="Oracle – OraClient10g_home1″
"ORACLE_HOME"="D:\\develop\\software\\instantclient_11_2″
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraClient10g_home1″
"ORACLE_HOME_NAME"="OraClient10g_home1″

4.F:\instantclient_11_2路径内添加文件tnsnames.ora，文件内容：

ORATP45 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.32)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oratp45)
    )
  )

ORA33 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.112.143)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = t6)
    )
  )