Re: RAC and tcp timeout

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 9 Aug 2005 20:59:10 +0100
Message-ID: <be592d5505080912591720c641@mail.gmail.com>

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_at_perftuning.com> 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_at_gmail.com>:
> 
> > 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
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> 
> 
> Bryan Thomas
> Senior Performance Consultant
> Performance Tuning Corporation
> www.perftuning.com
> (512)751-5516
> bthomas_at_perftuning.com
> 
> 
>

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

Received on Tue Aug 09 2005 - 15:01:16 CDT