Print Thread
Windows 7 64bit Oracle Client with PL/SQL Developer challenge
#38617 08/23/10 07:53 PM
Joined: Aug 2010
Posts: 2
D
dmedia Offline OP
Member
OP Offline
Member
D
Joined: Aug 2010
Posts: 2
We have an windows 7 64 bit issue when we try to install PL/SQL Developer Version 8.0.3.1510.

The 64 bit oracle 11.2 client allows us to connect to our database instances, through sqlplus.

However, with the PL/SQL Developer install our

Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge
dmedia #38618 08/23/10 08:09 PM
Joined: Aug 2010
Posts: 2
D
dmedia Offline OP
Member
OP Offline
Member
D
Joined: Aug 2010
Posts: 2

I forgot to add this, this is the "Support Info"

Support info:
-------------------
PL/SQL Developer
Version 8.0.3.1510
01.65260 - 20 user license
Windows 7 (64-bit) 6.1 Build 7600

Physical memory : 4,118,356 kB (2,953,084 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,969,956 available)

Parameters
C:\Program Files\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Users\taylord\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\taylord\AppData\Roaming\PLSQL Developer\Preferences\taylord\default.ini

Plug-Ins

Aliases

Homes

DLLs
c:\oracle\instantclient_11_2\oci.dll

TNS File

Using
Home:
DLL:
OCI: not initialized

Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge
dmedia #38622 08/24/10 09:55 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
You will need to install a 32 Bit Oracle Client. PL/SQL Developer is a 32 Bit application, so it cannot interface with a 64 Bit Oracle Client.

The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary. The 32 Bit client can coexist with a 64 Bit Oracle installation when installed in separate Oracle Home directories.


Marco Kalter
Allround Automations
Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge
Marco Kalter #38640 08/26/10 06:12 PM
Joined: Jul 2010
Posts: 16
A
Member
Offline
Member
A
Joined: Jul 2010
Posts: 16
OK, so where does one obtain this for Oracle XE ? Just trying to save flailing... Also, umm, the error message when the login fails is not very illuminating.

Thanks.

Update: So I installed the XEClient that I downloaded along with the XE server, and it can't do anything under Windows 7. It fails. PL/SQL Developer doesn't even see the TNSNAMES entries it used to show before I installed the XE Client.

Is there something magic I need to know?

Thanks again.

Last edited by Allen Marshall; 08/26/10 06:32 PM.
Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge
Allen Marshall #38650 08/27/10 11:09 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
You should probably download the latest 32 bit 11g client from the Oracle web site to ensure that it is compatible with Windows 7. It can be downloaded here (2nd download is just the client).


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.052s Queries: 15 (0.009s) Memory: 2.5155 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 18:30:24 UTC
Valid HTML 5 and Valid CSS