This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
By following your suggestions I googled many posts and found that I was not closing connection that was opening too many processes in Oracle that were causing this error. I closed connection to each class and now its fixed.