user3536449 wrote:There is not listener in the client directories, because the listener is a server-side only issue. The listener sits on the server to listen for connection requests from client processes. Having a listener on a client makes as much sense as a water pump on a '65 Volkswagen
We have a requirement for our 32 bit application to connect to a 64 bit Oracle database on Windows 7 as a standalone environement.
The workstation has:
32 bit oracle 188.8.131.52 client
64 bit oracle 184.108.40.206 database
Windows 7 OS
The 32 bit oracle client is installed on a different Oracle home from the 64 bit database.
The oracle_home is set to the 32 bit client home directory. the Path has the 32 bit client home\bin directory prior to the 64 bit database home\bin directory. The sqlnet.ora file and tnsnames.ora file (points to the 64 bit database) are both in the 32 bit client's network\admin directory.
I could connect to the database via SQLPLUS.
When the workstation rebooted, the listener was not able to start as it pointed to the listener executable in the 64 bit database home\bin directory. Since the 64 bit path environment variable is set after the 32 bit client path, it did not see the executable in the 32 bit client bin diractory. I copied the listener.ora file from the 64 bit database to the 32 bit directory, but it did not work.
Any idea what I can do to fix this issue? Thanks.