Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Help needed with SQL Loader TNS error
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-lReceived on Wed Sep 15 2004 - 16:25:44 CDT
![]() |
![]() |