Erman Arslan's Oracle Forum › Database

tnsmname error

Classic

List

Threaded

22 messages Options

Arsalan

tnsmname error

Salam bro

I want to connect to db remotely, but it give error ora-12170

i copy tnsname.ora file from source db,

and past on my client desktop when i try to connect it give error ora-12170

Kindly help

regard

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

Send me the "tnsping" and "sqlplus" outputs/screenshot which describe the error. Also send me your "t nsnames.ora" file.

26 Kas 2016 09:11 tarihinde "Arsala saleem [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Salam bro

I want to connect to db remotely, but it give error ora-12170

i copy tnsname.ora file from source db,

and past on my client desktop when i try to connect it give error ora-12170

Kindly help

regard

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-tp1621.html

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

Arsalan

Re: tnsmname error

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)
)
)

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

can your host resolve this hostname :srv-webdw

You can check with nslookup srv-webdw.

If you can't resolve it through DNS, put it in your hosts file (Windows host file)

In addition, ensure there is not firewall that blocking you.

Also ,Ensure your database server srv-webdw is not down.

Arsalan

Re: tnsmname error

Bro.

i edite host file on my client site ( 192.168.2.101 srv-webdw) --this is client site

and also

edite server host file on server (10.10.3.141 crd-sig1-arsala ) --this is server site

i copied tnsname.ora file from server and past on client so when we connect it give error

ora 12170

I did many practice to solve but i could not .. please find the technical solution.

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

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>

*Also ensure this is not a firewall issue..

2016-11-28 7:34 GMT+03:00 Arsala saleem [via Erman Arslan's Oracle Forum] <[hidden email]>:

Bro.

i edite host file on my client site ( 192.168.2.101 srv-webdw) --this is client site

and also

edite server host file on server (10.10.3.141 crd-sig1-arsala ) --this is server site

i copied tnsname.ora file from server and past on client so when we connect it give error

ora 12170

I did many practice to solve but i could not .. please find the technical solution.

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-tp1621p1626.html

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

Erman Arslan, MBA

Applications and Database Operations Manager

Oracle Certified Expert, Certified Exadata and Linux Administrator

Author, Practical Oracle E-Business Suite

Blog: ermanarslan.blogspot.com

Forum: http://ermanarslan.blogspot.com/p/forum.html

Mobile: 05301567803

Arsalan

Re: tnsmname error

The tnsname problem is solved..

i created one service name db

-DBNAME was (dwsig) and i created one service name (dwsigg)

now it work

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)
)
)

Thanks a lot

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

Good for you Arsala.
The output I requested would show you that.
Especially, lsnrctl status and lsnrctl services outputs.

Arsalan

Re: tnsmname error

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

Arsalan

Re: tnsmname error

Bro

Did you find any root solution.. for that i am waiting...

Thanks

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

Hi Arsala,

I don't see any issues here.

I see you can connect to the database from your client using "sqlplus system/DW12#a@dwsig"

Please show me what is failing..

Arsalan

Re: tnsmname error

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
-------------------------------------------------------------------------------------------------------------------

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

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

Erman Arslan, MBA

Applications and Database Operations Manager

Oracle Certified Expert, Certified Exadata and Linux Administrator

Author, Practical Oracle E-Business Suite

Blog: ermanarslan.blogspot.com

Forum: http://ermanarslan.blogspot.com/p/forum.html

Mobile: 05301567803

Arsalan

Re: tnsmname error

In reply to this post by ErmanArslansOracleBlog

Bro

one thing i forgot about telnet

systen adim toled me that telnet is not importent i don;t know that.

C:\Users\arsla>telnet SIG-DWH 1521
'telnet' is not recognized as an internal or external command,
operable program or batch file.

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

install telnet to your windows machine and send me the output that I m requesting from you.

I think the port 1521 between the db server and your client may be closed (a firewall issue)

Arsalan

Re: tnsmname error

Hi Arsalan

i disable firewall on server, I installed telnet on my client.. >> control panel > programs >windows features > and add client > ok

so after that

C:\Users\arsla>telnet SIG-DWH 1521
Connecting To SIG-DWH...Could not open connection to the host, on port 1521: Connect failed

and

tnsping also not working

C:\Users\arsla>tnsping dwsig

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-DEC-2016 11:41:59

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 = 192.168.0.101)(PORT = 1521))) (CONNECT_DATA = (SERVICE_
NAME = dwsig)))
TNS-12535: TNS:operation timed out

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

Send me the output of the following command Arsala. ( attention ! use ip in this command)

telnet 192.168.0.101 1521

2016-12-08 10:01 GMT+03:00 Arsala saleem [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi Arsalan

i disable firewall on server, I installed telnet on my client.. >> control panel > programs >windows features > and add client > ok

so after that

C:\Users\arsla>telnet SIG-DWH 1521
Connecting To SIG-DWH...Could not open connection to the host, on port 1521: Connect failed

and

tnsping also not working

C:\Users\arsla>tnsping dwsig

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 08-DEC-2016 11:41:59

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 = 192.168.0.101)(PORT = 1521))) (CONNECT_DATA = (SERVICE_
NAME = dwsig)))
TNS-12535: TNS:operation timed out

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-tp1621p1699.html

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

Erman Arslan, MBA

Applications and Database Operations Manager

Oracle Certified Expert, Certified Exadata and Linux Administrator

Author, Practical Oracle E-Business Suite

Blog: ermanarslan.blogspot.com

Forum: http://ermanarslan.blogspot.com/p/forum.html

Mobile: 05301567803

Arsalan

Re: tnsmname error

Hi Arsalan

Thanks bro for your quick response.

C:\Users\arsla>telnet 192.168.0.101 1521
Connecting To 192.168.0.101...Could not open connection to the host, on port 1521: Connect failed

ErmanArslansOracleBlog

Re: tnsmname error

Administrator

So, you cant reach the listener port as you see.

Send this output to your firewall and network admins, request the solution from them.

10 Ara 2016 07:29 tarihinde "Arsala saleem [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi Arsalan

Thanks bro for your quick response.

C:\Users\arsla>telnet 192.168.0.101 1521
Connecting To 192.168.0.101...Could not open connection to the host, on port 1521: Connect failed

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-tp1621p1719.html

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

Arsalan

Re: tnsmname error

Hi Arsalan

1- i checked firewall is disable

one thing i will tell you that i can not ping my ip 10.10.5.141 from server site.

the server IP range from 192.168.0.101 and my client ip range start from 10.10.5.141

if the range is difference does it create problem for connection. ?

still i have problem

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))) (CONNECT_DATA = (SERVICE_
NAME = dwhsig)))
TNS-12535: TNS:operation timed out