Re: Rookie Error?

Have you set trace_level_client=admin in your sqlnet.ora to see what that tells you?

--Terry

• Original Message ----- From: "Jared Still" <jkstill_at_gmail.com> To: "Oracle-L Freelists" <oracle-l_at_freelists.org> 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_at_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_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.

---


[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

--
http://www.freelists.org/webpage/oracle-l