Originally posted by santhoshkumar samala:
yes.. i have closed all the connections in finally
Hmm. Just noticed ORA-00604 happens first. So it looks like something is using up the available sessions as a result of your application connecting. What are you doing when this error occurs? Does it happen as soon as you connect? Does your schema have a trigger associated with it?