I found out the reason is SSRS 2017 no longer works with Oracle 11 client. SSRS 2014 still works with it.

So I installed Oracle 12c drivers, then the SSRS oracle data source type works correctly.