topic Unable to connect to Oracle Database in Talend Studio

Unable to connect to Oracle Database

vivekjayapalan — Sat, 16 Nov 2024 10:47:59 GMT

Hi,
I am having trouble creating DB connection to oracle database, i am using Talend Open Studio Version: 6.1.1
DB Type: Oracle Custom
Db Version: Oracle 11
Login: xxxx
Password: xxxx
String of Connection: jdbc racle:thin:@dwm4-5-scan.fnfis.com:1521/dwprdx5_dir_svc
Schema: DWET1

The above mentioned credentials is working fine for my colleague, he and me have same version of Talend. When i create the connection and press check to check the connection i am getting following error

Could you please tell me what is the issue here, i have also installed all necessary required updates for all the components.
But still i am having issues with creating Db connection to Oracle.
Thanks,

Re: Unable to connect to Oracle Database

Anonymous — Tue, 16 Feb 2016 22:44:36 GMT

I would check the connection with an external tool like SQLPlus or JDeveloper. What we can say for sure, the raw network parameters are correct because you have reached the database TNS listener. I guess the database name is wrong (the last part of the URL).
Why don't you use the normal Oracle connection type? Here you would be ask for the correct parts of the connection.

Re: Unable to connect to Oracle Database

vivekjayapalan — Wed, 17 Feb 2016 17:46:46 GMT

Yes it worked, when i changed the Db Type to Oracle Service instead of Oracle custom and filled the credentials one after the other it worked.
I still don't know why the Oracle custom didn't work for me, but the same works fine for my colleague. I tried copying each details from my colleague's machine even then it didn't work. Oracle Custom option is unpredictable, using proper Db connection type is always better.
Thanks