OraFAQ Forum: Networking and Gateways » TNS-03505: Failed to resolve name

Home » RDBMS Server » Networking and Gateways » TNS-03505: Failed to resolve name (Oracle 11gR2)

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

TNS-03505: Failed to resolve name [message #555014]

Mon, 21 May 2012 00:37

aussie
Messages: 5
Registered: May 2012
Location: hyderabad

Junior Member

I have 2 virtual machines, in that two vitual machines oracle servers are there.
machine 1 environment file (ofdb.env):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=ofdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export TNS_ADMIN=$HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

machine 2 environment file (.bash_profile):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export TNS_ADMIN=$HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Now i want to connect from "DB11G (client)" to "ofdb (server)"

ofdb (TNSNAMES.ora) :

TO_OFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523))
)
(CONNECT_DATA =
(SID = ofdb)
(SERVER = DEDICATED)
)
)

DB11G (listener.ora) :

ofdb =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523))
)
)
)
SID_LIST_ofdb =
(SID_LIST =
(SID_DESC =
(SID_NAME = ofdb)
(ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
)
)

in both server & client i had set "TNS_ADMIN = $HOME" (see the above environment files)

so, my listener file is in server home directory

my tnsname file is in client home directory

i was started listener in server (ofdb):

$ lsnrctl start ofdb

listner started succefully

then came to client side (DB11G) :

$ tnsping TO_OFDB

"TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 21-MAY-2012 10:11:27

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

Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name"

How to resolve this error... plzz help me...

thnks in advns.

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555016 is a reply to message #555014]

Mon, 21 May 2012 00:43

BlackSwan
Messages: 20242
Registered: January 2009

Senior Member

127.0.0.1 is NOT reachable from any other system.
Each system must be able to succeed with four different "ping" commands
ping <self_name>
ping <_self_IP#>
ping <other_name>
ping <other_IP#>
then do the same from the "other" system"

post results from all 8 ping commands

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555017 is a reply to message #555014]

Mon, 21 May 2012 00:45

aussie
Messages: 5
Registered: May 2012
Location: hyderabad

Junior Member

If there is any problem in listener & TNSnames then plzz modify the listener and TNSnames files and paste here........

[Updated on: Mon, 21 May 2012 00:46]

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555018 is a reply to message #555017]

Mon, 21 May 2012 00:47

BlackSwan
Messages: 20242
Registered: January 2009

Senior Member

post results from all 8 ping commands
which has NOTHING to do with listener or SQL*Net!
If/when underlying OS is not correct, the SQL*Net is certain to fail!

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555019 is a reply to message #555016]

Mon, 21 May 2012 00:48

aussie
Messages: 5
Registered: May 2012
Location: hyderabad

Junior Member

BlackSwan wrote on Mon, 21 May 2012 11:13

127.0.0.1 is NOT reachable from any other system.
Each system must be able to succeed with four different "ping" commands
ping <self_name>
ping <_self_IP#>
ping <other_name>
ping <other_IP#>
then do the same from the "other" system"

post results from all 8 ping commands

ididnt understand this, im beginner ... so plzz explore it...

thanku

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555020 is a reply to message #555019]

Mon, 21 May 2012 00:51

aussie
Messages: 5
Registered: May 2012
Location: hyderabad

Junior Member

operating system im using is "oracle enterprise linux" in both machines.

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555021 is a reply to message #555019]

Mon, 21 May 2012 00:51

BlackSwan
Messages: 20242
Registered: January 2009

Senior Member

man ping

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555022 is a reply to message #555021]

Mon, 21 May 2012 00:54

aussie
Messages: 5
Registered: May 2012
Location: hyderabad

Junior Member

it just shows the info of ping command...

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555023 is a reply to message #555017]

Mon, 21 May 2012 00:56

John Watson
Messages: 3174
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

There are a lot of mistakes here. Some suggestions:
Read the Oracle Net admin guide http://docs.oracle.com/cd/B28359_01/network.111/b28316/toc.htm# particularly chapters 2 and 3.
Determine, and use, the virtual machines' external IP addresses, not localhost
Confirm your setting and export of TNS_ADMIN, you say you have set it to $HOME but the error messsage says it is /u01/app/oracle/product/11.1.0/db_1/network/admin

Then try again.

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #555024 is a reply to message #555022]

Mon, 21 May 2012 00:56

BlackSwan
Messages: 20242
Registered: January 2009

Senior Member

127.0.0.1 is NOT reachable from any other system.
Each system must be able to succeed with four different "ping" commands
ping <self_name>
ping <_self_IP#>
ping <other_name>
ping <other_IP#>
then do the same from the "other" system"

post results from all 8 ping commands

Report message to a moderator

Previous Topic:	Oracle networking problem
Next Topic:	What Is ISP concept in oracle????

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 17:31:14 CDT 2013

Total time taken to generate the page: 0.28890 seconds