SQL Plus works, but sqlldr does not
Posted on 2005-04-12
I recently got a new laptop and it is running windows xp sp2. I installed Oracle 9i and moved everything off my old one to this one. All settings look identical. The only difference is the machine name.
Now I am having an issue connecting to the database through some 3rd party apps, but bigger is that I am having an issue executing SQL Loader. I have no problem with connecting via SQL*Plus, nor some other ODBC query tools, but there is one that is having an issue. At first I just submitted a support request to the vendor and dismissed it as thier tool does not play well with XP Sp2. But then I tried to run the sqlldr scripts that I had written. That is when I think this became more complex.
The error I get when I run sqlldr is:
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach 
ORA-12154: TNS:could not resolve service name
The error I get from some other apps is simply :
TNS:could not resolve service name
My tnsnames.ora file points to everything correctly.
Does anyone have any ideas?