Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot Tnsping, Telnet to DB on Linux 3 Sever - Ports not open

394653Nov 17 2004 — edited Nov 20 2004

I have installed 10g DB server on Linux 3. The DB is running properly. However when I do a TNSPING/Telnet from a windows client I am unable to connect. I can ping the server from the client and vice versa.
The following are the results:

--------------------
sqlnet.ora file on the client:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\db\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

---------------------------------------------------------------------
tnsnames.ora file on the client:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

infr2 =
(description =
(address_list = (address = (protocol = tcp)(host = 192.168.0.102)(port = 1521)))
(connect_data = (sid = infr2)))

# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1521))
# (CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME = infr2)
# )
# )

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----------------------
LISTENER is running on the server.

-----------------------
PING RESULTS FROM SERVER TO CLIENT: Successful

[root@infr2 etc]#ping 192.168.0.100
PING 192.168.0.100 (192.168.0.100) 56(84) bytes of data.
64 bytes from 192.168.0.100: icmp_seq=0 tt1=128 time=0.279ms
..
..
6 packets transmitted, 6 recieved, 0% packet loss, time 5013ms

------------------------
PING RESULTS FROM CLIENT TO SERVER - Successful

C:\Documents and Settings\natik>ping 192.168.0.102
Pinging 192.168.0.102 with 32 bytes of data:

Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64
Reply from 192.168.0.102: bytes=32 time<1ms TTL=64

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

---------------------
TNSPING Result – Fail

C:\Documents and Settings\natik>tnsping infr2
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-NOV-2
004 10:18:42

Copyright © 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.1.0\db\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (description = (address_list = (address = (protocol = tcp)
(host = 192.168.0.102)(port = 1521))) (connect_data = (sid = infr2)))
TNS-12560: TNSprotocol adapter error

Telnet result - Fail

On Telneting to see if the port is open I get:

C:\WINDOWS\system32>telnet infr2.localdomain.com 1521
Connecting To infr2.localdomain.com...Could not open connection to the host, on port 1521: Connect failed

-----------------------------
I have flushed the rules from the iptables. There are no rules set right now, but still getting failure.

The TNSPING and TELNET is not getting through any ideas. Seems like that the port 1521 is blocked. How do I open it.?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2004
Added on Nov 17 2004
2 comments
2,204 views