-
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
-
:-)
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:\>
-
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 10: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|