I have an Application developed on vb.net with oracle 8i as the backend. all was working fine but when i shifted the DB to a new winserver2003 server we started getting some oracle errors ..occasionally.. I am giving the error code below. need help in sorting the issue out
ORA-12571: TNS:packet writer failure
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort subheap,sort key)
ORA-06512: at "ART.SP_ACCOUNTS_VOUCHER", line 100
ORA-06512: at line 1
ORA-12500: TNS:listener failed to start a dedicated server process
ORA-03113: end-of-file on communication channel
18 freelancers are bidding on average $44 for this job
I am not sure that error is easy error and can be solved with some configurations. I need to investigate the issue and than i can give to you the solution.