One Star

tOracleConnection doe snot use SERVICE_NAME

Hi,
I'm working on Windows 7 64 bits, with TOS DI 5.4.1, Java JDK 1.6.1_43 and Oracle 11gR2
I have a problem with the configuration of tOracleConnection.
See the attached documents for the job settings.
I cannot use the features "Guess Query" or "Guess Schema" because of an Oracle error:

Database connection is failed.
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:179)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1034)
...


When I set manually the schema of tOracleInput, the job correctly connect to the database and return the output of the query.
Please help!!!
Seb

  • Data Integration
4 REPLIES
Moderator

Re: tOracleConnection doe snot use SERVICE_NAME

Hi,
Did you use SID for Database value?
Can you make metadata oracle DB connection successfully?
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.
One Star

Re: tOracleConnection doe snot use SERVICE_NAME

I used Service name.
I can make a successful metadata connection but the error is still there.
Seb
Seventeen Stars

Re: tOracleConnection doe snot use SERVICE_NAME

Mostly this happened if some context parameters are wrong. I work with Oracle 11g and Talend 5.4.1 and it works well - also the Guess Schema functionality.
You could change or inspect the used parameters if you click on Set parameter and continue
One Star

Re: tOracleConnection doe snot use SERVICE_NAME

The window "Configure Connection Parameters" complains about the empty string ("") AdditionalJDBC Parameters.
See attached screen.
What should i then put there?
Seb