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

1 ACCEPTED SOLUTION

Accepted Solutions
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.
8 REPLIES
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.
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

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.
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

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.
Four Stars

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

TalendOraConnIssue.JPG

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.
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