5 Replies Latest reply: Dec 4, 2012 9:39 AM by sb92075 RSS

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

    940196
      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