One common issue is permissions to the /Oracle/<version>/Bin folder on the Report server (where the Oracle Client is installed).

You need to grant read + execute permissions to this folder to...