So what did you try?

I don't have an Oracle instance to connect to, but when you run the wizard to add a Data Source, you can choose "Oracle Database" from the dropdown....

that was pretty tricky... the hardest part was waiting for SSRS to open.