OraFAQ Forum: Server Administration » TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2

Home » RDBMS Server » Server Administration » TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #133150]

Wed, 17 August 2005 18:31

mvb123
Messages: 3
Registered: August 2005

Junior Member

Hi, i have installed Oracle9i Release 2 (9.2.0.1)enterprise edition on xp pro sp2. During the installation, listener did not start, it throwed a message says listener may be already runing. could not be started.

After Installation, i could not start the listener. when i do tnsping <sid>, it is giving the TNS-03505 : Failed to resolve name .

I have tried out the following options, but the problem did not solve.

1 TNS_ADMIN path added in register and even ORACLE_HOME & ORACLE_SID environment variable were set.

2. No duplicate tnsnames.ora files exists in the HD drive and copied sqlnet.ora & tnsnames.ora under oracle_home\bin and again tried.

3. Windows firewall & Macfee was disabled. pinging works with localhost and Vijay (host) are returning 127.0.0.1 ip address

4. i can able to connect sqlplus userid/password but could not connect using sqlplus userid/password@orcl.

Pls help me how to resolve this problem

Thxs.
-----------------------------------------------------------------
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-AUG-2005 00:07:51

Copyright (c) 1997 Oracle Corporation. All rights reserved.

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is C:\oracle\ora92\network\trace\tnsping.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source
c:\oracle\ora92\network\admin\sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TNSPING.TRACE_LEVEL = ADMIN
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
TNSPING.TRACE_DIRECTORY = C:\oracle\ora92\network\trace
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DEFAULT_DOMAIN = WORLD
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nnfun2awanm: entry
nnfgiinit: entry
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnflcls: entry
nnflcls: exit
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500
csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is WORLD
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or
native_names.directory_path
nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: checking element ONAMES
nnfgsrdp: checking element HOSTNAME
nnfgsrdp: Path set
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: ORCL
nnftinit: entry
nnftinit: Tnsnames refresh interval is 0
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: local names file is
C:\oracle\ora92\network\admin\tnsnames.ora
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is
c:\oracle\ora92\network\admin\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftinit: exit
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfttran: entry
nnfgrne: Query unsuccessful, skipping to next adapter
nnfgrne: Switching to ONAMES adapter
nnfgrne: Original name: ORCL
nngtnms_new_msg: new message, ID 1, type 100
nngtnms_new_msg: initial message pool block, size 2
nngtrms_release_msg: entry
nngtrms_release_msg: exit
nnfgrne: Query unsuccessful, skipping to next adapter
nnfgrne: Switching to HOSTNAME adapter
nnfgrne: Original name: ORCL
nnfhqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfgrne: Query unsuccessful, skipping to next adapter
nnfgrne: exit
nnfun2a: address for name "ORCL" not found
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the path of local and system tnsnames.ora
nnfun2awanm: exit

-----------------------------------------------------------------

# TNSNAMES.ORA Network Configuration File:
C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = localhost)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = orcl)
)
)

----------------------------------------------------------

# SQLNET.ORA Network Configuration File:
C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# SQLNET.AUTHENTICATION_SERVICES= (NTS)
# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

NAMES.DEFAULT_DOMAIN = WORLD

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

# NAME.DEFAULT_ZONE = WORLD

SQLNET.AUTHENTICATION_SERVICES= (NTS)

TNSPING.TRACE_LEVEL=ADMIN
TNSPING.TRACE_DIRECTORY= C:\oracle\ora92\network\trace

#TRACE_UNIQUE_CLIENT=YES
#TRACE_LEVEL_CLIENT=ADMIN

# trace_file_client = cli.trc
# trace_directory_client = C:\oracle\ora92\network\trace
# log_file_client = sqlnet.log
# log_directory_client = C:\oracle\ora92\network\log

# tcp.validnode_checking = No
# tcp.invited_nodes = (127.0.0.1,localhost)

---------------------------------------------------------------

# LISTENER.ORA Network Configuration File:
C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\oracle\ora92)
)
)

TRACE_LEVEL_LISTENER = ON
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_FILE_LISTENER = C:\oracle\ora92\network\trace\listener.trc

----------------------------------------------------------------