Hi,
We experience the following problem: 2 java pools of 5 (to 30max)
connections open sessions on our DB server and close/release them each
4 minutes, sometimes the opened connections seems to not be released
and the Java pool seems to claim sessions until there is no more free
port on the server and after we get a TNS-12500-12540 error.
We tried some JVM but the problem is againd here.
If someone get this kind of problem any answer is welcome.
I've enclosed a summary of our listener log and our listener config
Best regards
Fred
- Listener LOG
05-NOV-2001 09:41:38 *
(connect_data=(sid=int15)(CID=(PROGRAM=C:\ibm\java13\bin\java.exe)(HOST=S040W005)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.5)(PORT=1348)) * establish *
int15 * 0
05-NOV-2001 09:41:40 *
(connect_data=(sid=int15)(CID=(PROGRAM=C:\ibm\java13\bin\java.exe)(HOST=S040W005)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.5)(PORT=1351)) * establish *
int15 * 0
05-NOV-2001 09:41:40 *
(connect_data=(sid=int15)(CID=(PROGRAM=C:\ibm\java13\bin\java.exe)(HOST=S040W005)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.5)(PORT=1354)) * establish *
int15 * 0
05-NOV-2001 09:41:48 *
(connect_data=(sid=int15)(CID=(PROGRAM=C:\ibm\java13\bin\java.exe)(HOST=S040W005)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.5)(PORT=1357)) * establish *
int15 * 0
05-NOV-2001 09:41:51 *
(connect_data=(sid=int15)(CID=(PROGRAM=C:\ibm\java13\bin\java.exe)(HOST=S040W005)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.5)(PORT=1360)) * establish *
int15 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
05-NOV-2001 09:41:53 *
(connect_data=(sid=int15)(CID=(PROGRAM=C:\ibm\java13\bin\java.exe)(HOST=S040W005)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.5)(PORT=1361)) * establish *
int15 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error
- Listener config
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s096a015)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = s096a015)(PORT = 2789))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=(GLOBAL_DBNAME=s096a015)(SID_NAME=devserver))
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora81)
(PROGRAM = extproc)
)
)
TRACE_LEVEL_LISTENER=ON
Received on Mon Nov 19 2001 - 02:26:01 CST