Oracle Database Discussions

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 :

1067148

But unable to resolve my issue

Please let me know what is wrong here?

Thanks,
Abhi