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

Highlighted
Four Stars

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

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 :

jdbcSmiley Surprisedracle:thin:@hostSmiley Tongueort/db

to :

jdbcSmiley Surprisedracle:thin:@hostSmiley Tongueort: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,

 

 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now