Re: Rookie Error?

  • From: "Terry Sutton" <terrysutton@xxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 28 Nov 2004 13:19:33 -0800

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

Other related posts: