Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
sharmavd1983
Posts: 6
Joined: Fri 31 Aug 2012 03:59

Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by sharmavd1983 » Fri 31 Aug 2012 12:43

Hi

I am using dbForge for Oracle version 3.1.219 with windows 64 bit operating system and I have configured oracle instant client of 64 bit as mentioned at http://blogs.devart.com/dbforge/how-to- ... lient.html

But I am getting this error message while creating new connection when I use Conncet as : Default (OraHome)
Unable to load C:\oracle\instantclient_11_2\oci.dll. Please check that you use 64x version of Oracle client with 64x application.

And when I select Connect as : OraHome then I am getting error message
Can not find tnsnames.ora file

Could anyone please help me to resolve this issue?

Many thanks in advance.....

sharmavd1983
Posts: 6
Joined: Fri 31 Aug 2012 03:59

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by sharmavd1983 » Fri 31 Aug 2012 12:50

Sorry I have used

Connect as : Normal and
Home : Default (OraHome) or OraHome

alexa

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by alexa » Fri 31 Aug 2012 13:23

Please make sure you have installed a 64-bit Oracle client but not a 32-bit one in case you are running a 64-bit operating system.

sharmavd1983
Posts: 6
Joined: Fri 31 Aug 2012 03:59

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by sharmavd1983 » Fri 31 Aug 2012 14:44

Yes you was right.

Now I have installed Oracle client of 64 bit, but now I am getting error
"ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

Oracle is installed on some remote machine.

I had edit registry as below.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"ORACLE_HOME"="C:\\oracle\\instantclient_11_2"
@=""
"ORACLE_HOME_NAME"="OraHome"
"ORACLE_GROUP_NAME"="Oracle - OraHome"
"NLS_LANG"="NA"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
"HOME_COUNTER"="1"
"DEFAULT_HOME"="OraHome"
"LAST_HOME"="0"
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
"NAME"="OraHome"
"PATH"="C:\\oracle\\instantclient_11_2"
"NLS_LANG"="NA"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"ORACLE_HOME"="C:\\oracle\\instantclient_11_2"
"ORACLE_SID"="srvc1"
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome"
"ORACLE_HOME_NAME"="OraHome"
"NLS_LANG"="NA"
"ORACLE_HOME_KEY"="Software\\ORACLE\\HOME0"

sharmavd1983
Posts: 6
Joined: Fri 31 Aug 2012 03:59

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by sharmavd1983 » Sat 01 Sep 2012 10:35

I have installed Oracle client of 64 bit, but now I am getting error
"ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

alexa

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by alexa » Mon 03 Sep 2012 08:40

There is either not correctly specified server connection details in the tnsnames.ora file or this file is missing. In case it's missing, you would need to create it in the following path C:\\oracle\\instantclient_11_2

PeterWK
Posts: 15
Joined: Tue 08 Jan 2013 19:21

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by PeterWK » Thu 24 Jan 2013 16:49

Hi Devart,

I'm having the same problem: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA!

Will I REALY have to change the tnsnames.ora file in ALL the computers that my company and my clients use?

alexa

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by alexa » Fri 25 Jan 2013 11:50

Please make sure the server connection details in the tnsnames.ora file are specified correctly or create this file if needed.

rasha
Posts: 1
Joined: Mon 29 Feb 2016 07:41

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by rasha » Mon 29 Feb 2016 09:33

I'm having the same problem



_____________
NOOR

alexa

Re: Unable to load oci.dll. Please check that you use 64x version of Oracle client with 64x

Post by alexa » Mon 29 Feb 2016 12:41

Could you please provide us the following information:

1. Version of your operating system. Is it of x32 or x64?
2. Version of your Oracle client. Is it of x32 or x64?
3. Version of dbForge. Is it of x32 or x64?

Post Reply