Re: tnsmname error

Posted by Arsalan on Nov 26, 2016; 7:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsmname-error-tp1621p1623.html

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\arsla>tnsping dwsig

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 26-NOV-2016 11:53:45

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

Used parameter files:
C:\app\arsla\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = srv-webdw)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME
 = dwsig)))
TNS-12543: TNS:destination host unreachable

C:\Users\arsla>
C:\Users\arsla>
C:\Users\arsla>sqlplus system/DW12#a@dwsig

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 26 11:55:15 2016

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-12543: TNS:destination host unreachable


Enter user-name:

----The below is tnsname.or file


# tnsnames.ora Network Configuration File: C:\app\arsala\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DWSIG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = srv-webdw)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dwsig)
    )
  )