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;

 

 

posted @   咸鱼翻身  阅读(6059)  评论(1编辑  收藏  举报
编辑推荐:
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
阅读排行:
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· 单线程的Redis速度为什么快?
· 展开说说关于C#中ORM框架的用法!
· Pantheons:用 TypeScript 打造主流大模型对话的一站式集成库
点击右上角即可分享
微信分享提示