topic Re: Database Connection Failed on Oracle 11 in Talend Studio

Database Connection Failed on Oracle 11

_AnonymousUser — Sat, 16 Nov 2024 11:52:38 GMT

I am attempting to connect to Oracle using the tOracleInput_1 component. When setting up my connection I am using the Oracle Service Name on Oracle 11.
I have done a TNSPING of the service name to obain the Host and Port and have provided the correct credentials to log in, as I am able to log in through SQL Developer.
When I attemp to query a table I obtain the following error message...
"Database connection is failed"
Under details it states...
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:Listener does not currently know of service requested in connect descriptor.
We are using OID to connect with LDAP.

Re: Database Connection Failed on Oracle 11

Anonymous — Sat, 12 Oct 2013 03:27:23 GMT

Hi,
Would you mind taking a look at the article http://stackoverflow.com/questions/11837345/listener-refused-the-connection-with-the-following-error-ora-12514 to see if it is useful for your problem?
Best regards
Sabrina

Re: Database Connection Failed on Oracle 11

_AnonymousUser — Sat, 12 Oct 2013 15:26:22 GMT

Thanks for your response. It turns out that I needed to fully qualify my Service name. I was putting in the Database field "SERVICENAME", when it needed me to fully qualify it to "SERVICENAME.abc.com". Once I fully qualified i was able to access.
Thanks!

Re: Database Connection Failed on Oracle 11

Anonymous — Mon, 14 Oct 2013 04:00:14 GMT

Hi,
It is a great news for us, thanks for your feedback. Feel free post your issue on forum.
Best regards
Sabrina