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: WEIRD: sqlldr not working althought sqlnet does!!

Re: WEIRD: sqlldr not working althought sqlnet does!!

From: John Goodens <wootang_warrior_at_hotmail.com>
Date: Mon, 26 Jul 1999 10:27:29 +0200
Message-ID: <7nh63a$oha$1@news3.saix.net>


Hmm....
Fixed this one myself, In the tnsnames.ora I just changed the "corona.world" to "corona" and it worked fine.

Regards

John Goodens <wootang_warrior_at_hotmail.com> wrote in message news:7nff4q$705$1_at_news3.saix.net...
> Hello.
>
> I can successfully connect to the instance via D2K, sqlnet and sqlplus.
> but when I used sqlldr I get the following message:
> ---------------------------------------------------------------------
> oracle_at_wookie:~/scripts > sqlldr corona/passwd_at_corona control=netusage
>
> SQL*Loader: Release 8.0.5.1.0 - Production on Sun Jul 25 18:36:12 1999
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> ORA-12154: TNS:could not resolve service name
> SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [-1]
> ----------------------------------------------------------------------
>
> The TNSNAMES.ORA file is in the correct place and the syntax is correct.
> The box is running SuSE 6.0 with the necessary patches,RPM's whatever.....
>
> I took the listener.ora and tnsnames.ora file from a working installation
> running on SuSE 6.1 and modified it
> appropriately.
>
> ANY IDEAS?
>
> Thanks!
>
>
Received on Mon Jul 26 1999 - 03:27:29 CDT

Original text of this message

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