-
TNS-03505: Failed to resolve name
Dear All,
I am getting following error while tnsping to my standby database.
rlsdevraqas 1> tnsping qasst
TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 29-SEP-2011 18:58: 13
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/QAS/102_64/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
--------------------------------------------------
My tnsnames.ora file as below :
--------------------------
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
QAS.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = rlsdev)
(PORT = 1528)
)
)
(CONNECT_DATA =
(SID = QAS)
(SERVICE = QAS)
(GLOBAL_NAME = QAS.WORLD)
)
)
qasst.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = rlsapdr)
(PORT = 1529)
)
)
(CONNECT_DATA =
(SID = QAS)
(SERVICE_NAME = qasst)
)
)
-------------------------
Regards,
Nirav
-
did you check the listener? is it up and running and on the same port?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Thanks for your reply.
Yes, I have checked listner. It is on the same port 1529 and it is up.
-
I would start with a simpler example (see below) and I would change
the name of your machine to use an IPC address..
Test using ping ip_address first to make sure that works.
QAS.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipc address here <#.#.#.#>)(PORT = 1528))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qas)
)
)
Good luck
-
Originally Posted by BeefStu
I would start with a simpler example (see below) and I would change
the name of your machine to use an IPC address..
Test using ping ip_address first to make sure that works.
QAS.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipc address here <#.#.#.#>)(PORT = 1528))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qas)
)
)
Good luck
well all that is useless as it has nothing to do with the actual error, which is cannot resolve name
the reason is becuase your are doing a tnsping on qasst but your tnsnames has qasst.world
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|