Home » RDBMS Server » Server Administration » TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2
TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #133150] Wed, 17 August 2005 18:31 Go to next message
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

----------------------------------------------------------------
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #133301 is a reply to message #133150] Thu, 18 August 2005 07:43 Go to previous messageGo to next message
anujlal
Messages: 4
Registered: August 2005
Junior Member
Maybe I am missing something. But can you try one simpe thing and
pass on the error message if any?

lsnrctl > stat listener


In case the listener is not running , then :

lsnrctl :> start listener


Ensure that your Oracle database service is up and try connecting to the database with the service name.


Please pass on the exact error messages you get at each stage.

Regards
Anuj

Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #133302 is a reply to message #133301] Thu, 18 August 2005 07:45 Go to previous messageGo to next message
anujlal
Messages: 4
Registered: August 2005
Junior Member
You can also try starting the Oracle listener at some other port, say , 2000 instead of 1521.

Regards
Anuj
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #133366 is a reply to message #133150] Thu, 18 August 2005 12:05 Go to previous messageGo to next message
mvb123
Messages: 3
Registered: August 2005
Junior Member
Hi,

Thxs for the details.

in command mode, i can connect to oracle database using sqlplus userid/password. but i could not use the connect string like sqlplus userid/password@orcl.

When i verified with tnsping orcl, i am getting the above said error.

Will give a try as you suggested and post the status soon.


Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #134292 is a reply to message #133366] Wed, 24 August 2005 04:05 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
sqlnet.ora, tnsnames.ora & listener.ora files need to be place in %ORACLE_HOME%/network/admin folder. After that refresh listener. Probably that shd solve ur problem.

Regds
Girish
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #202086 is a reply to message #133150] Wed, 08 November 2006 03:00 Go to previous messageGo to next message
senthil29
Messages: 4
Registered: October 2006
Junior Member
Hello Girish,

i am also geting he same problem.how did you solve this.


regards,
senthil.
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #202119 is a reply to message #133150] Wed, 08 November 2006 04:30 Go to previous messageGo to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi,

this won't solve your current problem, but it will explain why you can connect using sqlplus username/password but not with sqlplus username/password@tns

I guess you are currently trying on the machine where Oracle is installed.

When you connect with the method sqlplus username/password, you are using a different connection methd from username/password@tns
it uses the environment variable oracle_sid to do so and you specified it in your environment variable.

This method doesn't need a listener.

When you connect using sqlplus username/password@tns, you will use the description specified in your tnsnames and use the listener to connect. You are facing problems with your listener, so it's not working.

That is to say, it's not weird that you can one way but not another way.

In your tnsnames.ora, I would change SID with SERVICE_NAME in the CONNECT_DATA parameter. That could solve your problem.

regards,

Nicolas
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #236580 is a reply to message #202119] Thu, 10 May 2007 05:12 Go to previous messageGo to next message
Stünky
Messages: 2
Registered: March 2007
Location: Cape Town
Junior Member

Hi,
I am having the same problem. All my environment variables have been setup and I can connect using username/password but username/password@database.

I have tried replacing SID with SERVICE_NAME and vice-versa again but no go.

Have any of you managed to find a solution to this problem?

Thanks!
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #236587 is a reply to message #133150] Thu, 10 May 2007 05:30 Go to previous messageGo to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi.

I've written something on this issue at this address http://thetendjee.wordpress.com

It won't solve all TNS-03505 problem but it could help a lot.
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #236591 is a reply to message #236580] Thu, 10 May 2007 05:34 Go to previous messageGo to next message
Stünky
Messages: 2
Registered: March 2007
Location: Cape Town
Junior Member

Ok, I found the solution on another site so will paste a summary here:

In the sqlnet.ora file locatated in the $ORACLE_HOME/network/admin directory, there are two parameters that can be set:
1. NAMES.DIRECTORY_PATH
2. NAMES.DEFAULT_DOMAIN

If you are running the db instance on your local machine, then you can remove the NAMES.DEFAULT_DOMAIN setting and set the
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME).

If you are at a client, as I am, then you will need to set the NAMES.DEFAULT_DOMAIN to the company domain, e.g. 'mycompany.com'.

The service name is resolved by appending the instance name (from tnsnames.ora) to the default domain (from sqlnet.ora), e.g. orcl.mycompany.com.

So if you connect at work using username/password@database it appends the domain: username/password@database.mycompany.com.

If you attempt to connect locally, then you will receive the error as you are no longer on the work domain.
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #237554 is a reply to message #236591] Mon, 14 May 2007 20:41 Go to previous messageGo to next message
josedial
Messages: 1
Registered: May 2007
Location: Bogota
Junior Member

I had exactly the same two problems (1. ORA 1031 and 2. TNS-03505)
They appears after the patch from oracle 9.2.0.1 to 9.2.0.8.

