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?


----- 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.


Server 1:
RedHat 9.0
2.4.20-8 kernel

Server 2:
White Box 3.0 Respin 1
2.4.21-15.EL kernel

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 - Production on
27-NOV-2004 23:03:28

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = sherlock)(PORT = 1522))) (CONNECT_DATA =
OK (10 msec)
[oracle@sherlock admin]$ sqlplus system/password@ts11

SQL*Plus: Release - 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 - Production
With the Partitioning, OLAP and Data Mining options


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:

TCP)(HOST = sherlock)(PORT = 1522))) (CONNECT_DATA = (SERVER =
(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?


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Other related posts: