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
When I set manually the schema of tOracleInput, the job correctly connect to the database and return the output of the query.
i know it's an old message but i have the same error with TOS DI 7.0.1 and a solution for it.
i guess you have a problem with DBInput Component or with some other component that uses an existing connection.
I had the same problem and i think it's a bug.
Here is the case :
I have a DB Connection component with Connection Type "Oracle Service Name"
When i put a DB Input Component in my project the default values are like these. ( Connection Type is "Oracle SID" )
When i check "use an existing connection" "Connection Type" and other values are gone because these value will be used from an existing connection ( That's what user thinks, but in real it's not true).
If you don't want to define the schema manually you can slect a table from the DB. But if you click the "..." button you get this error.
The solution is to uncheck "use an existing connection" and set "Connection Type" to "Oracle Service Name". Then check "use an existing connection" again, now it works.