To get a valid answer please provide complete information on the software in use (e.g. Oracle 11.2.0.3 and the version of the Client installed)
As suggested by jayasudha123, you need a 32-Bit Oracle client to connect to the Oracle database from ArcGIS Desktop.