Folks,Tamil,Pando &/..team
we have a problem pls look into this.We have a connection pooling from middle tier application which opens around 400 connections to database running on 8.1.5 whenever there is a small problem on db which we may need to rebounce then all the apllication connections will be lost.for that we need to restart all the middle tier servers manually which is a big pain.Is there anything in oracle which tries to reconnect to db after few secs/mins and reconnects automatically instead of giving error"end of communication channel".
i have read about Transparent Application failover-which tries to reconnects but its not working at my side.I m giving my listener file(i have configured two listeners for same instance)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = johnnyboy)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = johnnyboy)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/8.1.5)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = pvnet)
(ORACLE_HOME = /u01/app/oracle/8.1.5)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = johnnyboy)(PORT = 1525))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = johnnyboy)(PORT = 2489))
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/8.1.5)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = pvnet)
(ORACLE_HOME = /u01/app/oracle/8.1.5)
)
)
CONNECT_TIMEOUT=0

and my tnsnames.ora file lokks like this
PVNET =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.32.22)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.32.22)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = pvnet)
(failover_mode=
(type=session)
(method=basic)
(retries=20)
(delay=30)
)
)
)
Do you guys notice any problem in this.or do i need to do something other than this.Thanks for ur help