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.