RE: Help needed with SQL Loader TNS error

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_at_francetelecom.com




-----Message d'origine-----
De : oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]De la part de Leslie Tierstein
Envoy=E9 : mercredi 15 septembre 2004 23:29
=C0 : oracle-l_at_freelists.org
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_at_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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l