Help needed with SQL Loader TNS error
- From: "Leslie Tierstein" <leslie.tierstein@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Sep 2004 14:29:28 -0700
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
