内部错误_ ulconnect_ OCIServerAttach [0]的解决办法

18:50:18,015 INFO  [ExecuterImpl] sqlldr NOAS/cpsnsn123@10.140.65.33:1521:ORCL
control=C:\Users\pi\Desktop\w_n_
821_a8809603f2484316bfd6deccea2cdf62_0.ctl,
18:50:18,173 INFO  [ExecuterImpl]
SQL*Loader: Release 11.2.0.1.0 – Production on 星期四 6月 13 18:50:18 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
SQL*Loader-704:  内部错误: ulconnect: OCIServerAttach [0]
ORA-12154: TNS: 无法解析指定的连接标识符
解决方法:修改tnsname,如果SQLPLUS能使用就没问题,本次本机用的是username/password@server_NAME,
并且更改handle-sqlload.xml中conn的取值,修改jdbc.property,增加一个conn使其适合oracle的tnsname.