...
Do I want Oracle 32-bit or 64-bit?
If you will be using Alteryx, select Oracle 12.1.0.2 64-bit.
If you are unsure, select Oracle 12.1.0.2 32-bit.
The 64-bit client is needed for some applications or connectivity protocols but basic connectivity with common SQL tools (i.e. Toad, SQL Developer) have issues with 64-bit clients, so we recommend the 32-bit client.
NOTE: Newer Oracle Clients have not yet been approved for all environments in PittIT as of the last time this document was updated.
...