sqlloader error

[ora_inf]

Hi:
When I try to Load some data into an Oracle table thro SQL Loader, I get the following error:
SQL * Loader - 704 Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS: Protocol adaptor error.

Please let me know, what's wrong.

Thanks.

[Prasy]

Hai,

TNS protocol adapter error, usually comes when the listener is not up !!!

[ora_inf]

listerner is up.

[sysdba]

Can you connect database via sql*plus or tnsping?

[ora_inf]

via sqlplus

[kmesser]

Is the SQL*LOADER in the same ORACLE_HOME, on the same machine as the SQL*PLUS you can get connected? If not, you need to edit your tnsnames.ora to reflect the correct settings, such as those in the tnsnames.ora file in the /network/admin directory in the ORACLE_HOME where SQL*PLUS will run from.

[shawish_sababa]

kmesser Is right. I ren into thesame error message and we ended up finding that the problem was in the tnsnames on the server side (we where useing oracle application r11.03. trying to run the loader form the apps), the ip address was incorect on that tnsnames. at that time when you connected to useing the client side, no problem, process run on the server had problems

[ora_inf]

Server and Client reside on the same machine.