I noticed that your connection string hast a colon after the Host value:
Host: oracle1dp.gavilon.com:1535; SID=oracle11p; Direct=true; User ID=roUser; Password=xxxxx;
You should try:
Host=oracle1dp.gavilon.com; SID=oracle11p; Direct=true; User ID=roUser; Password=xxxxx;
Also, try the connection string that provided as well:
User ID=xx;Password=xxx;Host=oracle1dp.gavilon.com;SID=oracle11p;Pooling=false;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;Direct=true;
Another approach is to install a sample Oracle database and get it working with qSIListView. I created two short videos that show how to do this:
Part 1:
http://screencast.com/t/NTU4ZGEy
Part 2:
http://screencast.com/t/YzY3MTk1Zj
If you download and install the Oracle Express Edition database, create and test a new System using the QWP SI configuraton and then configure a qSIListView to retrieve sample data, that will isolate the issue. You can then test Oracle client connectivity to your Oracle instance via the TNSPING utility:
http://www.geekinterview.com/question_details/29370
If you still can not connect, we can setup a live meeting to resolve the issue. I think you will find the time and effort will be worth it once this issue is resolved and the SI web parts are able to show off their capabilities.
Curtis Kelly
PM, Quest Web Parts for SharePoint