Error while creating Oracle DB connection: "Connection failure. you must change Database settings"

[Anonymous]

I am using Talend Community edition to create Oracle Connection and using the following steps.

Metadata > Create Connection > Oracle with service Name or Oracle with SID > selected appropriate DB version > Entered all the required details > Check ("Connection failure. you must change Database settings"), please advise.

Note: Installed appropriate driver supporting version of Oracle

Using the same details I am able to connect to DB using SQL Developer. Also using similar approach I am able to connect to different data base as well.

Regards,

Siva

[Anonymous]

Hello,

What's oracle DB version you are using? On which talend build version you got this issue? Is there any more error message about your connection failure? Would you mind posting your DB connection setting screenshot on forum? Please mask your sensitive data.

Best regards

Sabrina

[Anonymous]

Hi,

I am also getting the same error while trying to create new DB connection (I am able to connect the same DB using other tools).

Below is the details:

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:275)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:264)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)
... 14 more

[Anonymous]

Hello,

Could you please indicate on which talend build version you got this issue?

Best regards

Sabrina

[Anonymous]

Hello,

I am using Talend Open Studio for Data Quaity (6.4.1.20170623_1246).

Regards,

Debarati

[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 datasource value?
Screenshot of your DB connection setting will be helpful for us to address your issue.

Best regards

Sabrina

[Anonymous]

[Anonymous · Accepted solution]

Hello,

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

[Anonymous]

Thanks Xdshi,

After starting OracleXETNSListener  service I am able to connect Oracle from TOS