I have this SLES9 running oracle 10g for about a year now for development/
testing purposes. It was running fine for a long time.

However, recently our application went into production and 10 client JDBC
connect to the server via jdbc. I start getting the follwing error on my
listener log

TNS-12516: TNS:listener could not find available handler with matching
protocol stack


The following message in on the client side..

The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)
(HOST=miller.polyscientific.com.m
y))(CONNECT_DATA=(SERVICE_NAME=compiere.polyscientific.com.my)))
[95]
===========> DB_Oracle.getCachedConnection: java.sql.SQLException: Listener
refu
sed the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching
protocol
stack
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)
(HOST=miller.polyscientific.com.m
y))(CONNECT_DATA=(SERVICE_NAME=compiere.polyscientific.com.my)))
[95]
===========> CConnection.getConnection:
jdbc:oracle:thin:@(protected)
c.com.my:1521/compiere.polyscientific.com.my, (1)
AutoCommit=false,TrxIso=READ_C
OMMITTED - Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching
protocol
stack
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)
(HOST=miller.polyscientific.com.m
y))(CONNECT_DATA=(SERVICE_NAME=compiere.polyscientific.com.my)))
[95]
===========> CPreparedStatement.<init>: UPDATE M_Inventory SET
DocStatus='IP',Up
dated=TO_DATE('2006-04-06 10:46:07','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=106514
WH
ERE M_Inventory_ID=1000318 [95]
org.compiere.util.DBException: No Connection
    at
org.compiere.util.CPreparedStatement.<init>(CPreparedStatement.java:6
9)
    at org.compiere.util.DB.executeUpdate(DB.java:674)
    at org.compiere.util.DB.executeUpdate(DB.java:645)
    at org.compiere.model.PO.saveUpdate(PO.java:1775)
    at org.compiere.model.PO.save(PO.java:1512)


What could be the source of the problem?


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting