So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the 32bit client seem to reference the 64bit client and vice versa.
I've searched for a long time on various Oracle forums and Oracle specific resources and tried various techniques for getting the ORACLE_HOME and such set so the two clients will play nicely side by side, but really nothing has worked.
Is there a legitimate best practice way to do this? Specifically I'm wondering about whether each client needs to be in its own BASE directory (say C:\oracle and C:\oracle32) or if they should be within the same base direct but have their own client folders.