Re: Connectstring with SQL*Loader

"Bo Brunsgaard" <bbcworldtour_at_hotmail.com> schrieb im Newsbeitrag news:55c7f17e.0307180515.49d3089e_at_posting.google.com...
> I have a problem trying to run SQL*Loader after migrating to Oracle
 9.
> It used to run with no hicups on Oracle 8i, and I'm at my wits' end.
> Any help?
>
> I'm trying to run SQL*Loader from a command prompt (I'm on Oracle 9i
> R1 and WinXP professional), and fail to connect to the database.
>
> The command at the promt is like this:
>
> sqlldr bbc/password_at_bbc control = C:\...path to controlfile
>
> SQL*Loader then runs but fails with the message, that TNS cannot
> resolve the servicename (ORA-12154).
>
> I know, and have re-checked, that the service "bbc" IS defined.
>
> If I then retry without naming the service, I would expect
 SQL*Loader
> to connect to my local (default) database, which happens to be the
> same as the one defined in "bbc". Same problem, same message.
>
> I can, with absolutly no problem, run SQL*Plus from a commandline,
> invoking it with the same connectstring. It works fine, both with
 and
> without specifying the servicename.
>
> I'm almost out of hair to tear out now. Anyone can give me a clue?
>
> Best,
>
> Bo Brunsgaard
> Vitus Bering CVU.

Hi Bo,

is there any chance that your sqlldr and the sqlplus that you use reside in different oracle homes?

Just a guess...

Greetings,
Guido Received on Fri Jul 18 2003 - 15:57:28 CEST