This discussion is archived
5 Replies Latest reply: Dec 4, 2012 7:39 AM by sb92075 RSS

Getting Error : ORA-12154: TNS:could not resolve the connect identifier spe

940196 Newbie
Currently Being Moderated
Hi 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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points