Oracle64位问题(ODAC112021Xcopy_x64)
Cd F:\Software\DBSoft\ODAC112021Xcopy_x64
F:
F:\Software\DBSoft\ODAC112021Xcopy_x64\install.bat all D:\app\Administrator\product\11.2.0\client_1 OraClient11g_home1
--------------------------------------------------------------------------------------------------------------------
4. Add the install directory and install directory's bin subdirectory to the system PATH environment variable before any other Oracle directories. Otherwise, the products that are installed may not work properly as it will not be able to load the necessary DLLs. for example, if c:\oracle was provided as the install directory, add c:\oracle and c:\oracle\bin to the system PATH.
--- 环境变量
Path = D:\app\Administrator\product\11.2.0\client_1;D:\app\Administrator\product\11.2.0\client_1\bin;D:\app\Administrator\product\11.2.0\dbhome_1\bin;
5. Note that install.bat sets the value of the NLS_LANG registry key at HKLM\Sofware\Oracle\KEY_<Oracle Home Name> to AMERICAN_AMERICA.WE8MSWIN1252 by default. Please modify install.bat or change this value in the registry after the install if necessary.
---注册表
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
6. If OraMTS is installed, the OracleMTSRecoveryService is created with the LocalSystem account as the logon account. The credentials can be changed using the "services" administration tool. Please read the OraMTS readme.txt for details. Note that after the install or the configuration, the service will not be started, since it requires the install directory and its bin directory to be included in the system PATH.
7. Application using components from ODAC can use EZ CONNECT to connect to Oracle without depending on tnsnames.ora. Otherwise, configure or copy over tnsnames.ora from another machine and set TNS_ADMIN or ORACLE_HOME environment variable appropriately.
---环境变量
TNS_ADMIN = D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1
--------------------------------------------------------------------------------------------------------------------
如果安装 PL/SQL Developer,下载“instantclient-basic-nt-11.2.0.3”
在perference->Connection里面设置OCI Library和Oracle_Home,例如本机设置为:
Oracle Home :X\instantclient_11_2
OCI Library :X\instantclient_11_2\oci.dll
--------------------------------------------------------------------------------------------------------------------
copy D:\App\Administrator\product\11.2.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll C:\Windows\assembly\GAC_32\Oracle.DataAccess\4.112.2.0__89b483f429c47342\
{"Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format."}
Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.FileLoadException: Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. Access is denied.
-------------------------------------------------------------------------------------------------------------------
如果安装Oracle后,配置了ODAC,又安装了一个Oracle的实例,需要重新配置系统环境
把ODAC执行放在前面,否则会提示Oracle版本冲突
如Path=D:\app\Administrator\product\11.2.0\client_1;D:\app\Administrator\product\11.2.0\client_1\bin;
博客版权: 本文以学习、研究和分享为主,欢迎转载和各类爬虫,但必须在文章页面明显位置给出原文链接。 如果文中有不妥或者错误的地方还望高手的您指出,以免误人子弟。如果您有更好的建议,不如留言一起讨论,共同进步! 再次感谢您耐心的读完本篇文章。