Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader
Hi
I try to use the SQL*Loader for my first time.
I receive the error:
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS: Error at the protocoll adaptor
My tnsnames.ora looks like:
ANBU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = anbu)
)
)
My command:
sqlldr userid=anbu/<myPasswd> control=myControlFile
I can connect to the anbu-db with SQL*Plus and also with the DBA Studio, so
tnsnames.ora seems
to be okay.
What could be the problem ?
Must'n I give the sqlldr-command also the service name instead of only the
db-name and passwd ?
Thanks
Peter
Received on Tue Jun 19 2001 - 10:10:27 CDT