Posted by
Arsalan on
Dec 04, 2016; 6:31am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsmname-error-tp1621p1660.html
Bro. Arsalan
i got same problem once again then i give the output of your requirement please
find the root solution of this
Thanks
ARSALA
If you need assistance, you need to provide the details and requested info.
send me the following command outputs (executed from the client)
ping srv-webdw
nslookup srv-webdw
telnet srv-webdw 1521
send me the following command outputs (executed from the server)
sqlplus "/as sysdba" <--select * from v$instance;
sqlplus <user>/<password>@your_database_TNS_entry
lsnrctl status <your_listener_name>
lsnrctl services <your_listener_name>
-----------------------------------------------------------------------------------------------------------------
C:\Users\arsla>ping srv-webdw
Pinging srv-webdw [192.168.0.101] with 32 bytes of data:
Reply from 192.168.0.101: bytes=32 time=5ms TTL=125
Reply from 192.168.0.101: bytes=32 time=25ms TTL=125
Reply from 192.168.0.101: bytes=32 time=19ms TTL=125
Reply from 192.168.0.101: bytes=32 time=44ms 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 = 5ms, Maximum = 44ms, Average = 23ms
----------------------------------------
C:\Users\arsla>nslookup srv-webdw
Server: dc.cr.mof.gov.af
Address: 10.10.0.2
Non-authoritative answer:
Name: srv-webdw.mof.gov.af
Address: 103.23.247.13
-------------------------------------------------------
C:\Users\arsla>telnet srv-webdw 1521
Connecting To srv-webdw...Could not open connection to the host, on port 1521: Connect failed
-----------------------------------------------
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
dwsig
------------------------------------------------------------------------------------
C:\Users\arsala>sqlplus system/DW12#a@dwsig
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 4 11:05:08 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
-------------------------------------------------------------------------------------------------
C:\Users\arsala>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-DEC-2016 11:05:59
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 - Production
Start Date 04-DEC-2016 08:11:56
Uptime 0 days 2 hr. 54 min. 3 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\listener.ora
Listener Log File c:\app\arsala\diag\tnslsnr\srv-webdw\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
-------------------------------------------------------------------------------------------------
C:\Users\arsala>lsnrctl services listener
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-DEC-2016 11:08:2
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:34 refused:1
LOCAL SERVER
Instance "dwsig", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:208 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: SRV-WEBDW, pid: 2588>
(ADDRESS=(PROTOCOL=tcp)(HOST=srv-webdw)(PORT=49195))
The command completed successfully
------------------------------------------------
note i also add server ip and servername on client hostfile and also add on server host file add the
client ip and pc name like below
server side
10.10.5.141 crd-sig1-arsala
192.168.0.101 srv-webdw
------------------------------------------
client side
10.10.5.141 crd-sig1-arsala
192.168.0.101 srv-webdw