Re: Rookie Error?

Hi Jared,

I assume those servers can ping each other.

for Server 1 -> 2
Since you are so sure that your listener is ok perhaps you want check your
tnsnames.ora at server 1
just make sure that at your "pwd" no tnsnames.ora that I think technically
it will "over-rule" $ORACLE_HOME/network/admin/

to test your listener at server 2 test login or tnsping from the server 2
directly if this passed you can narrow down to tnsnames.ora setting at your
client.


Sinardy

----- Original Message ----- 
From: "Jared Still" <jkstill@xxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, November 28, 2004 3: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
> --
> http://www.freelists.org/webpage/oracle-l


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

Other related posts: