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

Home -> Community -> Mailing Lists -> Oracle-L -> Help needed with SQL Loader TNS error

Help needed with SQL Loader TNS error

From: Leslie Tierstein <leslie.tierstein_at_visionchain.com>
Date: Wed, 15 Sep 2004 14:29:28 -0700
Message-ID: <4AE2782C2093B34784E67971035A8160EC4A8D@ehost011-2.exch011.intermedia.net>


Oracle 9.2.0.4; everything running (local) on a Windows 2000 sp4 machine

Scenario: SQL*Plus works just fine, as do import/export and various ASP and perl programs

SQL Loader, however, fails with the error:

... sqlldr userid=3Did/pwd_at_ora92 control=3Dwmusitem.ctl data=3Ddata.txt

SQL*Loader: Release 9.2.0.4.0 - Production on Wed Sep 15 17:09:01 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12541: TNS:no listener=20

I have stopped and restarted the listener, to no effect. (Yes, it really is running. In fact, when I leave out @ora92 in the command, I get the error that the listener cannot resolve the service name.)

Lsnrctl status also returns the same error: lsnrctl status

LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production on 15-SEP-2004 17:20
45

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to
(DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dvc100)(PORT=3D1521))) TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

I have checked sqlnet.ora and listener.ora and they appear to be correct re: names, ports, etc.
Tnsping works.

People trying to connect to this db from other Windows machines also experience intermittent problems.

Any ideas? Please ...

Thanks,
Leslie

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 15 2004 - 16:25:44 CDT

Original text of this message

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