topic Re: New User - Oracle Connection Failure in Installing and Upgrading

New User - Oracle Connection Failure

Anonymous — Sat, 16 Nov 2024 14:06:59 GMT

Hi -
I am new to TOS and am hoping someone can point out what I have missed in the documentation and forums.
I have been unable to create a database connection in TOS v3.0.2 to any of our Oracle databases (both v8.1.7 and v10.0.2). I can connect and explore schemas from TOP and standard Oracle tools but TOS consistently fails with "Io exception: Socket is not connected". I have reinstalled TOS but the problem persists.
I have used both the FQDN and IP address for the host along with double quotes around the text values.
The typical entry in the error log is:
!ENTRY org.talend.libraries 4 0 2008-12-23 09:24:03.359
!MESSAGE 2008-12-23 09:24:03,359 ERROR org.talend.commons.exception.ExceptionHandler - Io exception: Socket is not connected
!STACK 0
java.sql.SQLException: Io exception: Socket is not connected
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:344)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:148)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(Unknown Source)
I would appreciate any help that can be offered.
Thanks!

Re: New User - Oracle Connection Failure

Anonymous — Mon, 29 Dec 2008 09:56:12 GMT

Hi,
You have to remove the double quotes character in the Wizard.
For Login, Password, Server, Database, etc...
Double quotes are importants in components properties; but it occurs troubles if you use with our Metadata Database wizard.
Best regards;

Re: New User - Oracle Connection Failure

Anonymous — Mon, 29 Dec 2008 23:58:40 GMT

Hi Cantoine,
I tried originally to define the database connection without using the double quotes. When doing so I immediately get a slightly different error:
"Io exception: The Network Adapter could not estblish the connection"
I remain baffled by this as I can make a connection to this same database using the same properties using the Talend Open Profiler product.
I would appreciate any suggestions as to how I should proceed.
Thanks!

Re: New User - Oracle Connection Failure

Anonymous — Tue, 30 Dec 2008 11:11:51 GMT

Hi,
What is your Oracle version ?
In the Database wizard, did you choose the correct version for your oracle database ?
Best regards;

Re: New User - Oracle Connection Failure

Anonymous — Tue, 30 Dec 2008 15:59:49 GMT

Hi,
I have tried to connect to both an Oracle 8.1.7 instance using the Oracle 8 driver in the wizard, and a version 10.2 instance using the Oracle 10 driver in the wizard. The error is the same.
Thank you for your continued interest.

Re: New User - Oracle Connection Failure

Anonymous — Tue, 30 Dec 2008 16:14:42 GMT

Hi,
Have you tried with 'SID' and 'Service name' connection method?
Do you have no trouble to connect to your Oracle with your Oracle client?
Are you sure that your Oracle machine allow remote connection ? multiple simultaneous connections ?
Best regards.

Re: New User - Oracle Connection Failure

Anonymous — Wed, 31 Dec 2008 00:51:56 GMT

Hi,
Yes, I have tried both methods. I can connect to the databases using TOAD and the Talend Open Profiler. The Oracle servers in questions already allow multiple, remote connections.
Thanks!

Re: New User - Oracle Connection Failure

Anonymous — Sat, 03 Jan 2009 00:22:00 GMT

I am having the same exact problem as kpjim. I can connect with sql developer, sql plus etc but not with TOS. I have tried different things and get the same messages.
Is there a solution for this issue?
Thanks,
SY

Re: New User - Oracle Connection Failure

Anonymous — Tue, 06 Jan 2009 14:56:53 GMT

Can someone with knowledge of both Talend Open Profiler (TOP) and Talend Open Studio (TOS) explain the difference between their Oracle access methods? The fact that I can connect to multiple Oracle databases with TOP but not TOS suggests that the two products use different libraries/methods and that the solution to this problem is in those differences.
Thanks!

Re: New User - Oracle Connection Failure

Anonymous — Tue, 06 Jan 2009 17:36:45 GMT

When I try a straight oracle connection with either SID or service name nothing works. I tried removing the domain name and I got a socket error message instead of the
"Io exception: The Network Adapter could not estblish the connection". I too can connect with TOP and sqldeveloper etc but not with TOS. I am hoping for a solution soon...

Re: New User - Oracle Connection Failure

_AnonymousUser — Wed, 21 Jan 2009 21:28:53 GMT

Just installed TOS and am getting this same message. Can we can an update on this?

Re: New User - Oracle Connection Failure

Anonymous — Sun, 01 Feb 2009 03:09:04 GMT

My results are the same as posted above. Have tried:
10g SID
10g ServiceName
General jdbc-with ojdbc14.jar selected and oracle.jdbc.driver.OracleDriver.
Also as others, SQL Plus connects as does Eclipse/j2ee.
Please let me know when a fix is in. Thanks.

Re: New User - Oracle Connection Failure

Anonymous — Mon, 02 Feb 2009 17:59:39 GMT

This problem is corrected in TOS v 3.0.3 and was apparently related "to a too long ping response in the metadata manager/component."

Re: New User - Oracle Connection Failure

_AnonymousUser — Thu, 05 Feb 2009 21:55:10 GMT

This problem is corrected in TOS v 3.0.3 and was apparently related "to a too long ping response in the metadata manager/component."

I download today version 3.0.3 and I am having the same problem mention above

Re: New User - Oracle Connection Failure

Anonymous — Tue, 10 Feb 2009 04:23:24 GMT

In case of your connection in the repository comes from an imported project, could you try to recreate the Connection in the repository?

Re: New User - Oracle Connection Failure

Anonymous — Tue, 10 Feb 2009 12:12:53 GMT

I have the same problem with Oracle 11G R2 and TOS 3.0.2.
I am working connected through a VPN to my office.
Philippe

Re: New User - Oracle Connection Failure

Anonymous — Wed, 11 Feb 2009 05:12:50 GMT

Hi...
If I am not wrong. TOS 3.0.2 is having some problem in connective database. I was unable to connect to datbase (Oracle 10g). I downloaded TOS 3.0.3. Its working.
Hope its helpful.
-
sangi

Re: New User - Oracle Connection Failure

Anonymous — Tue, 29 Sep 2009 08:06:37 GMT

Hello,
I used TOS 3.0.4 and TOS 3.0.5 but I have similar problem.
I can connect to my database (Oracle 10 with service name) with TOAD or other software, but with TOS often I get this message:
Exception in component tOracleConnection_3
java.sql.SQLException: Eccezione IO: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
I say OFTEN because sometimes the connection works! But I really don't know why. Is there any way to setup the connection timeout? I tried from Preferences->Talend->Sql Builder but it seems that it doesn't work.

Re: New User - Oracle Connection Failure

Anonymous — Tue, 29 Sep 2009 08:33:33 GMT

Hello

I used TOS 3.0.4 and TOS 3.0.5 but I have similar problem.

3.0 version is a little old. please download load the latest and stable version TOS3.1.4.
Did you try to connect oracle with sid?
Best regards

shong

Re: New User - Oracle Connection Failure

Anonymous — Tue, 29 Sep 2009 08:46:17 GMT

Thanks for your quick reaction.
I tried to download 3.1.4, but with branch 3.1.x (we tried also with 3.1.1) we have a problem with component tContextLoad, that is unfortunately used in all our jobs.
For this db, unfortunately we must connect with service name.
There are two instances of this db (in 2 different servers) because it is a load balanced one. But with a generic oracle client we can connect with both instances without problems.
The strange thing is that sometimes it works. I think it could be a connection timeout problem. Where can I modifiy (if possible) the connection timeout?
Regards.