Re: tnsmname error

Posted by ErmanArslansOracleBlog on Dec 06, 2016; 11:07am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsmname-error-tp1621p1684.html

Send me the output of the following command;

telnet 192.168.0.101 1521

Execute it from the client on which you are executing the sqlplus.

2016-12-06 14:02 GMT+03:00 Arsala saleem [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi Erman-ARSALAN

I tried to connect from client  but i could'nt  kindly check the below error.

--note the server have been change from srv-webdw to SIG-DWH


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

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 6 15:41:11 2016

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

ERROR:
ORA-12170: TNS:Connect timeout occurred


Enter user-name:

Dear Erman -Arsala

C:\Users\arsla>ping SIG-DWH

Pinging SIG-DWH [192.168.0.101] with 32 bytes of data:
Reply from 192.168.0.101: bytes=32 time=17ms TTL=125
Reply from 192.168.0.101: bytes=32 time=16ms TTL=125
Reply from 192.168.0.101: bytes=32 time=1ms TTL=125
Reply from 192.168.0.101: bytes=32 time=39ms TTL=125

Ping statistics for 192.168.0.101:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 1ms, Maximum = 39ms, Average = 18ms
-------------------------------------------------------------------------------

C:\Users\arsla>nslookup SIG-DWH
Server:  dc.cr.mof.gov.af
Address:  10.10.0.2

Non-authoritative answer:
Name:    sig-dwh.mof.gov.af
Address:  103.23.247.13
-------------------------------------------------------------------------------
C:\Users\arsla>sqlplus system/DW12#a@dwsig

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 6 15:29:57 2016

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

ERROR:
ORA-12170: TNS:Connect timeout occurred
-------------------------------------------------------------------------------
tnsname.ora
----------------

DWSIGG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dwsig)
    )
  )

DWSIG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dwsig)
    )
  )
-------------------------------------------------------------------------------------------------------
C:\Windows\system32>lsnrctl services listener

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-DEC-2016 15:33
:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.101)(PORT=1521
)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "dwsig" has 2 instance(s).
  Instance "dwsig", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "dwsig", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "dwsigXDB" has 1 instance(s).
  Instance "dwsig", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: SIG-DWH, pid: 2480>
         (ADDRESS=(PROTOCOL=tcp)(HOST=SIG-DWH)(PORT=49178))
The command completed successfully
-------------------------------------------------------------------------------------------------------------------
C:\Windows\system32>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-DEC-2016 15:35
:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.101)(PORT=1521
)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                06-DEC-2016 15:26:04
Uptime                    0 days 0 hr. 9 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\arsala\product\11.2.0\dbhome_1\network\admin\li
stener.ora
Listener Log File         c:\app\arsala\diag\tnslsnr\SIG-DWH\listener\alert\log.
xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.101)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dwsig" has 2 instance(s).
  Instance "dwsig", status UNKNOWN, has 1 handler(s) for this service...
  Instance "dwsig", status READY, has 1 handler(s) for this service...
Service "dwsigXDB" has 1 instance(s).
  Instance "dwsig", status READY, has 1 handler(s) for this service...
The command completed successfully
-------------------------------------------------------------------------------------------------------------------
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
dwsig
-------------------------------------------------------------------------------------------------------------------

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/tnsmname-error-tp1621p1683.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--