If you're only running 64-bit SQL Server (or other 64-bit software) on the servers all you need is the 64-bit Oracle Client.
If you're using Business Intelligence Development Studio (BIDS) or other 32-bit software on the server you also need the 32-bit Oracle Client.