Topic Options
#38617 - 08/23/10 03:53 PM Windows 7 64bit Oracle Client with PL/SQL Developer challenge
dmedia Offline
Member

Registered: 08/23/10
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

Top
#38618 - 08/23/10 04:09 PM Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge [Re: dmedia]
dmedia Offline
Member

Registered: 08/23/10
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

Top
#38622 - 08/24/10 05:55 AM Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge [Re: dmedia]
Marco Kalter Administrator Offline
Member

Registered: 08/30/99
Posts: 17170
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

Top
#38640 - 08/26/10 02:12 PM Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge [Re: Marco Kalter]
Allen Marshall Offline
Member

Registered: 07/01/10
Posts: 1
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.


Edited by Allen Marshall (08/26/10 02:32 PM)

Top
#38650 - 08/27/10 07:09 AM Re: Windows 7 64bit Oracle Client with PL/SQL Developer challenge [Re: Allen Marshall]
Marco Kalter Administrator Offline
Member

Registered: 08/30/99
Posts: 17170
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

Top


Moderator:  support