Home » RDBMS Server » Server Utilities » SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error
SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error [message #331229] Wed, 02 July 2008 12:49 Go to next message
magafr
Messages: 3
Registered: July 2008
Junior Member
Hello,
i need your help,
i'm trying to connect to a server oracle (not in my machine)

i tried to use this string
sqlldr userid=siebelicm/siebelicm control=c:\de.ctl log=c:\de.log

but it give me
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error

my istance is "ORACLE DB"
so i tried:
sqlldr userid=siebelicm/siebelicm@oracle db control=c:\de.ctl log=c:\de.log
or
sqlldr userid=siebelicm/siebelicm@[oracle db] control=c:\de.ctl log=c:\de.log

but in both case i had now this error
Sql*Loader-100: Syntax error in command line


Can you help me please?
thanks
Francesco
Re: SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error [message #331232 is a reply to message #331229] Wed, 02 July 2008 12:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you set ORACLE_SID?
This one as well as service name can't contain a blank.

Regards
Michel
Re: SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error [message #331237 is a reply to message #331232] Wed, 02 July 2008 13:26 Go to previous messageGo to next message
magafr
Messages: 3
Registered: July 2008
Junior Member
No. I don't think so. How can i do this?

thnaks
very much
Re: SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error [message #331239 is a reply to message #331237] Wed, 02 July 2008 13:28 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can i do this?

The same way as for all environment variables and this depends on your OS and shell.

Regards
Michel
Previous Topic: couldn't figure out the error in exp
Next Topic: imp from .rar
Goto Forum:
  


Current Time: Wed Dec 07 18:24:00 CST 2016

Total time taken to generate the page: 0.05402 seconds