5 Replies Latest reply: Jul 28, 2010 4:49 AM by OraMol RSS

    ORA-12154: TNS:could not resolve the connect identifier specified

    718177
      Hi everyone,

      I am getting this error when I am trying to use SQLLDR
      ORA-12154: TNS:could not resolve the connect identifier specified
      
      -- tns entry is 
      
      xyz = 
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xxx.xx)(PORT = 1526))
          )
          (CONNECT_DATA =
            (SID = xyz)
          )
        )
      
      -- I am able to connect using sqlplus
      
      sqlplus user/pwd@xyz
      
      -- but when I am trying to use sqlldr as follows, I am getting ORA-12154 error
      
      sqlldr userid=user/pwd@xyz DATA=test_sql_ldr.txt CONTROL=test_sql_ldr.ctl LOG=test_sql_ldr.log
      
      
      SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jul 28 11:42:53 2010
      
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      
      SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
      ORA-12154: TNS:could not resolve the connect identifier specified
      I also read following thread for same type of error :

      ORA-12154: TNS:could not resolve the connect identifier specified

      But unable to resolve my issue

      Please let me know what is wrong here?

      Thanks,
      Abhi