Your issue is likely due to an incorrect Oracle client installation or a missing OLE DB provider. I work with Devart SSIS for Oracle and it works well. So...

I had the same task and found Devart SSIS for Oracle really helpful https://www.devart.com/ssis/oracle/download.html. It has built-in components, so no need for ODBC/OLE DB.

I worked on a project pulling QuickBooks Desktop data into SQL Server for reporting. Tried finding free options, but QuickBooks doesn’t have a built-in SSIS connection. Ended up using Devart...