Have you set trace_level_client=admin in your sqlnet.ora to see what that tells you? --Terry ----- Original Message ----- From: "Jared Still" <jkstill@xxxxxxxxx> To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx> Sent: Saturday, November 27, 2004 11:13 PM Subject: 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: ------ local connect via TCP [oracle@sherlock 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@sherlock admin]$ sqlplus system/password@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. --- [root@sherlock root]# /etc/init.d/iptables status Firewall is stopped. [root@sherlock root]# /etc/init.d/ip6tables status Firewall is stopped. [root@sherlock root]# ---- Any ideas? Thanks, -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l