Ken
Try id/[Email Address Removed] luck
Chris
-----Original Message-----
From: Phillips Kenneth S (GE Comm Fin)
[mailto:oracledba-ezmlmshield-x68634538.[Email address protected]
Sent: Thursday, June 29, 2006 3: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
This message (including any attachments) is confidential and intended solely for the use of the individual or entity to whom it is addressed, and is protected by law. If you are not the intended recipient, please delete the message (including any attachments) and notify the originator that you received the message in error. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Vanguard Health Systems.
Oracle LazyDBA home page