937193 wrote:see http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
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 ".
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)
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 ,
Osama_mustafa wrote:Below have NOTHING to do with ORA-12154 error
Please post more information :
-listener.oraORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system