Hello, I had a problem with the registration of the database with the listener = on 9204. The individual patch 3003104 is applied with the opatch utility. As such the database then registers itself with PMON at start up. There is a delay of about a minute for the registration process to = complete. This would mean that you are using service connections and not SID = connections. tnsnames.ora: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D SMAIR7A_r7mai11d_DED=3D (DESCRIPTION=3D (ADDRESS_LIST=3D (ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D10.162.16.240)(PORT=3D1552)) ) (CONNECT_DATA=3D (SERVICE_NAME=3DDMAIR7A.ftm.francetelecom.fr) (INSTANCE_NAME=3DDMAIR7A1) (SERVER=3DDEDICATED) (INSTANCE_ROLE=3DANY) ) ) # Local listener configuration used for dedicated service registration LISTENER_SMAIR7A_r7mai11d=3D (ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D10.162.16.240)(PORT=3D1552)) listener.ora: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D SMAIR7A_r7mai11d_LSNR=3D (DESCRIPTION=3D = (ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D10.162.16.240)(PORT=3D1552)(QUEUESIZE=3D= 1024)) ) STARTUP_WAIT_TIME_SMAIR7A_r7mai11d_LSNR=3D0 CONNECT_TIMEOUT_SMAIR7A_r7mai11d_LSNR=3D10 #TRACE_LEVEL_SMAIR7A_r7mai11d_LSNR=3DSUPPORT Try this and then it should work Regards Peter -- Peter Lomax tel: 0155881546 fax: 0155881594 65-67, avenue Vladimir Illich L=E9nine 94110 Arcueil SIFAC / DO-NSFM=20 email: plomax.ext@xxxxxxxxxxxxxxxxx -----Message d'origine----- De : oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]De la part de Leslie Tierstein Envoy=E9 : mercredi 15 septembre 2004 23:29 =C0 : oracle-l@xxxxxxxxxxxxx Objet : 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=3D3Did/pwd@ora92 control=3D3Dwmusitem.ctl = data=3D3Ddata.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=3D20 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=3D3D(ADDRESS=3D3D(PROTOCOL=3D3DTCP)(HOST=3D3Dvc100)(PORT=3D3= D1521))) 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 -- //www.freelists.org/webpage/oracle-l