HI prof's.. i am getting TNS error,how we can resolve? ERROR:" Exception in component tOracleInput_1 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.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) at "
Note:- 1. i created one sample job,with same database settings(for source and target),but the job is able to load data from source to target. 2.in case of executing old backup with same database settings i am getting the above error.
Hello I dont really get you when you re talking about "old backup". This kind of error occurs when you have an issue with your tnsnames.ora file. Could you give us screenshot of the database connection parameters in Talend and copy-paste of your database entry in the .ora file. Thank you
my .ora file from TOAD is like this.. " DEV4.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.0.144)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) " TOS databasesettings are; DB Type: Oracle with SID DB Versionraacle_11 loginRBC300909tr passwordRBC300909tr server:10.10.0.144 port:1521 sidRCL schemaRBC300909tr based on the above settings,i got message "connection is successfull" but when every i am trying to executing mappings i am gettings TNS Listerner ERROR. NOTE: I set context variables also.. context variables settings are: source_host:10.10.0.144 source_port:1521 source_databaseEV4.WORLD source_usernameRBC300909tr source_passwordRBC300909tr source_schemaRBC300909tr