Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader

SQL*Loader

From: Peter Jenny <peter.jenny_at_cedes.com>
Date: Tue, 19 Jun 2001 17:10:27 +0200
Message-ID: <9gnq14$mmb$1@rex.ip-plus.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US