TNS-03505: Failed to resolve name
596369Sep 5 2007 — edited Jan 20 2010Hye all. Little problem with Oracle DB. On a Suse machine, I installed Oracle XE 10g. On the other side, an AIX server with oracle databases. Here is the tnsnames.ora on suse machine (it is the same than the AIX server) :
db_strat=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)(HOST=192.168.65.7)(PORT=1521))
(CONNECT_DATA =
(SID=strat)
)
)
And when I try a tnsping I get the following error :
./tnsping db_strat
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 05-SEP-2007 10:30:06
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
What could be wrong ? I tried to change the HOST variable with the hostname instaed of IP, add the domain in sqlnet.ora, no changes !(. Do you have any idea please ? Thanks in advance.