Re: tnsmname error
Posted by Arsalan on Dec 06, 2016; 11:02am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsmname-error-tp1621p1683.html
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
-------------------------------------------------------------------------------------------------------------------