Not very well documented on how to connect PowerPivot to an Oracle database. You need the Oracle client installed and the TNS names configured.
In PowerPivot the server name to connect to the Oracle instance is host:port/service_name. If port number is already in TNS names you should be good. Other little gotcha was be sure ORACLE_HOME is set and in your path.