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

Highlighted
One Star

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

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


Accepted Solutions
Highlighted
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post


All Replies
Highlighted
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

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

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

Highlighted
Moderator

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

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

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

Hello,

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

Regards,

Debarati

Highlighted
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

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

TalendOraConnIssue.JPG

Highlighted
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post

Highlighted
Four Stars

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

Thanks Xdshi,

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

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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog