Re: RAC and tcp timeout
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: Bryan Thomas <bthomas@xxxxxxxxxxxxxx>, K Gopalakrishnan <kaygopal@xxxxxxxxx>
- Date: Tue, 9 Aug 2005 20:59:10 +0100
Hi, thanks for replying. Suppiled listener entries from node which is
working - cant get at other one (names changed though)
there is no TAF here (problem is with new connection, using sqlplus as
an example - app uses jdbc (AS 10g))
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
)
)
LISTENER_db2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/ora92)
(SID_NAME = db2)
)
)
tnsnames.ora
db=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db)
)
)
more interested in how jdbc works though as though it what my app uses
Thanks
On 8/9/05, Bryan Thomas <bthomas@xxxxxxxxxxxxxx> wrote:
> Hi David,
> The question is, what type of connection string are you using to connect to
> the
> instance? Are you using TAF? If so what type.
>
> You may be using the delay and retries. This could make all connections to
> server1 wait until they timeout until trying to connect to server2.
>
> -Bryan
>
> Quoting David Sharples <davidsharples@xxxxxxxxx>:
>
> > HI,
> >
> > Redhat 2.1, 9.2.0.5, 2 Node RAC.
> >
> > 2 servers, server1 and server2
> >
> > server1 has died so all requests for connection are going to server
> > two. However new connections are taking somewhere around 3 minutes to
> > get in.
> >
> > tnsping also takes around the same time.
> >
> > The server2 isn't overloaded (there are no connections).
> >
> > Does this sound like a tcp timeout issue where the connection is
> > waiting too long for a no connection type message. If so which
> > setting(s) could it be?
> >
> > Or could it be something else. The listener setup looks fine on
> > visyal inspection
> >
> > Thanks
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
> Bryan Thomas
> Senior Performance Consultant
> Performance Tuning Corporation
> www.perftuning.com
> (512)751-5516
> bthomas@xxxxxxxxxxxxxx
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
