By default, Oracle Net Listener takes port 1521. So if you use different port for that and omit it, you will get connection failure with no listener. I wonder if this is a firewall issue. Can you check if port 1535 is open to the SharePoint server?
RE: Oracle connection string for SI Web parts configuration