RE: Anyone using a 64-bit APP with a 32-bit Oracle Client?
Date: Fri, 2 Sep 2011 06:51:36 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D6A3237971D_at_SPOBMEXC14.adprod.directory>
It makes sense that a 32-bit app needs a 32-bit client. The 32-bit client DLLs are compiled with 32-bit libraries.
It does *not* make sense that a 64-bit app needs a 64-bit client however because it is my understanding that a 64-bit library contains the same information as the 32-bit library but in different byte positions due to being compiled with 64-bit libraries. In my mind, a 64-bit app should be able to find the hooks in a 32-bit dll just as easily as in a 64-bit dll.
Yes, I'm fairly certain that Oracle SQL Developer 64-bit is 64-bit. It requires a 64-bit JRE and if it was a 32-bit app the 64-bit JRE wouldn't work I think.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor_at_ingrambarge.com
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
-----Original Message-----
From: Dunbar, Norman (Capgemini) [mailto:norman.dunbar.capgemini_at_environment-agency.gov.uk]
Sent: Friday, September 02, 2011 3:00 AM
To: Taylor, Chris David; oracle-l_at_freelists.org
Subject: RE: Anyone using a 64-bit APP with a 32-bit Oracle Client?
Hi Chris,
>> Subject: Anyone using a 64-bit APP with a 32-bit Oracle Client?
Nope, it doesn't work. 64 bit OS can run 32 bit apps as well as 64 bit - if they have the required support "packages" installed. However, a 64 bit app needs a 64 bit Oracle Client in a manner similar to how a 32 bit app, running on 64 bit OS, needs the 32 bit Oracle Client.
>> Oracle note 1151394.1 says .....
>> Is that always true though?
Yes. (For certain values of "always" perhaps!)
>> For example, the SQL Developer
>> 64-bit version from Oracle runs with my 32-bit client libraries
>> though it may be doing something different since it uses Java.
Are you sure that SQL Developer is actually a 64 bit app? It may be that it claims 64 bitness but is really "64 bit compatible in such a way that it will actually run on 64 bit OS" - in other words, it's really 32 bit!
I can't say for sure, I'm most definitely a Toad man myself, and I know that the Toad support lists get frequent postings about this very matter - "I've installed Toad on 64 bit Windows and it says I don't have an Oracle Client installed, but I have 64 bit Oracle 11.2 Client". Toad is created by Delphi, and until Delphi XE2 hits the streets, Delphi creates 32 bit applications which require 32 bit supporting infrastructure, even if running on a 64 bit OS.
>> I was trying to find a 64-bit app that had database connectivity to
>> test some scenarios but I can't easily locate one.
I'm not aware of any - until the development tools for 64 bit apps are a lot more popular (in use) then we will be stuck with 32 bit stuff running on 64 bit OSs.
HTH
Cheers,
Norm.
Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Team (EA)
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 02 2011 - 06:51:36 CDT