Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TNS-03505 Failed to Resolve Hostname

Guys I am having trouble with a NW2004s installation. I am getting the following error when I do a TNSPING of my listener (LISTENER_DC1)

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production o

n 03-SEP-2008 08:35:19

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

Used parameter files:

/oracle/DC1/102_64/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

p15913dtp220:oradc1> ^C

p15913dtp220:oradc1> ^C

p15913dtp220:oradc1>

Here is my sqlnet.ora file

p15913dtp220:oradc1> cat sqlnet.ora

################

  1. Filename......: sqlnet.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

  1. 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

  1. 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

  1. 05.01.06 set to default

#TCP.NODELAY=YES

  1. 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

This is my TNSNAMES.ORA file

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

DC1.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sapdbdc1-sv)

(PORT = 1539)

)

)

(CONNECT_DATA =

(SID = DC1)

(GLOBAL_NAME = DC1.WORLD)

)

)

This is my Listener.ora file

################

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4

################

ADMIN_RESTRICTIONS_LISTENER_DC1 = on

LISTENER_DC1 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DC1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DC1)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sapdbdc1-sv)

(PORT = 1539)

)

)

STARTUP_WAIT_TIME_LISTENER_DC1 = 0

CONNECT_TIMEOUT_LISTENER_DC1 = 10

TRACE_LEVEL_LISTENER_DC1 = OFF

SID_LIST_LISTENER_DC1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = DC1)

(ORACLE_HOME = /oracle/DC1/102_64)

)

(SID_DESC =

(SID_NAME = DC1)

(ORACLE_HOME = /oracle/DC1/102_64)

)

)

Any help much appreciated !!

Thanks

Former Member
replied

Not really. I only know this because it's zapped me before as well. However, if you'd like to attempt a clean installation here from start to finish, you may want to entertain the SAP route here and not the Oracle route. Use SAPINST to export the database and use this custom export to perform the new installation. You'll get a few benefits here but most notably a full database reorganization. That way, you don't need to adjust anything afterward.

BTW - was that the fix? Are you running again? It's UNIX, so the fix is pretty quick (one env variable, right?).

Let me know - thanks for your patience Nick.

Cheers,

Tim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question