Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rookie Error?

Re: Rookie Error?

From: Oracle <all_about_oracle_at_hotpop.com>
Date: Sun, 28 Nov 2004 16:50:16 +0800
Message-ID: <000a01c4d527$4bff7450$cc259cca@SINARDY>


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

> 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
Received on Sun Nov 28 2004 - 02:48:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US