topic Re: [resolved] oracle 11g connection in Talend Studio

[resolved] oracle 11g connection

Anonymous — Thu, 17 Oct 2013 12:47:46 GMT

any one can tell me how to create connection for oracle data base . i am connecting using toracle input, i provide every thing but it asking for additional jdbc perameters. can any one tell me what is this additional jdbc perameters.

Re: [resolved] oracle 11g connection

Anonymous — Fri, 18 Oct 2013 02:51:24 GMT

Hi,
What oracle DB type are you connect to? OCI, RAC, SID or service name? Could you please upload your Database Connection screenshot into forum?(hidden secret message )
Best regards
Sabrina

Re: [resolved] oracle 11g connection

Anonymous — Fri, 18 Oct 2013 05:01:02 GMT

i am using oracle with SID . could u please tell me what i need to provide for SID and Additional parameters.
here i am attaching my screen shot for db connection.

Re: [resolved] oracle 11g connection

Anonymous — Fri, 18 Oct 2013 09:01:25 GMT

Hi.
Generally speaking, SID is instance name in order to identify DB.
You can get it from DB:
In Windows, select instance_name from V$instance (usually, sid is as same as your DB name).
The DB connection should be OK without Additional parameters.
You'd better make a research about DB parameter on website to get a professional answer.
Best regards
Sabrina

Re: [resolved] oracle 11g connection

Anonymous — Fri, 18 Oct 2013 10:55:32 GMT

thankyou sabrina . its working

Re: [resolved] oracle 11g connection

Anonymous — Tue, 22 Oct 2013 08:28:13 GMT

Hi,
Thanks for your response, feel free post your issue and difficulty on forum.
Best regards
Sabrina

Re: [resolved] oracle 11g connection

_AnonymousUser — Thu, 17 Apr 2014 12:18:15 GMT

Hi,
I am trying to connect Oracle 11g database from Talend 3.2 version using tOracleConnection Task.
But when i am trying to fetch table through toracleinput task by using the above connection i am getting connection failure.
Please help asap.
Does this version supports to conenct Oracle11g.

Re: [resolved] oracle 11g connection

Anonymous — Fri, 18 Apr 2014 08:49:20 GMT

Hi,

Talend 3.2 version

Talend 3.2 version or Talend 5.3.2? If former, it is a quite old version and you'd better take a try in latest one(Talend 5.4.1) to see if it repro?. Is there any connection error info on console?
Best regards
Sabrina

Re: [resolved] oracle 11g connection

UserTalend_2020 — Mon, 10 Feb 2020 14:49:12 GMT

Hello,

I am new to Talend, and I am trying to establish the connection between Talend Open Studio 7.2.1 and my Oracle Database 11g -64 Bits.

I installed multiple drivers and still am obtaining the following errors:

Exception in component tDBOutput_2 (Teste_2)
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at teste.teste_2_0_1.Teste_2.tFileInputExcel_1Process(Teste_2.java:968)
at teste.teste_2_0_1.Teste_2.runJobInTOS(Teste_2.java:2190)
at teste.teste_2_0_1.Teste_2.main(Teste_2.java:2040)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:439)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:454)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:693)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:251)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
... 9 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:149)
at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:405)
... 14 more

Any ideas why is this happening? Cant figure these errors out.

Thanks