2107261433@ODAC

Author Avatar
ClueeZhuo 7月 26, 2021

ORACLE数据访问组件ODAC

1、安装ODAC包

install.bat all D:\OracleClient ODAC

2、设置环境变量

ORACLE_HOME=D:\OracleClient
PATH=%ORACLE_HOME%;%ORACLE_HOME%\bin;

3、根据需要配置tnsnames.ora文件

%ORACLE_HOME%\network\admin目录下tnsnames.ora
ORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA)
)
)

4、卸载ODAC的方法

uninstall.bat all ODAC