Listener 10gR1 on XP sp1

[tonijel]

Hi all.
The problem is like this...

C:\>tnsping listener

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-STU-2005 22:46:53

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-STU-2005 22:47:04

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MASHINA)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
Start Date 01-STU-2005 22:22:37
Uptime 0 days 0 hr. 24 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.1.0\db_1\network\admin\listener.ora
Listener Log File C:\oracle\product\10.1.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mashina)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mashina)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mashina)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Uto Stu 1 22:47:27 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> conn sys/sistem@orcl as sysdba
Connected.
SQL> host tnsping listener

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-STU-2005 22:48:15

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

SQL>


here is my listener.ora:

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MASHINA)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

and sqlnet.ora:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

..anyone have clue why am I getting TNS-03505 when I tnsping, but no error in lsnrctl status command & still can connect to orcl whitout error msgs, which is only DB on this host btw

[tonijel]

:-)
C:\>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-STU-2005 23:30:45

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MASHINA)(PORT = 1521)) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = orcl)))
OK (40 msec)

C:\>

[dbasan]

Hi all.

..anyone have clue why am I getting TNS-03505 when I tnsping, but no error in lsnrctl status command & still can connect to orcl whitout error msgs, which is only DB on this host btw

When you use TNSPING command this will inturn check the TNSNAMES.ora file for the service name which you are trying to ping.
When it does not find one it will give the TNS-03505: Failed to resolve service name error

Obviously one will not have listener as service name.