Home » RDBMS Server » Networking and Gateways » TNS-03505: Failed to resolve name (Oracle 11gR2)
icon4.gif  TNS-03505: Failed to resolve name [message #555014] Mon, 21 May 2012 00:37 Go to next message
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.


Re: TNS-03505: Failed to resolve name [message #555016 is a reply to message #555014] Mon, 21 May 2012 00:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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
Re: TNS-03505: Failed to resolve name [message #555017 is a reply to message #555014] Mon, 21 May 2012 00:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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!
Re: TNS-03505: Failed to resolve name [message #555019 is a reply to message #555016] Mon, 21 May 2012 00:48 Go to previous messageGo to next message
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
Re: TNS-03505: Failed to resolve name [message #555020 is a reply to message #555019] Mon, 21 May 2012 00:51 Go to previous messageGo to next message
aussie
Messages: 5
Registered: May 2012
Location: hyderabad
Junior Member
operating system im using is "oracle enterprise linux" in both machines.
Re: TNS-03505: Failed to resolve name [message #555021 is a reply to message #555019] Mon, 21 May 2012 00:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
man ping
Re: TNS-03505: Failed to resolve name [message #555022 is a reply to message #555021] Mon, 21 May 2012 00:54 Go to previous messageGo to next message
aussie
Messages: 5
Registered: May 2012
Location: hyderabad
Junior Member
it just shows the info of ping command...
Re: TNS-03505: Failed to resolve name [message #555023 is a reply to message #555017] Mon, 21 May 2012 00:56 Go to previous messageGo to next message
John Watson
Messages: 8922
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.

Re: TNS-03505: Failed to resolve name [message #555024 is a reply to message #555022] Mon, 21 May 2012 00:56 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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
Previous Topic: Oracle networking problem
Next Topic: What Is ISP concept in oracle????
Goto Forum:
  


Current Time: Thu Mar 28 07:36:44 CDT 2024