Oracle 11g 64-bit client support

[Felix]

I have a Windows 7 (64-bit) with Oracle 11g R1 64-bit client. Do you support this? If not, when do you plan to support 64-bit clients?

 

[Felix]

I installed Oracle Instant Client 11g (32-bit) in C:\app\oracle\instantclient.11.1 and set under Preferences/Connection the Oracle Home and OCI library both to C:\app\oracle\instantclient.11.1

I get the following errors when connecting:
Initialization error
Could not load "C:\app\oracle\instantclient.11.1"

OCIDLL forced to "C:\app\oracle\instantclient.11.1"
LoadLibrary(C:\app\oracle\instantclient.11.1) returned 0

I still have the Oracle 11g (64-bit) installed in C:\app\oracle\product\11.1.0\client_1 directory.

Any suggestions?

 

[Marco Kalter]

You need to set the OCI Library to:

C:\app\oracle\instantclient.11.1\oci.dll

 

[JimmyM]

I have the following environment.
Windows 7 (64-bit)
PL/SQL Dev version 7.1.5.1398 (installed at C:\PLSQL Developer\)
Oracle 11g 64-bit installed
Oracle 11 instant client (32-bit)

I can tnsping my local db... c:\tnsping orcl1

PL/SQL Dev settings are...
Oracle Home: Tried both "OraDb11g_home1" and "C:\app\minihanej\product\11.1.0\db_1"
OCI Library: c:\app\minihanej\instantclient_11_1\oci.dll

However, My list of servers in my tnsnames.ora file do not show up when attemping to login. If I just type in the user/password/sid I get a TNS timeout.

What am I doing wrong?
Is version 8 setup tp properly deal with a 64 bit install?

 

[Ligon]

Hi Marco,

I have the same situation as of Felix, and have PLSQL Developer 8 installed.

I have tried setting OCI Library to C:\....\instantclient.11.1\oci.dll, but the error still persist.

I can connect using TOAD or SQL Developer though!

Hope you could help

Regards
Ligon

 

[Marco Kalter]

However, My list of servers in my tnsnames.ora file do not show up when attemping to login. If I just type in the user/password/sid I get a TNS timeout.

For the instant client you will need to set the TNS_ADMIN environment variable to the directory where your tnsnames.ora file is located.

 

[Marco Kalter]

Hi Marco,

I have the same situation as of Felix, and have PLSQL Developer 8 installed.

I have tried setting OCI Library to C:\....\instantclient.11.1\oci.dll, but the error still persist.

I can connect using TOAD or SQL Developer though!

Hope you could help

Regards
Ligon

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Ligon]

Hi Marco,

I have now sent you a message with the details asked.

Plz let me know if you need any further info

Kind Regards
Ligon

 

[Ligon]

Hi All,

Lucky me - just got the issue resolved.

copied TNSNAMES.ORA into oracle client folder and works like a charm.
http://newsgroups.derkeiler.com/Archive/Comp/comp.databases.oracle.tools/2007-11/msg00077.html

Thank you All

Cheers
Ligon

 

[Marco Kalter]

Setting the TNS_ADMIN environment variable to the directory of the tnsnames.ora file should also have worked. This way you can maintain just one copy of the tnsnames.ora file.

 

[Truston]

I had the same problem. None of the suggestions above worked.
Then I installed a 32 Bit Oracle 10 next to my 64 Bit Oracle 11 installation. After copying the TNSNAMES.ora file to the Oracle 10 home, it all worked.

My system:
Windows 7 Ultimate
PL/SQL Developer 7.1.5.1398
Oracle 11 R1 64 Bits client + database
Oracle 10.2 32 Bits client

Greetings,
Michael