The solution x the #2 TNS was add to the path the line (=c:\oracle\ora92\bin) because after the patch it doesnot exist any more. So that was the solution.

But , I still have the problem ORA-1031 insufficient privileges:

Some data:
c:\>net localgroup

Aliases for \\JOSEDIAL1

------------------------
*__vmware__
*Administrators
*Backup Operators
*ora_dba

* The user I'm using is a member a the local group ora_dba

* I use a password file ( I verified in the v$pwfile_users) and sys is ok.

I can connect from the command line using ("user/pass as sysdba"
or "user/pass@sid as sysdba",
but not with (sqlplus "/as sysdba")

What else do i do
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #237559 is a reply to message #133150] Mon, 14 May 2007 21:23 Go to previous messageGo to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi.

Concerning your privileges problem and your inability to connect to your database using sqlplus "/ as sysdba".

Make sure you go the following line in your sqlnet.ora:

sqlnet.authentication_services = (NTS,BEQ)

and make sure the user you connect with on your workstation/server is part of oradba user group.

Note that if you connect remotely, it's actually good that you can't perform an implicit authentication. It would be a bit unsecure.

Hope this helps.

regards
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #237564 is a reply to message #133150] Mon, 14 May 2007 22:24 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Hi,

I had a similar issue like this when I used the domain login account. It was resolved when I used the local admin account. Can you login using the local administrator account? Delete the existing listener. Create a new one and try to start the service.
Resolved. Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #238832 is a reply to message #133150] Sun, 20 May 2007 06:47 Go to previous messageGo to next message
mvb123
Messages: 3
Registered: August 2005
Junior Member
Hi,
Thank you all. somehow, the issue didn't resolved . so unstalled Oracle 9i and tried out oracle 10g. it is working fine.

Thxs.
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #238865 is a reply to message #133150] Sun, 20 May 2007 13:28 Go to previous messageGo to next message
zeshanali76
Messages: 180
Registered: January 2006
Location: Pakistan
Senior Member

Dear Friends, It has a very simple solution. don't go anywhere. Just off the firewall setting of Windows XP SP2. Firewall block the TCP requests when they are incomming. Ur PC sends TCP packets to DNS and could not get reply due to firewall and ur listerner could not started. Just turn off the Firewall and install other listerner r use exiting one. Take Care
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #403852 is a reply to message #133150] Tue, 19 May 2009 04:00 Go to previous messageGo to next message
delisyoso
Messages: 2
Registered: May 2009
Junior Member
Check tnsnames.ora syntax... ensure last entry also terminated by carriage return, e.g. all entries except last found by tnsping.
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #436965 is a reply to message #403852] Wed, 30 December 2009 00:00 Go to previous messageGo to next message
scubie
Messages: 5
Registered: March 2006
Junior Member
For those that may still be struggling with this, and everything seems right in your tnsnames.ora etc etc, search for any tnsnames.ora files that may be elsewhere and may be empty or incomplete or something!

I found one under /etc and it was empty...Nothing works then until you delete it. How it got there, I am not sure, but removing it solved my TNS-03505 problems!

[Updated on: Wed, 30 December 2009 00:01]

Report message to a moderator

Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #436967 is a reply to message #436965] Wed, 30 December 2009 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That is why it is recommended to set the TNS_ADMIN environment variable which will point to a single copy of the TNSNAMES.ORA file. You may have many of them (and you actually DO have many of them, as many as Oracle products on your computer) and it is insane to maintain each and every of them.

For more information, search for TNS_ADMIN (either on the board or elsewhere).
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #437594 is a reply to message #133150] Tue, 05 January 2010 03:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Issue Tnsping tnsentry and check the location.

A similar problem is discussed on TNS-03505
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #437609 is a reply to message #437594] Tue, 05 January 2010 03:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is too bad that all your answers are just a pointer to your blog.
It should be fair you post the answer here.

Regards
Michel
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #437612 is a reply to message #437609] Tue, 05 January 2010 03:58 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel, whatever the thing, the target is to help the people. So if a blog post helps someone that should be ok I believe.
Re: TNS-03505 : Failed to resolve name , ora9i R2 on xp pro sp2 [message #437614 is a reply to message #437612] Tue, 05 January 2010 04:06 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the real target is to help people why don't you post the answer here.
I think your real target is to advert for your blog as all your answers are in this form now.

In addition, what happens if your blog is unreachable for someone?
Better have the answers in 2 places.

And, a personal assessment, I prefer a site like OraFAQ with (almost) no advert than a site like yours full of adverts like yours.

Regards
Michel

[Updated on: Tue, 05 January 2010 04:07]

Report message to a moderator

Previous Topic: error duing oracle 11g rel2 instalation
Next Topic: processes and sessions settings
Goto Forum:
  


Current Time: Sat Dec 10 09:25:30 CST 2016

Total time taken to generate the page: 0.07683 seconds