[Anonymous]

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?

[Anonymous]

Just checked our network folks. No internal firewall that would prevent a connection. Our db server is listening on port 1535. When I use that port in the connection string, I get a connection failure, object doesn't exist. When I omit the port or use a different port, I get the no listener error.
Thanks for your help. Instead of spending so much time on this, I'll try to figure out another solution that doesn't require the web parts.

Thanks again.

[Anonymous]

A sample connection string is listed below:
User ID=xxx;Password=xxx;Host=192.168.0.243;SID=orcl;Pooling=false;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;Direct=true;

Note if you are trying to connect to a clustered oracle instances, the connection string is different and you will need set Direct flag to false to use RAC mode to work with clustered environment. Notice that no SID is specified in the connection string.

User ID=xxx;Password=XXX;Host=company_server; Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;Direct=false;
For more connection string settings, you may refer to http://www.connectionstrings.com/oracle.

[Anonymous]

I appreciate the connection string answers. Unfortunately, everything I try is the same – connection failed. I'll work with our DBA on this end to figure it out.

Thanks again

[Anonymous]

Maybe this will help. This is the connection string we use for JSP.
jdbc:oracle:thin:@oracle1dp.gavilon.com:1535:oracle11p
username is: roUser
password: xxxxx
Using this, I get the connection string:
Host: oracle1dp.gavilon.com:1535; SID=oracle11p; Direct=true; User ID=roUser; Password=xxxxx;
Get connection failed. Object doesn't exist. If I leave off the port number, I get connection failed, no listener.

[Anonymous]

It may help to take a step back and connect the qSIListView to a sample Oracle Database first, get it working and then tackle the Oracle instance that you are after. I created two short videos that show how to connect to Oracle Database 10g Express Release 2:
Part 1:
http://screencast.com/t/NTU4ZGEy
Part 2:
http://screencast.com/t/YzY3MTk1Zj
The example uses the same connection string that mentioned. As a test, download and install Oracle Express and follow the videos to get it connected. Once you verified that the qSIListView works with Oracle Express, download and install the Oracle Express Client:
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html
You should be able to connect to your Oracle system using the Oracle Express Client tools like TNSPING:
http://www.geekinterview.com/question_details/29370
If you can connect with the Oracle Express Client tool by adding your SID to the tnsnames.ora file, the client connectivity test will eliminate the firewall issue and your issue will be isolated to a problem with the connection string.
If this approach does not work, let me know. I've worked with Java and windows connections strings to Oracle in the past and we can setup a live meeting to resolve the issue. I think you will find resolving this issue worth the time and effort. Once the connectivity issue is resolved (it could be as simple as an extract comma in the connection string) the Quest SI web parts will impress you with their capabilities.
Curtis Kelly
PM, Quest WebParts for SharePoint

[Anonymous]

I’m struggling to find the right connection string to connect the web parts to an Oracle database. I did find the following in the help file: Host=xxx;SID=xxx;Direct=true; My DBA has given me what he thinks is the HOST and the SID. We’ve tried different variations of it. Still get the connection failed dialog because the target host or object does not exist. Anyone have any experience connecting to Oracle databases with the SI web parts?

[Anonymous]

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

[Author]

Posts