Listener 10gR1 on XP sp1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Listener 10gR1 on XP sp1

  1. #1
    Join Date
    Oct 2005
    Posts
    9

    Listener 10gR1 on XP sp1

    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

  2. #2
    Join Date
    Oct 2005
    Posts
    9
    :-)
    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:\>

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by tonijel
    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.
    Last edited by dbasan; 11-02-2005 at 09:47 AM.
    "What is past is PROLOGUE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width