Home » RDBMS Server » Networking and Gateways » Connecting 32 bit client on 64 bit server (Oracle 11gR2, Windows 7 (64 bit) Home Premium, 32 bit Oracle client)
Connecting 32 bit client on 64 bit server [message #494538] Tue, 15 February 2011 11:12 Go to next message
Messages: 1
Registered: February 2011
Location: Austin, TX
Junior Member

I am having difficulty in making the 32 bit Oracle client connection to an existing 64 bit DB. The 64 bit SQL*Plus will connect just fine, but when trying to configure the 32 bit client I can never get a successful TEST of the connection. It always returns "No TNS Listener". I have tried several things, but may be way off base. To name a couple ...

1) Stopped the 64 bit listener so my 32 bit listener can use Port 1521 ... no success

2) Tried naming the 32 bit listener to LISTENER32 to not conflict with the original LISTENER name ... no success

If there is a documented way to make this work, I would surely like to be pointed to the "how to" of this item.

I need this as a commercial application I have that connects to the DB requires the 32 bit client.

Thanks in advance.
Re: Connecting 32 bit client on 64 bit server [message #494540 is a reply to message #494538] Tue, 15 February 2011 11:25 Go to previous message
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
listener does not know or about "flavor" of client; whether it be 32-bit, 64-bit, Java thin, Java thick, PERL, VB, etc.

from DB server issue following OS commands

lsnrctl status
lsnrctl service

COPY commands above & results, then PASTE all back here
Previous Topic: Can't connect to Sybase (ASA) via Database Gateway for Sybase
Next Topic: Cant open tnsnames.ora file .
Goto Forum:

Current Time: Thu Oct 29 06:36:43 CDT 2020