SQLLDR.EXE <USER>/<USERPASS>@<TNSNAMES_FOR_INSTANCE>
CONTROL=C:\SQL\MYCONTROL.ctl LOG=C:\SQL\MYLOG.log

??



-----Original Message-----
From: Phillips Kenneth S (GE Comm Fin)
[mailto:oracledba-ezmlmshield-x68634538.[Email address protected]
Sent: Thursday, June 29, 2006 1:14 PM
To: LazyDBA Discussion
Subject: SQL loader error.ORA-12560 TNS:protocol adapter error

Trying to load some files via sqlldr. I have searched for documents
that will explain the reason and help me to solve the error. but have
not found anything that I can try.

First I'm running sqlldr from my laptop. (I have oracle 9i client tools
installed). I'm trying to connect to one of my instances on our
network.

I am executing from the command line of my laptop. sqlldr id/pwd
control=controlfilepath\controlfile
now I cannot find any plase where I can enter the Instance name. mine
in this case is ECST. my tsnames.ora file has MANY oracle instances in
it. and I cannot find a way to help it distinquish where I'm trying to
connect. the controlfile has all the other pertinent information. a
colleague has helped me. They usually run this but can not since their
new laptop doesn't have the sqlldr installed. So I'm trying to run it.
We have executed this the same she has done many times but are getting
this error.

Any help or direction would be great.

Regards,
Ken

> g GE Capital Solutions
>
Kenneth S. Phillips III
Informix/SQLServer /Oracle DBA
GE Capital Solutions
ken.[Email address protected] <mailto:ken.[Email address protected]
Wk: (847) 747-6704
Cell: (847) 276-1790




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page