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

  • Data Integration
1 REPLY
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.