Getting Error : ORA-12154: TNS:could not resolve the connect identifier spe
940196Dec 4 2012 — edited Dec 4 2012Hi All ,
Thanks for your help in advance. The error I am getting is "ORA-12154: TNS:could not resolve the connect identifier specified" and before this it is showing me the error message as "SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]".
The two sqlldr statements that is running before these two statements are faliing is :
sqlldr userid=USERNAME/password!!password!!@sid direct=Y parallel=TRUE silent=feedback control='path/clean.txt' log='path/cleaned.log' (table=ABC)
and
sqlldr, userid=USERNAME/!!password!!@orcl direct=Y parallel=TRUE silent=feedback control='path/clean.txt' log='path/cleaned.log'
Please let me know if i am missing here something.
Thanks for your help.
Thanks and Regards ,
Anil