Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Rookie Error?
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:
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_at_sherlock admin]$ sqlplus system/password_at_ts11
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.
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.
---Received on Sun Nov 28 2004 - 01:09:50 CST
[root_at_sherlock root]# /etc/init.d/iptables status
Firewall is stopped.
[root_at_sherlock root]# /etc/init.d/ip6tables status
Firewall is stopped.
[root_at_sherlock root]#
---- Any ideas? Thanks, -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l
![]() |
![]() |