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 -> Re: SQL*Loader

Re: SQL*Loader

From: Chris Weiss <weisschr_at_tcimet.net>
Date: Tue, 19 Jun 2001 11:42:33 -0400
Message-ID: <9gnrle$1ecf$1@msunews.cl.msu.edu>

This might be a silly question, but have you tried:

userid=<your real username>/<password>@anbu

Good luck and I hope it was that simple.

Chris Weiss

"Peter Jenny" <peter.jenny_at_cedes.com> wrote in message news:9gnq14$mmb$1_at_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:42:33 CDT

Original text of this message

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