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

[ali_elamin]

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,

[Anonymous]

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