Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
Connection failed: Failed to connect: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor , caused by: NetException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I verified in the server with other database (Qlicksense, sql plus ...) i was able to connect successfully ; verified environment variables ; verified TNS names file
Any help please ?
Hi @Meryem_dss ,
jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE
Regards,
Hello @Andrey ,
Thank you for your response,
Even if I switch to the "custom URL" mode : I have a new error message : No suitable driver.
Thank you in advance,
Could you tell if you've added an Oracle jdbc jar to the DATADIR/lib/jdbc directory as described here?
https://doc.dataiku.com/dss/latest/connecting/sql/oracle.html#installing-the-jdbc-driver
@Andrey : Yes, I confirm that the ORACLE jdbc jar has already been added.
@Meryem_dss , could you also tell the oracle version that you're connecting to?
By the way, did you restart DSS after putting jdbc jar in the lib/jdbc?
It would also help if you could share your jdbc driver jar and instance diag.(Administration > Maintenance > Diagnostic tool)
You can send it to andrey.avtomonov@dataiku.com
If the resulting file is too large for mail (> 15 MB), you can use https://dl.dataiku.com to send it to us. Please don't forget to send the link that is generated when you upload the file.