If Oracle client x86 is installed, the system. invalidoperationexception error is returned when you access the Oracle database using. Net: badimageformatexception is thrown when you attempt to load the Oracle client database. This problem occurs when the 32-bit Oracle client component is installed in 64-Bit mode. -> System. badimageformatexception: An error occurred while trying to load the file in an incorrect format. Program . (The exception comes from hresult: 0x8007000b.) solution: After installing Oracle client x86, install Oracle client x64.net and then access it normally... However, PLSQL does not support Oracle client x64. If you modify the Registry to wow6432node, PLSQL reports the following error initialization.
Count not load "C: \ oracle \ product \ 10.2.0 \ client_2 \ bin \ OCI. dll: oraclehomekey: Software \ oracle \ key_1_lient10g_home2
Oraclehomedir: C: \ oracle \ product \ 10.2.0 \ client_2found: OCI. dll
Using: C: \ oracle \ product \ 10.2.0 \ client_2 \ bin \ OCI. dll
Loadlibrary (C: \ oracle \ product \ 10.2.0 \ client_2 \ bin \ OCI. DLL) return 0 ------------ found that if only x64 oracle is installed, the following error information will also be reported. the setting in config needs to be changed <runtime>
<Assemblybinding xmlns = "urn: Schemas-Microsoft-com: ASM. V1">
<Dependentassembly>
<Assemblyidentity name = "oracle. dataaccess" publickeytoken = "89b483f429c47342"/>
<Bindingredirect oldversion = "2.0.0.0-10.9.9.9" newversion = "2.102.3.2"/>
</Dependentassembly>
</Assemblybinding>
</Runtime>
Change to <runtime>
<Assemblybinding xmlns = "urn: Schemas-Microsoft-com: ASM. V1">
<Dependentassembly>
<Assemblyidentity name = "oracle. dataaccess" publickeytoken = "89b483f429c47342" processorarchitecture = "amd64"/>
<Bindingredirect oldversion = "2.0.0.0-10.9.9.9" newversion = "2.102.3.2"/>
</Dependentassembly>
</Assemblybinding>
</Runtime>