topic Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor in Talend Studio

Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

ali_elamin — Sat, 16 Nov 2024 02:51:10 GMT

Dears ,

i have i problem with tjdbc connection component for oracle connection ,

error : Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor,

as i tried to change the connection string from :

jdbcracle:thin:@hostort/db

to :

jdbcracle:thin:@hostort:db

and it doesn't work

however the same connection component works in another jobs ,

So,Does anyone have an idea for why this error comes ?

Many Thanks,

Re: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Anonymous — Tue, 02 Mar 2021 08:12:06 GMT

Hello,

What's your DB connection type you are using? Oracle SID or Oracle Service name? Is SID in the setting OK with you? Did you fill in anything for the data source value?

The error ORA-12505 means that the listener knows about that database, but the listener hasn't received a notification from the database that the database is up.

Are the status of OracleServiceXE and OracleXETNSListener "started "?

Best regards

Sabrina