Rookie Error? 2004-11-28 - By Jared Still
Ok, I 'm probably missing something obvious.
Environment:
Server 1:
RedHat 9.0
2.4.20-8 kernel
Oracle 10.1.0.2
Server 2:
White Box 3.0 Respin 1
2.4.21-15.EL kernel
Oracle 10.1.0.2
I can succussfully ssh between each box
I can successfuly tnsping and connect via sqlnet from server 2
to server 1.
I *cannot* successfully tnsping and connect via sqlnet from
server 1 to server 2.
The consistent error is tns-12541 ( no listener )
Setting up the listener on server 2 so that local connections
will use TCP allows a connection:
-- --- local connect via TCP
[oracle@(protected) admin]$ tnsping ts11
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on
27-NOV-2004 23:03:28
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.1.0/ts11/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = sherlock)(PORT = 1522))) (CONNECT_DATA =
(SERVER = DEDICATED) (SERVICE_NAME = ts11)))
OK (10 msec)
[oracle@(protected) admin]$ sqlplus system/password@(protected)
SQL*Plus: Release 10.1.0.2.0 - Production on Sat Nov 27 23:03:34 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL >
-- ---- ---- ---- ------
Any attempt to do this from server 1 will result in an ora-12541 (See ora-12541.ora-code.com).
I 've double checked the port assignments (1522), etc.
Even using a literal connect string of:
tnsping "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =
TCP)(HOST = sherlock)(PORT = 1522))) (CONNECT_DATA = (SERVER =
DEDICATED)
(SERVICE_NAME = ts11))) "
... works from server 2
but not from server 1.
Using strace -aef on the listener shows absolutely no activity when
a remote connection is attempted, as if server 2 were rejecting all
packets to port 1522 ( or either of 1521 and 20000, which I also tested)
The firewall is off.
---
[root@(protected) root]# /etc/init.d/iptables status
Firewall is stopped.
[root@(protected) root]# /etc/init.d/ip6tables status
Firewall is stopped.
[root@(protected) root]#
----
Any ideas?
Thanks,
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
|
|
