Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

940196Dec 4 2012 — edited Dec 4 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2013
Added on Dec 4 2012
5 comments
728 views