TNS:listener does not currently know of SID

One Star

TNS:listener does not currently know of SID

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.

Rgards
Employee

Re: TNS:listener does not currently know of SID

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
One Star

Re: TNS:listener does not currently know of SID

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 VersionSmiley Surprisedraacle_11
loginSmiley TongueRBC300909tr
passwordSmiley TongueRBC300909tr
server:10.10.0.144
port:1521
sidSmiley SurprisedRCL
schemaSmiley TongueRBC300909tr
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_databaseSmiley Very HappyEV4.WORLD
source_usernameSmiley TongueRBC300909tr
source_passwordSmiley TongueRBC300909tr
source_schemaSmiley TongueRBC300909tr

Thanking you....