How to know installed Oracle Client is 32 bit or 64 bit? Ask Question. Up vote 44 down vote favorite. OS: Windows 2008 Server R2. Oracle Client: 11.2. Connecting 32 bit Excel Running on 64 bit Windows 7 through VBA Macro to Oracle Database. I don't see my Oracle OLE Driver in SSIS. Shouldn't it be available? Installing tips and troubleshooting of Oracle 11gR2 64-bit client on Windows 7. I have 64-bit Oracle Database Server (11.2.0.3) installed on Windows 2008 R2, and naturally, it automatically installs the 64-bit client. I have to install an application onto this server that is 32-bit and requires the 32-bit Oracle client. (Don't Ask - I can't install the 64-bit version of this app, it won't work with the 64-bit client, and I can't install it on another server.) Now i have tried installing the 32-bit Client into a different physical folder and selected a different value for the Oracle Base and Software Location when installing and it installed just fine. And it put the BIN folder of the 32-bit Client installation at the head of the PATH statemtn. However, when i tried to run 'SQLplus system/system' with the 32-bit version it gives me the 'ORA-12560: TNS:protocol adapter error'. When I go into the folder with the 64-bit sqlplus.exe and ran it (directly and not through PATH), the 'system/system' credentials worked fine. I copied the TNSNames folder from the Oracle Server's NETWORK/admin folder to the Oracle Client's NETWORK/admin folder, and rebooted the server. Same results. This is the extent of my troubleshooting knowledge for Oracle. How can i get the 32-bit Client to run on the same server as the 64-bit Oracle Server? I know in linux/Unix, you simply put in the lib32 folder into the the 64-bit client folder and set a couple of environment variables, but i'm pretty sure it's not that simple in Windows. If there is a way to do this, please be descriptive in you answer as I will need step-by-step instructions. Thanks in advance. Here is an instruction how to install 32-bit and 64-bit Oracle Client on one machine. Follow the instruction, then it should work. Wernfried, I'm new to this forum, so if i downvoted your comment by accident, i apologize, however, i don't think i did. I do have a followup though. In my scenario, Oracle 64-bit server (and client) are already installed. Does this make a difference, because it looks like your method presumes neither client is installed. It also looks like you recommend installing the 32-bit client before the 64-bit client. And in my case, that can't be done. Just don't know if this will be an issue. Many thanks for responding. I'll give this a shot and see what happens. – Aug 10 '14 at 21:41 •.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |