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

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

Postby 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-configure-oracle-instant-client.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

Postby sharmavd1983 » Fri 31 Aug 2012 12:50

Sorry I have used

Connect as : Normal and
Home : Default (OraHome) or OraHome
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

Postby 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.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

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

Postby 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

Postby 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"
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

Postby 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
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

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

Postby 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?
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

Postby 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.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

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

Postby rasha » Mon 29 Feb 2016 09:33

I'm having the same problem



_____________
NOOR
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

Postby 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?
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle